APPS.IGF_GR_REPACKAGE dependencies on IGF_AW_FUND_MAST_ALL

Line 345: igf_aw_fund_mast_all fmast,

341: awd.fund_id,
342: awd.award_status,
343: fmast.fund_code
344: FROM igf_aw_fund_cat_all fcat,
345: igf_aw_fund_mast_all fmast,
346: igf_aw_award_all awd
347: WHERE fcat.fed_fund_code = 'PELL'
348: AND fcat.fund_code = fmast.fund_code
349: AND fmast.fund_id = awd.fund_id

Line 386: l_offered_amt igf_aw_fund_mast_all.offered_amt%TYPE;

382: lc_rfms c_rfms%ROWTYPE;
383: lc_rfms_disb c_rfms_disb%ROWTYPE;
384: lc_award c_award%ROWTYPE;
385:
386: l_offered_amt igf_aw_fund_mast_all.offered_amt%TYPE;
387: l_process igf_aw_award_t.process_id%TYPE;
388:
389: e_next_record EXCEPTION;
390:

Line 1352: igf_aw_fund_mast_all fmast,

1348: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE
1349: ) IS
1350: SELECT awd.base_id
1351: FROM igf_aw_award_all awd,
1352: igf_aw_fund_mast_all fmast,
1353: igf_aw_fund_cat_all fcat
1354: WHERE fmast.ci_sequence_number = cp_seq_number
1355: AND fmast.ci_cal_type = cp_cal_type
1356: AND awd.fund_id = fmast.fund_id

Line 1360: l_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE;

1356: AND awd.fund_id = fmast.fund_id
1357: AND fmast.fund_code = fcat.fund_code
1358: AND fcat.fed_fund_code = 'PELL';
1359:
1360: l_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE;
1361: l_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE;
1362: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
1363:
1364: TYPE baseidRefCur IS REF CURSOR;

Line 1361: l_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE;

1357: AND fmast.fund_code = fcat.fund_code
1358: AND fcat.fed_fund_code = 'PELL';
1359:
1360: l_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE;
1361: l_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE;
1362: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
1363:
1364: TYPE baseidRefCur IS REF CURSOR;
1365: cur_base_id baseidRefCur;