DBA Data[Home] [Help]

APPS.HZ_IMP_MATCH_RULE_50 dependencies on HZ_PARTIES

Line 314: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b, hz_parties c

310: and b.batch_mode_flag = p_batch_mode_flag
311: and a.interface_status is null
312: union all
313: select a.JOB_TITLE, a.obj_orig_system, a.obj_orig_system_reference, a.contact_orig_system, a.contact_orig_system_reference, b.party_action_flag, a.rowid, b.obj_id, c.party_name as person_name
314: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b, hz_parties c
315: where a.batch_id = p_batch_id
316: and b.action_flag = 'I'
317: and b.int_row_id = a.rowid
318: and a.sub_orig_system_reference >= p_from_osr