DBA Data[Home] [Help]

APPS.IGF_AP_PROCESS_CORRECTIONS dependencies on HZ_PARTIES

Line 93: hz_parties pe

89: SELECT isirm.isir_id, isirm.s_email_address, isirm.transaction_num, isirm.original_ssn,
90: isirm.orig_name_id, isirm.first_name, isirm.last_name, isirm.base_id, PE.party_number person_number
91: FROM igf_ap_isir_matched_all isirm,
92: igf_ap_fa_base_rec_all far,
93: hz_parties pe
94: WHERE isirm.base_id = far.base_id
95: AND far.person_id = pe.party_Id
96: AND isirm.system_record_type = 'ORIGINAL'
97: AND isirm.base_id = NVL(p_base_id, isirm.base_id)