APPS.HZ_IMP_MATCH_RULE_52 dependencies on HZ_IMP_CONTACTS_SG

Line 302: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b, HZ_IMP_PARTIES_INT c

298: CLOSE c1;
299: IF (is_using_allow_cust_attr = 'Y') THEN
300: OPEN x_contact_cur FOR
301: 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.person_first_name || ' ' || c.person_last_name as person_name
302: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b, HZ_IMP_PARTIES_INT c
303: where a.batch_id = p_batch_id
304: and b.action_flag = 'I'
305: and b.int_row_id = a.rowid
306: and a.sub_orig_system_reference >= p_from_osr

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

Line 328: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b

324: ;
325: ELSE
326: OPEN x_contact_cur FOR
327: 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
328: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b
329: where a.batch_id = p_batch_id
330: and b.action_flag = 'I'
331: and b.int_row_id = a.rowid
332: and a.sub_orig_system_reference >= p_from_osr