DBA Data[Home] [Help]

APPS.HZ_IMP_MATCH_RULE_52 dependencies on HZ_PARTIES

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

311: and b.batch_mode_flag = p_batch_mode_flag
312: and a.interface_status is null
313: union all
314: 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
315: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b, hz_parties c
316: where a.batch_id = p_batch_id
317: and b.action_flag = 'I'
318: and b.int_row_id = a.rowid
319: and a.sub_orig_system_reference >= p_from_osr