APPS.IGF_AP_ISIR_IMPORT_PKG dependencies on IGF_AP_BATCH_AW_MAP_ALL

Line 214: FROM igf_ap_batch_aw_map_all

210:
211: CURSOR c_batch(cp_cal_type VARCHAR2,
212: cp_seq_number NUMBER) IS
213: SELECT batch_year
214: FROM igf_ap_batch_aw_map_all
215: WHERE ci_cal_type = cp_cal_type
216: AND ci_sequence_number = cp_seq_number;
217:
218: l_batch c_batch%ROWTYPE;

Line 225: l_batch_year igf_ap_batch_aw_map_all.batch_year%TYPE;

221: ln_total_rec NUMBER := 0;
222:
223: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
224: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
225: l_batch_year igf_ap_batch_aw_map_all.batch_year%TYPE;
226:
227: g_parent_req_number NUMBER;
228: ------------------------------------------------------------
229: -- Begin of Local new Procedures created for FA138 build - rgangara.