APPS.IGF_AP_PROCESS_CORRECTIONS dependencies on IGF_AP_ISIR_MATCHED_ALL

Line 91: FROM igf_ap_isir_matched_all isirm,

87: -- Bug 4403807 - removed the condition isir.payment_isir = 'Y'
88: CURSOR match_isirs (p_base_id NUMBER) IS
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

Line 163: FROM igf_ap_isir_matched_all

159: assum_override_3,
160: assum_override_4,
161: assum_override_5,
162: assum_override_6
163: FROM igf_ap_isir_matched_all
164: WHERE base_id = gn_baseid
165: AND system_record_type = 'ORIGINAL'
166: AND payment_isir = 'Y';
167:

Line 1214: FROM igf_ap_isir_matched_all

1210: AND isir.batch_year = gv_batch_year ;
1211:
1212: CURSOR c_get_corr_isir(cp_base_id NUMBER) IS
1213: SELECT s_email_address
1214: FROM igf_ap_isir_matched_all
1215: WHERE system_record_type='CORRECTION'
1216: AND base_id = cp_base_id;
1217:
1218: l_get_corr_isir c_get_corr_isir%ROWTYPE;