APPS.CZ_IMP_IM_KRS dependencies on CZ_IMP_LOCALIZED_TEXTS

Line 317: AND NOT EXISTS (SELECT NULL FROM cz_imp_localized_texts

313: SELECT orig_sys_ref FROM cz_imp_item_property_value a
314: WHERE run_id=inRUN_ID AND EXISTS(SELECT NULL FROM cz_imp_property
315: WHERE run_id=inRUN_ID AND property_id=a.property_id AND
316: data_type=8 AND deleted_flag='0')
317: AND NOT EXISTS (SELECT NULL FROM cz_imp_localized_texts
318: WHERE run_id=inRUN_ID AND orig_sys_ref = DECODE(x_usesurr_itempropertyvalue,0,a.FSK_LOCALIZEDTEXT_3_1,a.FSK_LOCALIZEDTEXT_3_EXT)
319: AND deleted_flag='0');
320:
321: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */

Line 361: SET property_num_value=(SELECT DISTINCT intl_text_id FROM cz_imp_localized_texts

357: --------------------- New code ------------------------------------
358:
359: FORALL i IN iOrigSysRef.FIRST..iOrigSysRef.LAST
360: UPDATE cz_imp_item_property_value a
361: SET property_num_value=(SELECT DISTINCT intl_text_id FROM cz_imp_localized_texts
362: WHERE run_id=inRUN_ID AND orig_sys_ref = a.FSK_LOCALIZEDTEXT_3_1
363: AND deleted_flag='0'),
364: disposition='M',
365: rec_status='PASS'

Line 371: AND EXISTS (SELECT NULL FROM cz_imp_localized_texts

367: AND orig_sys_ref=iOrigSysRef(i)
368: AND EXISTS(SELECT NULL FROM cz_imp_property
369: WHERE run_id=inRUN_ID AND property_id=iPropertyId(i) AND
370: data_type=8 AND deleted_flag='0')
371: AND EXISTS (SELECT NULL FROM cz_imp_localized_texts
372: WHERE run_id=inRUN_ID AND orig_sys_ref = a.FSK_LOCALIZEDTEXT_3_1
373: AND deleted_flag='0');
374:
375: COMMIT;