APPS.IGF_AW_GEN_002 dependencies on IGF_AW_AWARD_ALL

Line 1636: igf_aw_award_all awd,

1632: SELECT NVL(SUM(NVL(disb.disb_gross_amt,0)),0) resource_f,
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

Line 1664: igf_aw_award_all awd,

1660: SELECT NVL(SUM(NVL(disb.disb_gross_amt, 0)), 0) resource_f,
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,