DBA Data[Home] [Help]

APPS.IGF_AW_FISAP_PKG dependencies on IGF_AW_FUND_CAT_ALL

Line 486: IGF_AW_FUND_CAT_ALL fcat,

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
490: AND fabase.base_id = awd.base_id

Line 506: IGF_AW_FUND_CAT_ALL fcat,

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'
510: AND fcat.fund_source='FEDERAL'

Line 527: IGF_AW_FUND_CAT_ALL fcat

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
531: AND fcat.fund_code = fmast.fund_code

Line 543: IGF_AW_FUND_CAT_ALL fcat

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
547: AND fcat.fund_code = fmast.fund_code