APPS.CZ_IMP_IM_KRS dependencies on CZ_IMP_LOCALIZED_TEXTS

Line 369: AND NOT EXISTS (SELECT NULL FROM cz_imp_localized_texts

365: SELECT orig_sys_ref FROM cz_imp_item_property_value a
366: WHERE run_id=inRUN_ID AND EXISTS(SELECT NULL FROM cz_imp_property
367: WHERE run_id=inRUN_ID AND property_id=a.property_id AND
368: data_type=8 AND deleted_flag='0')
369: AND NOT EXISTS (SELECT NULL FROM cz_imp_localized_texts
370: WHERE run_id=inRUN_ID AND orig_sys_ref = DECODE(x_usesurr_itempropertyvalue,0,a.FSK_LOCALIZEDTEXT_3_1,a.FSK_LOCALIZEDTEXT_3_EXT)
371: AND deleted_flag='0');
372:
373: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */

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

410: --------------------- New code ------------------------------------
411:
412: FORALL i IN iOrigSysRef.FIRST..iOrigSysRef.LAST
413: UPDATE cz_imp_item_property_value a
414: SET property_num_value=(SELECT DISTINCT intl_text_id FROM cz_imp_localized_texts
415: WHERE run_id=inRUN_ID AND orig_sys_ref = a.FSK_LOCALIZEDTEXT_3_1
416: AND deleted_flag='0'),
417: disposition='M',
418: rec_status='PASS'

Line 424: AND EXISTS (SELECT NULL FROM cz_imp_localized_texts

420: AND orig_sys_ref=iOrigSysRef(i)
421: AND EXISTS(SELECT NULL FROM cz_imp_property
422: WHERE run_id=inRUN_ID AND property_id=iPropertyId(i) AND
423: data_type=8 AND deleted_flag='0')
424: AND EXISTS (SELECT NULL FROM cz_imp_localized_texts
425: WHERE run_id=inRUN_ID AND orig_sys_ref = a.FSK_LOCALIZEDTEXT_3_1
426: AND deleted_flag='0');
427:
428: COMMIT;