APPS.IGF_AW_GEN_002 dependencies on IGF_AP_BATCH_AW_MAP

Line 1290: FROM igf_ap_batch_aw_map

1286: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1287: cp_seq_num igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
1288: ) IS
1289: SELECT sys_award_year
1290: FROM igf_ap_batch_aw_map
1291: WHERE ci_cal_type = cp_cal_type
1292: AND ci_sequence_number = cp_seq_num;
1293:
1294: lc_sys_awd_yr c_sys_awd_yr%ROWTYPE;

Line 1305: CURSOR c_chg_code ( cp_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE,

1301: ) AS
1302:
1303: -- ## Cursor to get the changed code values
1304: -- cursor modifed as part of FACR 113 SAR Updates
1305: CURSOR c_chg_code ( cp_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE,
1306: cp_seq_num igf_ap_batch_aw_map.ci_sequence_number%TYPE ) IS
1307: SELECT sar.sar_field_number
1308: FROM igf_ap_batch_aw_map map,
1309: Igf_fc_sar_cd_mst sar

Line 1306: cp_seq_num igf_ap_batch_aw_map.ci_sequence_number%TYPE ) IS

1302:
1303: -- ## Cursor to get the changed code values
1304: -- cursor modifed as part of FACR 113 SAR Updates
1305: CURSOR c_chg_code ( cp_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE,
1306: cp_seq_num igf_ap_batch_aw_map.ci_sequence_number%TYPE ) IS
1307: SELECT sar.sar_field_number
1308: FROM igf_ap_batch_aw_map map,
1309: Igf_fc_sar_cd_mst sar
1310: WHERE map.ci_cal_type = cp_cal_type

Line 1308: FROM igf_ap_batch_aw_map map,

1304: -- cursor modifed as part of FACR 113 SAR Updates
1305: CURSOR c_chg_code ( cp_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE,
1306: cp_seq_num igf_ap_batch_aw_map.ci_sequence_number%TYPE ) IS
1307: SELECT sar.sar_field_number
1308: FROM igf_ap_batch_aw_map map,
1309: Igf_fc_sar_cd_mst sar
1310: WHERE map.ci_cal_type = cp_cal_type
1311: AND map.ci_sequence_number = cp_seq_num
1312: AND sar.sys_award_year = map.sys_award_year