APPS.IGF_AW_FISAP_PKG dependencies on IGF_AP_FA_BASE_REC

Line 465: FROM igf_ap_fa_base_rec fabase

461: AND batch.ci_sequence_number = cp_seq_number;
462:
463: CURSOR cur_students(cp_cal_type VARCHAR2, cp_seq_number NUMBER) IS
464: SELECT fabase.base_id
465: FROM igf_ap_fa_base_rec fabase
466: WHERE fabase.ci_cal_type = cp_cal_type
467: AND fabase.ci_sequence_number = cp_seq_number;
468: rec_student cur_students%ROWTYPE;
469:

Line 483: FROM IGF_AP_FA_BASE_REC_ALL fabase,

479: rec_isir_dtls cur_isir_dtls%ROWTYPE;
480:
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

Line 507: IGF_AP_FA_BASE_REC_ALL fa

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

Line 523: FROM IGF_AP_FA_BASE_REC_ALL fabase,

519: GROUP BY fa.base_id;
520:
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

Line 539: FROM IGF_AP_FA_BASE_REC_ALL fabase,

535: GROUP BY fabase.base_id;
536:
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