APPS.IGS_AS_VAL_EIS dependencies on IGS_EN_STDNT_PS_ATT

Line 24: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE) IS

20: cst_intermit CONSTANT VARCHAR2(8) := 'INTERMIT';
21: cst_inactive CONSTANT VARCHAR2(8) := 'INACTIVE';
22: v_rec_found BOOLEAN DEFAULT FALSE;
23: CURSOR c_sca (
24: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE) IS
25: SELECT 'x'
26: FROM IGS_EN_STDNT_PS_ATT sca
27: WHERE sca.person_id = cp_person_id AND
28: sca.course_attempt_status IN (cst_enrolled, cst_intermit,

Line 26: FROM IGS_EN_STDNT_PS_ATT sca

22: v_rec_found BOOLEAN DEFAULT FALSE;
23: CURSOR c_sca (
24: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE) IS
25: SELECT 'x'
26: FROM IGS_EN_STDNT_PS_ATT sca
27: WHERE sca.person_id = cp_person_id AND
28: sca.course_attempt_status IN (cst_enrolled, cst_intermit,
29: cst_lapsed, cst_inactive);
30: BEGIN