APPS.IGS_RU_VAL_UNIT_RULE dependencies on IGS_EN_STDNT_PS_ATT_ALL

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')