APPS.HZ_IMP_MATCH_RULE_51 dependencies on HZ_IMP_PARTIES_INT

Line 79: from hz_imp_parties_int a, hz_imp_parties_sg b

75: BEGIN
76: -- query for interface to TCA
77: open p_party_cur FOR
78: select decode(a.party_type, 'ORGANIZATION', a.organization_name, 'PERSON', a.person_first_name || ' ' || a.person_last_name) as PARTY_NAME , a.PARTY_TYPE, a.JGZZ_FISCAL_CODE, a.party_orig_system, a.party_orig_system_reference, b.party_id, a.rowid, a.party_type
79: from hz_imp_parties_int a, hz_imp_parties_sg b
80: where b.action_flag = 'I'
81: and b.int_row_id = a.rowid
82: and a.batch_id = p_batch_id
83: and b.party_orig_system_reference >= p_from_osr

Line 308: from hz_imp_parties_int a

304: BEGIN
305: l_os := HZ_IMP_DQM_STAGE.get_os(p_batch_id);
306: open p_party_cur FOR
307: select decode(a.party_type, 'ORGANIZATION', a.organization_name, 'PERSON', a.person_first_name || ' ' || a.person_last_name) as PARTY_NAME , a.PARTY_TYPE, a.JGZZ_FISCAL_CODE, a.party_orig_system, a.party_orig_system_reference, a.rowid, a.party_type , a.party_id
308: from hz_imp_parties_int a
309: where a.batch_id = p_batch_id
310: and a.party_orig_system_reference >= p_from_osr
311: and a.party_orig_system_reference <= p_to_osr
312: and a.party_orig_system = l_os;