APPS.IGS_RU_VAL_UNIT_RULE dependencies on IGS_EN_STDNT_PS_ATT

Line 30: CURSOR cur_std_psatt(cp_person_id igs_en_stdnt_ps_att_all.person_id%TYPE) IS

26: AND version_number = cp_version_number
27: AND s_rule_call_cd = cp_rul_call_cd;
28:
29: --select all the active program attempts for this student
30: CURSOR cur_std_psatt(cp_person_id igs_en_stdnt_ps_att_all.person_id%TYPE) IS
31: SELECT ps.course_cd , ps.version_number
32: FROM igs_en_stdnt_ps_att ps
33: WHERE ps.person_id = cp_person_id
34: AND ps.course_attempt_status IN ('ENROLLED' ,'INACTIVE')

Line 32: FROM igs_en_stdnt_ps_att ps

28:
29: --select all the active program attempts for this student
30: CURSOR cur_std_psatt(cp_person_id igs_en_stdnt_ps_att_all.person_id%TYPE) IS
31: SELECT ps.course_cd , ps.version_number
32: FROM igs_en_stdnt_ps_att ps
33: WHERE ps.person_id = cp_person_id
34: AND ps.course_attempt_status IN ('ENROLLED' ,'INACTIVE')
35: AND EXISTS ( SELECT 1 FROM igs_en_su_attempt su
36: WHERE su.person_id=ps.person_id