APPS.IGF_AP_PROCESS_CORRECTIONS dependencies on IGF_AP_ISIR_MATCHED

Line 30: gv_s_email igf_ap_isir_matched.s_email_address%TYPE;

26: */
27:
28:
29: gn_isir_id igf_ap_isir_corr.isir_id%TYPE;
30: gv_s_email igf_ap_isir_matched.s_email_address%TYPE;
31: gv_corr_rec VARCHAR2(1000);
32: gv_trailer VARCHAR2(1000);
33: gv_header VARCHAR2(1000);
34: gn_cnt NUMBER;

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 124: FROM igf_ap_isir_matched

120: assum_override_3,
121: assum_override_4,
122: assum_override_5,
123: assum_override_6
124: FROM igf_ap_isir_matched
125: WHERE base_id = gn_baseid
126: AND system_record_type = cp_rec_type ;
127:
128: corr_isir_rec cur_corr_isir%ROWTYPE ;

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 1206: igf_ap_isir_matched isir

1202: -- Bug 4403807 - removed the condition isir.payment_isir = 'Y'
1203: CURSOR get_cnt ( cp_corr_stat VARCHAR2) IS
1204: SELECT COUNT(*)
1205: FROM igf_ap_isir_corr corr,
1206: igf_ap_isir_matched isir
1207: WHERE corr.correction_status = cp_corr_stat
1208: AND corr.isir_id = isir.isir_id
1209: AND isir.system_record_type = 'ORIGINAL'
1210: AND isir.batch_year = gv_batch_year ;

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;