APPS.IGS_AS_VAL_SUAAP dependencies on IGS_AS_SU_ATMPT_PAT

Line 58: -- Validate that the IGS_AS_SU_ATMPT_PAT can be created.

54: p_uoo_id IN NUMBER )
55: RETURN BOOLEAN IS
56: gv_other_detail VARCHAR2(255);
57: BEGIN -- assp_val_suaap_ins
58: -- Validate that the IGS_AS_SU_ATMPT_PAT can be created.
59: -- It must be valid for the students IGS_AD_LOCATION/class/mode and the status of
60: -- the student IGS_PS_UNIT attempt must be either UNCONFIRM/ENROLLED
61: DECLARE
62: cst_enrolled VARCHAR(8) := 'ENROLLED';

Line 158: FROM IGS_AS_SU_ATMPT_PAT suaap

154: DECLARE
155: v_suaap_count VARCHAR2(1);
156: CURSOR c_suaap IS
157: SELECT 'x'
158: FROM IGS_AS_SU_ATMPT_PAT suaap
159: WHERE suaap.person_id = p_person_id AND
160: suaap.course_cd = p_course_cd AND
161: -- anilk, 22-Apr-2003, Bug# 2829262
162: suaap.uoo_id = p_uoo_id AND