APPS.CZ_IMP_PS_NODE dependencies on CZ_IMP_ITEM_PROPERTY_VALUE

Line 222: AND EXISTS(SELECT NULL FROM cz_imp_item_property_value

218: CURSOR c_tl_onl_intl_text IS
219: SELECT ol.intl_text_id,ol.localized_str, ol.orig_sys_ref
220: FROM cz_localized_texts ol
221: WHERE ol.orig_sys_ref = sImpOrigSysRef(i)
222: AND EXISTS(SELECT NULL FROM cz_imp_item_property_value
223: WHERE run_id = inRUN_ID AND FSK_LOCALIZEDTEXT_3_1=ol.ORIG_SYS_REF)
224: AND ol.deleted_flag = '0';
225:
226: BEGIN

Line 249: SELECT COUNT(*) INTO var_tl_prop FROM cz_imp_item_property_value

245: ELSE /* insert */
246:
247: BEGIN --#####
248:
249: SELECT COUNT(*) INTO var_tl_prop FROM cz_imp_item_property_value
250: WHERE run_id = inRUN_ID AND FSK_LOCALIZEDTEXT_3_1=sImpOrigSysRef(i) AND rownum<2;
251:
252: IF var_tl_prop > 0 THEN
253: