APPS.IGF_AW_PACKNG_SUBFNS dependencies on IGF_AW_FUND_MAST_ALL

Line 154: igf_aw_fund_mast_all fm,

150: SELECT SUM(NVL(awd.offered_amt,0)) loan_amt,
151: SUM(DECODE(fcat.fed_fund_code,'FLS',
152: NVL(awd.offered_amt,0),'DLS',NVL(awd.offered_amt,0),0)) subs_loan_amt
153: FROM igf_aw_award_all awd,
154: igf_aw_fund_mast_all fm,
155: igf_aw_fund_cat_all fcat
156: WHERE awd.base_id = l_base_id
157: AND awd.fund_id = fm.fund_id
158: AND awd.award_status IN ('OFFERED','ACCEPTED')