APPS.HZ_IMP_MATCH_RULE_52 dependencies on HZ_IMP_CONTACTPTS_SG

Line 222: from HZ_IMP_CONTACTPTS_INT a, HZ_IMP_CONTACTPTS_SG b --

218: l_cp_cur HZ_PARTY_STAGE.StageCurTyp;
219: BEGIN
220: open l_cp_cur for
221: select a.EMAIL_ADDRESS, a.URL, a.party_orig_system, a.party_orig_system_reference, a.cp_orig_system, a.cp_orig_system_reference, a.site_orig_system, a.site_orig_system_reference, b.party_site_id, b.contact_point_id, b.party_id, b.party_action_flag, a.rowid, a.contact_point_type, decode(a.raw_phone_number, null, a.PHONE_COUNTRY_CODE||a.PHONE_AREA_CODE ||a.phone_number, a.raw_phone_number) as raw_phone_number
222: from HZ_IMP_CONTACTPTS_INT a, HZ_IMP_CONTACTPTS_SG b --
223: where a.batch_id = p_batch_id
224: and b.action_flag = 'I'
225: and b.int_row_id = a.rowid
226: and b.party_orig_system_reference >= p_from_osr