APPS.IGS_AS_PROD_DOC dependencies on IGS_EN_SCA_V

Line 167: cp_course_cd igs_en_sca_v.course_cd%TYPE)IS

163:
164: -- For Program centric Mode- Check if the program attempt status is 'COMPLETED' (for all the programs if program is not selected).
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

Line 178: cp_course_type igs_en_sca_v.course_type%TYPE)IS

174:
175: -- For Career centric Mode- Check if the program attempt status is 'COMPLETED' (under all the career if career is not selected).
176: CURSOR cur_en_sca (cp_person_id igs_as_chn_grd_req.person_id%TYPE,
177: cp_creation_date igs_as_ord_itm_int.creation_date%TYPE,
178: cp_course_type igs_en_sca_v.course_type%TYPE)IS
179: SELECT 'X'
180: FROM igs_en_sca_v
181: WHERE person_id = cp_person_id AND
182: course_type = NVL(cp_course_type, course_type) AND

Line 180: FROM igs_en_sca_v

176: CURSOR cur_en_sca (cp_person_id igs_as_chn_grd_req.person_id%TYPE,
177: cp_creation_date igs_as_ord_itm_int.creation_date%TYPE,
178: cp_course_type igs_en_sca_v.course_type%TYPE)IS
179: SELECT 'X'
180: FROM igs_en_sca_v
181: WHERE person_id = cp_person_id AND
182: course_type = NVL(cp_course_type, course_type) AND
183: TRUNC(course_rqrmnts_complete_dt) BETWEEN TRUNC(igs_ge_date.igsdate(cp_creation_date)) AND TRUNC(SYSDATE);
184: rec_cur_en_sca cur_en_sca%ROWTYPE;