eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AW_LI_IMPORT dependencies on IGF_AW_FUND_MAST_ALL

Line 148: g_fund_code igf_aw_fund_mast_all.fund_code%TYPE;

144: g_ci_sequence_number igf_ap_batch_aw_map_all.ci_sequence_number%TYPE;
145:
146: g_award_year_status_code igf_ap_batch_aw_map_all.award_year_status_code%TYPE;
147: g_sys_award_year igf_ap_batch_aw_map_all.sys_award_year%TYPE;
148: g_fund_code igf_aw_fund_mast_all.fund_code%TYPE;
149: g_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;
150: g_fund_id igf_aw_fund_mast_all.fund_id%TYPE;
151: g_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
152: g_award_id igf_aw_award_all.award_id%TYPE;

Line 150: g_fund_id igf_aw_fund_mast_all.fund_id%TYPE;

146: g_award_year_status_code igf_ap_batch_aw_map_all.award_year_status_code%TYPE;
147: g_sys_award_year igf_ap_batch_aw_map_all.sys_award_year%TYPE;
148: g_fund_code igf_aw_fund_mast_all.fund_code%TYPE;
149: g_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;
150: g_fund_id igf_aw_fund_mast_all.fund_id%TYPE;
151: g_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
152: g_award_id igf_aw_award_all.award_id%TYPE;
153: g_disb_net_amount igf_aw_li_dact_ints.disb_net_amt%TYPE;
154: g_person_id hz_parties.party_id%TYPE;

Line 438: FROM igf_aw_fund_mast_all fmast,

434: l_legacy_record_flag igf_aw_award_all.legacy_record_flag%TYPE;
435:
436: CURSOR cur_get_fund_code(p_fund_code igf_aw_li_awd_ints.fund_code%TYPE) IS
437: SELECT fmast.fund_code, fcat.fed_fund_code, fmast.fund_id
438: FROM igf_aw_fund_mast_all fmast,
439: igf_aw_fund_cat fcat
440: WHERE fmast.fund_code = fcat.fund_code
441: AND fmast.fund_code = p_fund_code
442: AND fmast.ci_cal_type = g_ci_cal_type

Line 463: FROM igf_aw_fund_mast_all fmast, igf_aw_fund_cat_all fcat

459: c_get_fa_hold_spnsr_rec c_get_fa_hold_spnsr%ROWTYPE;
460:
461: CURSOR c_get_spnsr_amt IS
462: SELECT fmast.max_yearly_amt
463: FROM igf_aw_fund_mast_all fmast, igf_aw_fund_cat_all fcat
464: WHERE fmast.fund_id = g_fund_id
465: AND fcat.fed_fund_code = g_fed_fund_code
466: AND fmast.ci_cal_type = g_ci_cal_type
467: AND fmast.ci_sequence_number = g_ci_sequence_number

Line 516: FROM igf_aw_fund_mast_all

512:
513: CURSOR c_get_fund_amt IS
514: SELECT NVL(remaining_amt,0) remaining_amt, NVL(max_award_amt,0) max_award_amt,
515: max_yearly_amt, max_life_amt
516: FROM igf_aw_fund_mast_all
517: WHERE fund_id = g_fund_id;
518: c_get_fund_amt_rec c_get_fund_amt%ROWTYPE;
519:
520: CURSOR c_std_max_yr_amt IS

Line 529: FROM igf_aw_award_all awd, igf_aw_fund_mast_all fund, igf_ap_fa_base_rec_all fabase

525: c_std_max_yr_amt_rec c_std_max_yr_amt%ROWTYPE;
526:
527: CURSOR c_std_max_lf_count IS
528: SELECT NVL(SUM( NVL(awd.accepted_amt,awd.offered_amt)), 0) lf_total
529: FROM igf_aw_award_all awd, igf_aw_fund_mast_all fund, igf_ap_fa_base_rec_all fabase
530: WHERE fund.fund_code = g_fund_code
531: AND fabase.person_id = g_person_id
532: AND awd.base_id = fabase.base_id
533: AND awd.fund_id = fund.fund_id;

Line 1714: FROM igf_aw_fund_mast_all fmast,

1710: c_match_disb_term_rec c_match_disb_term%ROWTYPE;
1711:
1712: CURSOR c_max_year_spnsr IS
1713: SELECT fmast.max_yearly_amt
1714: FROM igf_aw_fund_mast_all fmast,
1715: igf_aw_fund_cat_all fcat
1716: WHERE fcat.fund_code = fmast.fund_code
1717: AND fcat.fed_fund_code = g_fed_fund_code
1718: AND fmast.fund_id = g_fund_id