APPS.IGF_AW_FISAP_PKG dependencies on IGF_AW_FUND_MAST_ALL

Line 485: IGF_AW_FUND_MAST_ALL fmast,

481: CURSOR cur_any_cbfunds(cp_cal_type VARCHAR2, cp_seq_number NUMBER, cp_base_id NUMBER) IS
482: SELECT 'X'
483: FROM IGF_AP_FA_BASE_REC_ALL fabase,
484: IGF_AW_AWARD_ALL awd,
485: IGF_AW_FUND_MAST_ALL fmast,
486: IGF_AW_FUND_CAT_ALL fcat,
487: IGS_CA_INST_ALL ca
488: WHERE ca.cal_type = fabase.ci_cal_type
489: AND ca.sequence_number = fabase.ci_sequence_number

Line 505: IGF_AW_FUND_MAST_ALL fmast,

501: SELECT SUM(NVL(pay.paid_amount, 0)) paid_amount
502: FROM IGF_SE_PAYMENT pay,
503: IGF_SE_AUTH auth,
504: IGF_AW_AWARD_ALL awd,
505: IGF_AW_FUND_MAST_ALL fmast,
506: IGF_AW_FUND_CAT_ALL fcat,
507: IGF_AP_FA_BASE_REC_ALL fa
508: WHERE fcat.fund_code=fmast.fund_code
509: AND fcat.fed_fund_code='FWS'

Line 526: IGF_AW_FUND_MAST_ALL fmast,

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
530: AND fmast.fund_id = awd.fund_id

Line 542: IGF_AW_FUND_MAST_ALL fmast,

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
546: AND fmast.fund_id = awd.fund_id