DBA Data[Home] [Help]

APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGF_AW_AWD_DISB

Line 3651: FROM igf_aw_awd_disb a,

3647: --Query to get all Sponsor records for student within the given HESA reporting period.
3648: CURSOR cur_spnsr IS
3649: SELECT SUM (a.disb_net_amt) sponsor_amount,
3650: d.map1 sponsor
3651: FROM igf_aw_awd_disb a,
3652: igf_aw_award b,
3653: igf_aw_fund_mast fmast,
3654: igf_ap_fa_base_rec c,
3655: igs_he_code_map_val d,

Line 3678: FROM igf_aw_awd_disb a,

3674: --Query to get the fund amount sponsored by the SLC.
3675: CURSOR cur_slc_spnsr IS
3676: SELECT SUM (a.disb_net_amt) sponsor_amount,
3677: fmast.fund_code
3678: FROM igf_aw_awd_disb a,
3679: igf_aw_award b,
3680: igf_aw_fund_mast fmast,
3681: igf_ap_fa_base_rec c,
3682: igs_he_code_values d,

Line 3717: FROM igf_aw_awd_disb a,

3713:
3714: --Query to get Load Calendars of SLC sponsored fund
3715: CURSOR cur_slc_ld_cal IS
3716: SELECT DISTINCT a.ld_cal_type, a.ld_sequence_number
3717: FROM igf_aw_awd_disb a,
3718: igf_aw_award b,
3719: igf_aw_fund_mast fmast,
3720: igf_ap_fa_base_rec c,
3721: igs_he_code_values d,