DBA Data[Home] [Help]

APPS.IGF_AW_FISAP_PKG dependencies on IGF_AW_AWD_DISB_ALL

Line 525: IGF_AW_AWD_DISB_ALL disb,

521: CURSOR cur_perkins_amount(cp_base_id IN NUMBER) IS
522: SELECT SUM(NVL(disb.disb_paid_amt, 0)) paid_amount
523: FROM IGF_AP_FA_BASE_REC_ALL fabase,
524: IGF_AW_AWARD_ALL awd,
525: IGF_AW_AWD_DISB_ALL disb,
526: IGF_AW_FUND_MAST_ALL fmast,
527: IGF_AW_FUND_CAT_ALL fcat
528: WHERE fabase.base_id = awd.base_id
529: AND awd.award_id = disb.award_id

Line 541: IGF_AW_AWD_DISB_ALL disb,

537: CURSOR cur_fseog_amount(cp_base_id IN NUMBER) IS
538: SELECT SUM(NVL(disb.disb_paid_amt, 0)) paid_amount
539: FROM IGF_AP_FA_BASE_REC_ALL fabase,
540: IGF_AW_AWARD_ALL awd,
541: IGF_AW_AWD_DISB_ALL disb,
542: IGF_AW_FUND_MAST_ALL fmast,
543: IGF_AW_FUND_CAT_ALL fcat
544: WHERE fabase.base_id = awd.base_id
545: AND awd.award_id = disb.award_id