eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_GR_PELL_CALC dependencies on IGS_EN_STDNT_PS_ATT

Line 852: igs_en_stdnt_ps_att en,

848: IS
849: SELECT
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

Line 876: l_program_cd igs_en_stdnt_ps_att.course_cd%TYPE;

872: fa.base_id = l_base_id;
873:
874: l_fabase_rec c_fabase%ROWTYPE;
875:
876: l_program_cd igs_en_stdnt_ps_att.course_cd%TYPE;
877: l_program_version igs_en_stdnt_ps_att.version_number%TYPE;
878: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE ;
879: l_credit_pts igs_en_su_attempt.override_achievable_cp%TYPE ;
880: l_fte igs_en_su_attempt.override_achievable_cp%TYPE ;

Line 877: l_program_version igs_en_stdnt_ps_att.version_number%TYPE;

873:
874: l_fabase_rec c_fabase%ROWTYPE;
875:
876: l_program_cd igs_en_stdnt_ps_att.course_cd%TYPE;
877: l_program_version igs_en_stdnt_ps_att.version_number%TYPE;
878: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE ;
879: l_credit_pts igs_en_su_attempt.override_achievable_cp%TYPE ;
880: l_fte igs_en_su_attempt.override_achievable_cp%TYPE ;
881:

Line 903: FROM igs_en_stdnt_ps_att

899:
900: CURSOR c_chk_enr(cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
901: IS
902: SELECT 'X'
903: FROM igs_en_stdnt_ps_att
904: WHERE person_id = cp_person_id;
905: l_chk_enr_rec c_chk_enr%ROWTYPE;
906:
907: CURSOR c_get_ant_atype(

Line 2112: l_program_cd igs_en_stdnt_ps_att.course_cd%TYPE;

2108: l_tp_amt NUMBER;
2109: l_actual_weeks NUMBER;
2110: l_disb_exp_dt DATE;
2111: l_verif_enfr_dt DATE;
2112: l_program_cd igs_en_stdnt_ps_att.course_cd%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;

Line 2113: l_program_version igs_en_stdnt_ps_att.version_number%TYPE;

2109: l_actual_weeks NUMBER;
2110: l_disb_exp_dt DATE;
2111: l_verif_enfr_dt DATE;
2112: l_program_cd igs_en_stdnt_ps_att.course_cd%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;

Line 2114: l_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE;

2110: l_disb_exp_dt DATE;
2111: l_verif_enfr_dt DATE;
2112: l_program_cd igs_en_stdnt_ps_att.course_cd%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;

Line 2140: igs_en_stdnt_ps_att en,

2136: CURSOR c_get_prog_type (l_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
2137: IS
2138: SELECT ptype.fin_aid_program_type prog_type
2139: FROM
2140: igs_en_stdnt_ps_att en,
2141: igf_ap_fa_base_rec fa,
2142: igs_ps_ver pver,
2143: igs_ps_type_v ptype
2144: WHERE

Line 3084: igs_en_stdnt_ps_att en,

3080: CURSOR c_get_prog_type (l_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
3081: IS
3082: SELECT ptype.FIN_AID_PROGRAM_TYPE prog_type
3083: FROM
3084: igs_en_stdnt_ps_att en,
3085: igf_ap_fa_base_rec fa,
3086: igs_ps_ver pver,
3087: igs_ps_type_v ptype
3088: WHERE

Line 3267: l_program_cd igs_en_stdnt_ps_att.course_cd%TYPE;

3263: l_aid NUMBER;
3264: l_term_amt NUMBER;
3265: l_tp_amt NUMBER;
3266: l_actual_weeks NUMBER;
3267: l_program_cd igs_en_stdnt_ps_att.course_cd%TYPE;
3268: l_program_version igs_en_stdnt_ps_att.version_number%TYPE;
3269: l_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE;
3270: l_term_weeks NUMBER;
3271:

Line 3268: l_program_version igs_en_stdnt_ps_att.version_number%TYPE;

3264: l_term_amt NUMBER;
3265: l_tp_amt NUMBER;
3266: l_actual_weeks NUMBER;
3267: l_program_cd igs_en_stdnt_ps_att.course_cd%TYPE;
3268: l_program_version igs_en_stdnt_ps_att.version_number%TYPE;
3269: l_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE;
3270: l_term_weeks NUMBER;
3271:
3272:

Line 3269: l_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE;

3265: l_tp_amt NUMBER;
3266: l_actual_weeks NUMBER;
3267: l_program_cd igs_en_stdnt_ps_att.course_cd%TYPE;
3268: l_program_version igs_en_stdnt_ps_att.version_number%TYPE;
3269: l_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE;
3270: l_term_weeks NUMBER;
3271:
3272:
3273: BEGIN

Line 3536: l_att_type igs_en_stdnt_ps_att.attendance_type%TYPE;

3532: l_get_ant_key_prog_ver_rec cur_get_ant_key_prog_ver%ROWTYPE;
3533:
3534: l_coa_rec c_coa%ROWTYPE;
3535: l_reg_efc NUMBER;
3536: l_att_type igs_en_stdnt_ps_att.attendance_type%TYPE;
3537: l_efc NUMBER;
3538: l_coa NUMBER;
3539: l_ft_coa NUMBER;
3540: l_ft_aid NUMBER;

Line 3541: l_program_cd igs_en_stdnt_ps_att.course_cd%TYPE;

3537: l_efc NUMBER;
3538: l_coa NUMBER;
3539: l_ft_coa NUMBER;
3540: l_ft_aid NUMBER;
3541: l_program_cd igs_en_stdnt_ps_att.course_cd%TYPE;
3542: l_program_version igs_en_stdnt_ps_att.version_number%TYPE;
3543: l_pell_setup_rec igf_gr_pell_setup_all%ROWTYPE;
3544: l_ft_efc NUMBER;
3545: l_pell_schedule_code VARCHAR2(30);

Line 3542: l_program_version igs_en_stdnt_ps_att.version_number%TYPE;

3538: l_coa NUMBER;
3539: l_ft_coa NUMBER;
3540: l_ft_aid NUMBER;
3541: l_program_cd igs_en_stdnt_ps_att.course_cd%TYPE;
3542: l_program_version igs_en_stdnt_ps_att.version_number%TYPE;
3543: l_pell_setup_rec igf_gr_pell_setup_all%ROWTYPE;
3544: l_ft_efc NUMBER;
3545: l_pell_schedule_code VARCHAR2(30);
3546: