APPS.IGF_AW_FISAP dependencies on IGF_AW_AWARD_ALL

Line 63: FROM igf_aw_award_all awd,

59: 'OFFERED', awd.offered_amt,
60: 'ACCEPTED', awd.accepted_amt
61: ),
62: 0)) total_fseog
63: FROM igf_aw_award_all awd,
64: igf_aw_fund_mast_all fmast,
65: igf_aw_fund_cat_all fcat
66: WHERE fcat.fed_fund_code = 'FSEOG'
67: AND fmast.ci_cal_type = cp_ci_cal_type

Line 83: FROM igf_aw_award_all awd

79: 'OFFERED', awd.offered_amt,
80: 'ACCEPTED', awd.accepted_amt
81: ),
82: 0)) total_match
83: FROM igf_aw_award_all awd
84: WHERE awd.fund_id IN (
85: SELECT fund_id
86: FROM igf_aw_fseog_match
87: WHERE ci_cal_type = cp_ci_cal_type