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_MAST

Line 133: igf_aw_fund_mast fm,

129: 'DLS', NVL (awd.offered_amt, 0),
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

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')