APPS.IGF_SL_DL_CHG_ACK dependencies on IGF_AW_FUND_CAT

Line 371: igf_aw_fund_cat_all fcat

367: SELECT fcat.fed_fund_code
368: FROM igf_sl_loans_all loan,
369: igf_aw_award_all awd,
370: igf_aw_fund_mast_all fmast,
371: igf_aw_fund_cat_all fcat
372: WHERE
373: loan.award_id = awd.award_id AND
374: awd.fund_id = fmast.fund_id AND
375: fcat.fund_code = fmast.fund_code AND

Line 399: l_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE;

395:
396: l_loan_accp_amt igf_aw_award_all.accepted_amt%TYPE;
397: l_loan_status igf_sl_loans_all.loan_status%TYPE;
398: l_loan_catg igf_sl_dl_chg_fld.loan_catg%TYPE;
399: l_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE;
400:
401: BEGIN
402:
403: igf_aw_gen.set_org_id(p_org_id);