DBA Data[Home] [Help]

APPS.HZ_IMP_MATCH_RULE_50 dependencies on HZ_IMP_PARTIES_SG

Line 91: from hz_imp_parties_int a, hz_imp_parties_sg b

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