eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AS_PROD_DOC dependencies on IGS_GE_DATE

Line 172: TRUNC(course_rqrmnts_complete_dt) BETWEEN TRUNC(igs_ge_date.igsdate(cp_creation_date)) AND TRUNC(SYSDATE);

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;
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,

Line 183: TRUNC(course_rqrmnts_complete_dt) BETWEEN TRUNC(igs_ge_date.igsdate(cp_creation_date)) AND TRUNC(SYSDATE);

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;
185:
186: l_su_att_count NUMBER(10);
187: BEGIN