APPS.IGF_AP_ISIR_IMPORT_PKG dependencies on IGF_AP_BATCH_AW_MAP

Line 20: g_batch_year igf_ap_batch_aw_map.batch_year%TYPE;

16: l_document VARCHAR2(4000);
17: l_document_type VARCHAR2(4000);
18:
19: -- added by rgangara as part of FA138 enh
20: g_batch_year igf_ap_batch_aw_map.batch_year%TYPE;
21: g_match_code igf_ap_record_match_all.match_code%TYPE;
22: g_rec_status igf_ap_isir_ints_all.record_status%TYPE;
23: g_rec_type igf_ap_isir_ints_all.processed_rec_type%TYPE;
24: g_message_Class igf_ap_isir_ints_all.data_file_name_txt%TYPE;

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.

Line 324: FROM igf_ap_batch_aw_map

320: */
321:
322: CURSOR cur_batch_aw_map(cp_batch_yr NUMBER) IS
323: SELECT 'Y'
324: FROM igf_ap_batch_aw_map
325: WHERE batch_year = cp_batch_yr;
326:
327: CURSOR cur_lookups(cp_lkup_type igf_lookups_view.lookup_type%TYPE,
328: cp_lkup_code igf_lookups_view.lookup_code%TYPE) IS

Line 1573: FROM igf_ap_batch_aw_map map,

1569: sar.sar_field_name column_name,
1570: corr.corrected_value,
1571: corr.correction_status ,
1572: lkup.meaning meaning
1573: FROM igf_ap_batch_aw_map map,
1574: igf_ap_fa_base_rec_all fabase,
1575: igf_ap_ISIR_corr corr,
1576: Igf_fc_sar_cd_mst sar ,
1577: igf_lookups_view lkup