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_PACKNG_SUBFNS dependencies on IGF_AW_FUND_CAT_ALL

Line 134: igf_aw_fund_cat_all fcat,

130: 0
131: )) subs_loan_amt
132: FROM igf_aw_award_all awd,
133: igf_aw_fund_mast fm,
134: igf_aw_fund_cat_all fcat,
135: igf_ap_fa_base_rec_all fa
136: WHERE fa.person_id IN (SELECT person_id
137: FROM igf_ap_fa_base_rec_all
138: WHERE base_id = l_base_id)

Line 155: igf_aw_fund_cat_all fcat

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')
159: AND fcat.fund_code = fm.fund_code