DBA Data[Home] [Help]

APPS.IGS_SS_ENR_DETAILS dependencies on IGS_EN_UNIT_SET_CAT

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