APPS.IGS_AS_PROD_DOC dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 169: FROM igs_en_stdnt_ps_att_all

165: CURSOR cur_ps_att (cp_person_id igs_as_chn_grd_req.person_id%TYPE,
166: cp_creation_date igs_as_ord_itm_int.creation_date%TYPE,
167: cp_course_cd igs_en_sca_v.course_cd%TYPE)IS
168: SELECT 'X'
169: FROM igs_en_stdnt_ps_att_all
170: WHERE person_id = cp_person_id AND
171: course_cd = NVL(cp_course_cd, course_cd) AND
172: TRUNC(course_rqrmnts_complete_dt) BETWEEN TRUNC(igs_ge_date.igsdate(cp_creation_date)) AND TRUNC(SYSDATE);
173: rec_cur_ps_att cur_ps_att%ROWTYPE;