APPS.IGF_GR_PELL_CALC dependencies on IGF_AP_ATTEND_MAP

Line 683: cp_attendance_type IN igf_ap_attend_map.attendance_type%TYPE,

679: END get_pell_setup;
680:
681:
682: PROCEDURE get_pell_coa_efc (cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
683: cp_attendance_type IN igf_ap_attend_map.attendance_type%TYPE,
684: cp_pell_setup_rec IN igf_gr_pell_setup_all%ROWTYPE ,
685: cp_coa OUT NOCOPY NUMBER,
686: cp_efc OUT NOCOPY NUMBER,
687: cp_pell_schedule_code OUT NOCOPY VARCHAR2,

Line 807: cp_attendance_type IN OUT NOCOPY igf_ap_attend_map.attendance_type%TYPE,

803: cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
804: cp_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
805: cp_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
806: cp_pell_setup_rec IN igf_gr_pell_setup_all%ROWTYPE ,
807: cp_attendance_type IN OUT NOCOPY igf_ap_attend_map.attendance_type%TYPE,
808: cp_message OUT NOCOPY VARCHAR2,
809: cp_return_status OUT NOCOPY VARCHAR2
810: )
811: IS

Line 854: igf_ap_attend_map pell

850: pell.pell_att_code attendance_type
851: FROM
852: igs_en_stdnt_ps_att en,
853: igf_ap_fa_base_rec fa,
854: igf_ap_attend_map pell
855: WHERE
856: fa.base_id = l_base_id AND
857: fa.person_id = en.person_id AND
858: en.key_program = 'Y' AND

Line 887: l_att_type igf_ap_attend_map_all.attendance_type%TYPE,

883: l_enrl_mode igf_gr_pell_setup.enr_in_mt_code%TYPE;
884:
885:
886: CURSOR c_get_pell_att(
887: l_att_type igf_ap_attend_map_all.attendance_type%TYPE,
888: l_cal_type igf_ap_attend_map_all.cal_type%TYPE,
889: l_sequence_number igf_ap_attend_map_all.sequence_number%TYPE)
890: IS
891: SELECT

Line 888: l_cal_type igf_ap_attend_map_all.cal_type%TYPE,

884:
885:
886: CURSOR c_get_pell_att(
887: l_att_type igf_ap_attend_map_all.attendance_type%TYPE,
888: l_cal_type igf_ap_attend_map_all.cal_type%TYPE,
889: l_sequence_number igf_ap_attend_map_all.sequence_number%TYPE)
890: IS
891: SELECT
892: pell.pell_att_code attendance_type

Line 889: l_sequence_number igf_ap_attend_map_all.sequence_number%TYPE)

885:
886: CURSOR c_get_pell_att(
887: l_att_type igf_ap_attend_map_all.attendance_type%TYPE,
888: l_cal_type igf_ap_attend_map_all.cal_type%TYPE,
889: l_sequence_number igf_ap_attend_map_all.sequence_number%TYPE)
890: IS
891: SELECT
892: pell.pell_att_code attendance_type
893: FROM

Line 894: igf_ap_attend_map pell

890: IS
891: SELECT
892: pell.pell_att_code attendance_type
893: FROM
894: igf_ap_attend_map pell
895: WHERE
896: pell.cal_type = l_cal_type AND
897: pell.sequence_number = l_sequence_number AND
898: pell.attendance_type = l_att_type;

Line 914: igf_ap_attend_map pell,

910: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
911: ) IS
912: SELECT pell.pell_att_code attendance_type
913: FROM igf_ap_fa_ant_data ant,
914: igf_ap_attend_map pell,
915: igf_ap_fa_base_rec_all fa
916: WHERE fa.base_id = cp_base_id
917: AND ant.ld_cal_type = cp_ld_cal_type
918: AND ant.ld_sequence_number = cp_ld_sequence_number

Line 2117: old_pell_att_type igf_ap_attend_map.attendance_type%TYPE;

2113: l_program_version igs_en_stdnt_ps_att.version_number%TYPE;
2114: l_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE;
2115: pell_att_flag BOOLEAN := TRUE;
2116: l_term_cnt NUMBER;
2117: old_pell_att_type igf_ap_attend_map.attendance_type%TYPE;
2118: l_term_weeks NUMBER;
2119: l_total_term_weeks NUMBER;
2120: l_pell_amt NUMBER;
2121: l_ft_pell_amt NUMBER;

Line 3175: cp_attendance_type IN igf_ap_attend_map.attendance_type%TYPE,

3171: END pell_elig;
3172:
3173: PROCEDURE calc_term_pell(
3174: cp_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
3175: cp_attendance_type IN igf_ap_attend_map.attendance_type%TYPE,
3176: cp_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
3177: cp_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
3178: cp_term_aid IN OUT NOCOPY NUMBER,
3179: cp_return_status IN OUT NOCOPY VARCHAR2,