DBA Data[Home] [Help]

APPS.IGF_AW_GEN_002 dependencies on IGF_AW_FUND_MAST_ALL

Line 1637: igf_aw_fund_mast_all fm,

1633: NVL(SUM(DECODE(fm.fm_fc_methd,'INSTITUTIONAL',NVL(disb.disb_gross_amt,0),0)),0) resource_i,
1634: NVL(SUM(DECODE(fm.replace_fc,'Y',NVL(disb.disb_gross_amt,0),0)),0) resource_fm_f
1635: FROM igf_aw_awd_disb_all disb,
1636: igf_aw_award_all awd,
1637: igf_aw_fund_mast_all fm,
1638: igf_aw_fund_cat_all fcat,
1639: ( SELECT base_id, ld_cal_type, ld_sequence_number
1640: FROM igf_aw_coa_itm_terms
1641: WHERE base_id = p_base_id

Line 1665: igf_aw_fund_mast_all fm,

1661: NVL(SUM(DECODE(fm.fm_fc_methd,'INSTITUTIONAL', NVL(disb.disb_gross_amt, 0),0)),0) resource_i,
1662: NVL(SUM(DECODE(fm.replace_fc,'Y', NVL(disb.disb_gross_amt, 0),0)), 0) resource_fm_f
1663: FROM igf_aw_awd_disb_all disb,
1664: igf_aw_award_all awd,
1665: igf_aw_fund_mast_all fm,
1666: igf_aw_fund_cat_all fcat,
1667: igf_ap_fa_base_rec_all fa,
1668: igf_aw_awd_prd_term aprd,
1669: (SELECT base_id,