APPS.IGS_HE_FTE_CALC_PKG dependencies on IGS_AS_SC_ATTEMPT_H_ALL

Line 665: CURSOR c_en_hist (cp_person_id igs_as_sc_attempt_h_all.person_id%TYPE,

661: WHERE ci.cal_type = p_fte_cal_type AND
662: ci.sequence_number = p_fte_sequence_number ;
663:
664: -- check whether student has previously had an enrollment history
665: CURSOR c_en_hist (cp_person_id igs_as_sc_attempt_h_all.person_id%TYPE,
666: cp_course_cd igs_as_sc_attempt_h_all.course_cd%TYPE) IS
667: SELECT 'X'
668: FROM igs_as_sc_attempt_h_all
669: WHERE person_id = cp_person_id

Line 666: cp_course_cd igs_as_sc_attempt_h_all.course_cd%TYPE) IS

662: ci.sequence_number = p_fte_sequence_number ;
663:
664: -- check whether student has previously had an enrollment history
665: CURSOR c_en_hist (cp_person_id igs_as_sc_attempt_h_all.person_id%TYPE,
666: cp_course_cd igs_as_sc_attempt_h_all.course_cd%TYPE) IS
667: SELECT 'X'
668: FROM igs_as_sc_attempt_h_all
669: WHERE person_id = cp_person_id
670: AND course_cd = cp_course_cd

Line 668: FROM igs_as_sc_attempt_h_all

664: -- check whether student has previously had an enrollment history
665: CURSOR c_en_hist (cp_person_id igs_as_sc_attempt_h_all.person_id%TYPE,
666: cp_course_cd igs_as_sc_attempt_h_all.course_cd%TYPE) IS
667: SELECT 'X'
668: FROM igs_as_sc_attempt_h_all
669: WHERE person_id = cp_person_id
670: AND course_cd = cp_course_cd
671: AND hist_start_dt < p_fte_end_dt + 1
672: AND course_attempt_status = cst_enrolled;