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_CAT

Line 149: g_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%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;
153: g_disb_net_amount igf_aw_li_dact_ints.disb_net_amt%TYPE;

Line 439: igf_aw_fund_cat fcat

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
443: AND fmast.ci_sequence_number = g_ci_sequence_number

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 510: SELECT fund_source FROM igf_aw_fund_cat_all WHERE fund_code = li_awd_rec.fund_code;

506:
507: l_payment_isir_id igf_ap_isir_matched_all.isir_id%TYPE;
508:
509: CURSOR c_get_fund_source IS
510: SELECT fund_source FROM igf_aw_fund_cat_all WHERE fund_code = li_awd_rec.fund_code;
511: l_fund_source igf_aw_fund_cat_all.fund_source%TYPE;
512:
513: CURSOR c_get_fund_amt IS
514: SELECT NVL(remaining_amt,0) remaining_amt, NVL(max_award_amt,0) max_award_amt,

Line 511: l_fund_source igf_aw_fund_cat_all.fund_source%TYPE;

507: l_payment_isir_id igf_ap_isir_matched_all.isir_id%TYPE;
508:
509: CURSOR c_get_fund_source IS
510: SELECT fund_source FROM igf_aw_fund_cat_all WHERE fund_code = li_awd_rec.fund_code;
511: l_fund_source igf_aw_fund_cat_all.fund_source%TYPE;
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

Line 1715: igf_aw_fund_cat_all fcat

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
1719: AND fmast.discontinue_fund = 'N';

Line 1819: CURSOR c_get_fed_fund (cp_fund_code igf_aw_fund_cat_all.fund_code%TYPE) IS

1815: SELECT rowid row_id, disb.*
1816: FROM igf_aw_awd_disb_all disb
1817: WHERE rowid = cp_row_id;
1818:
1819: CURSOR c_get_fed_fund (cp_fund_code igf_aw_fund_cat_all.fund_code%TYPE) IS
1820: SELECT fed_fund_code
1821: FROM igf_aw_fund_cat_all
1822: WHERE fund_code = cp_fund_code;
1823:

Line 1821: FROM igf_aw_fund_cat_all

1817: WHERE rowid = cp_row_id;
1818:
1819: CURSOR c_get_fed_fund (cp_fund_code igf_aw_fund_cat_all.fund_code%TYPE) IS
1820: SELECT fed_fund_code
1821: FROM igf_aw_fund_cat_all
1822: WHERE fund_code = cp_fund_code;
1823:
1824: l_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;
1825: lc_awd_disb cur_awd_disb%ROWTYPE;

Line 1824: l_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;

1820: SELECT fed_fund_code
1821: FROM igf_aw_fund_cat_all
1822: WHERE fund_code = cp_fund_code;
1823:
1824: l_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;
1825: lc_awd_disb cur_awd_disb%ROWTYPE;
1826: c_tp_calseq_rec c_get_cal_typ_seq_num%ROWTYPE;
1827: c_ld_calseq_rec c_get_cal_typ_seq_num%ROWTYPE;
1828: l_warning VARCHAR2(200);