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_SS_ENR_DETAILS dependencies on IGS_EN_UNIT_SET

Line 2394: igs_en_unit_set us ,

2390: -- cursor to fetch the unit set title
2391: CURSOR c_us_title (cp_person_id NUMBER,cp_program_cd VARCHAR2,cp_term_census_date DATE) IS
2392: SELECT us.title
2393: FROM igs_as_su_setatmpt susa ,
2394: igs_en_unit_set us ,
2395: igs_en_unit_set_cat usc
2396: WHERE susa.person_id = cp_person_id
2397: AND susa.course_cd = cp_program_cd
2398: AND susa.student_confirmed_ind = 'Y'

Line 2395: igs_en_unit_set_cat usc

2391: CURSOR c_us_title (cp_person_id NUMBER,cp_program_cd VARCHAR2,cp_term_census_date DATE) IS
2392: SELECT us.title
2393: FROM igs_as_su_setatmpt susa ,
2394: igs_en_unit_set us ,
2395: igs_en_unit_set_cat usc
2396: WHERE susa.person_id = cp_person_id
2397: AND susa.course_cd = cp_program_cd
2398: AND susa.student_confirmed_ind = 'Y'
2399: AND cp_term_census_date

Line 2425: l_us_title igs_en_unit_set.title%TYPE;

2421: AND dai.cal_type = cp_cal_type
2422: AND dai.ci_sequence_number = cp_cal_seq_number
2423: ORDER by 1 desc;
2424:
2425: l_us_title igs_en_unit_set.title%TYPE;
2426: BEGIN
2427: -- Check whether the pre-enrollment YOP profile is set to Y
2428: IF fnd_profile.value('IGS_PS_PRENRL_YEAR_IND') = 'Y' THEN
2429:

Line 5363: igs_en_unit_set us ,

5359: cp_version IN NUMBER) IS
5360: SELECT NVL(susa.override_title, us.title) title,
5361: NVL(susa.rqrmnts_complete_dt,NVL(susa.end_dt, cp_term_census_date)) end_date
5362: FROM igs_as_su_setatmpt susa ,
5363: igs_en_unit_set us ,
5364: igs_en_unit_set_cat usc
5365: WHERE susa.person_id = cp_person_id
5366: AND susa.course_cd = cp_program_cd
5367: AND susa.student_confirmed_ind = 'Y'

Line 5364: igs_en_unit_set_cat usc

5360: SELECT NVL(susa.override_title, us.title) title,
5361: NVL(susa.rqrmnts_complete_dt,NVL(susa.end_dt, cp_term_census_date)) end_date
5362: FROM igs_as_su_setatmpt susa ,
5363: igs_en_unit_set us ,
5364: igs_en_unit_set_cat usc
5365: WHERE susa.person_id = cp_person_id
5366: AND susa.course_cd = cp_program_cd
5367: AND susa.student_confirmed_ind = 'Y'
5368: AND cp_term_census_date