DBA Data[Home] [Help]

APPS.HZ_IMP_MATCH_RULE_52 dependencies on HZ_IMP_PARTIES_SG

Line 92: from hz_imp_parties_int a, hz_imp_parties_sg b

88: BEGIN
89: -- query for interface to TCA
90: open p_party_cur FOR
91: 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.DUNS_NUMBER_C, a.JGZZ_FISCAL_CODE, a.party_orig_system, a.party_orig_system_reference, b.party_id, a.rowid, a.party_type
92: from hz_imp_parties_int a, hz_imp_parties_sg b
93: where b.action_flag = 'I'
94: and b.int_row_id = a.rowid
95: and a.batch_id = p_batch_id
96: and b.party_orig_system_reference >= p_from_osr