tune UPDATE

[balajiyes]

UPDATE TMP_PERF_CRLIMIT a
SET a.occ_com_map_code = (SELECT b.occ_com_map_code
FROM MV_REF_OCC_COM_MAP b
WHERE a.process_seq_no = v_seq_no
AND a.emplm_type_code = b.occ_code
AND a.se_emplm_code = b.company_type_code
AND a.emplm_type_code = ICconstant.EMPL_TYPE_SELFEMPLOYED)
WHERE EXISTS(
SELECT 'X'
FROM MV_REF_OCC_COM_MAP b
WHERE a.process_seq_no = v_seq_no
AND a.emplm_type_code = b.occ_code
AND a.se_emplm_code = b.company_type_code
AND a.emplm_type_code = ICconstant.EMPL_TYPE_SELFEMPLOYED) ;