APPS.IGS_SS_ENR_DETAILS dependencies on IGS_AS_SU_SETATMPT

Line 2393: FROM igs_as_su_setatmpt susa ,

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

Line 5362: FROM igs_as_su_setatmpt susa ,

5358: cp_unit_set IN VARCHAR2,
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

Line 5380: FROM igs_as_su_setatmpt susa

5376: ORDER BY end_date, susa.selection_dt DESC;
5377:
5378: CURSOR c_unit_sets (cp_person_id IN NUMBER, cp_program_cd IN VARCHAR2) IS
5379: SELECT DISTINCT susa.unit_set_cd, susa.us_version_number
5380: FROM igs_as_su_setatmpt susa
5381: WHERE susa.person_id = cp_person_id
5382: AND susa.course_cd = cp_program_cd
5383: AND susa.student_confirmed_ind = 'Y';
5384:

Line 5387: l_c_temp igs_as_su_setatmpt.override_title%TYPE;

5383: AND susa.student_confirmed_ind = 'Y';
5384:
5385: l_pre_title VARCHAR2(2000);
5386: l_oth_title VARCHAR2(2000);
5387: l_c_temp igs_as_su_setatmpt.override_title%TYPE;
5388: l_c_title VARCHAR2(4000);
5389:
5390: BEGIN
5391: l_pre_title := get_stud_yop_unit_set ( p_person_id => p_person_id,