APPS.IGS_SS_ENR_DETAILS dependencies on IGS_PS_USEC_OCCURS_ALL

Line 249: cursor c_get_uso_instructor ( p_unit_section_occurence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE)

245: a.room_code = c.room_id(+) AND
246: a.uoo_id = p_uoo_id
247: ORDER BY class_day,class_time;
248:
249: cursor c_get_uso_instructor ( p_unit_section_occurence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE)
250: IS
251: SELECT
252: person_Last_name ||', '||Person_first_name||' '|| person_middle_name instructor_name
253: FROM

Line 3259: FROM igs_ps_usec_occurs_all USO,

3255: DECODE(uso.saturday, 'Y', 'Sa', NULL) ||
3256: DECODE(uso.sunday, 'Y', 'Su', NULL),'TBA') meetings,
3257: TO_CHAR(uso.start_time,'hh:miam') start_time,
3258: TO_CHAR(uso.end_time, 'hh:miam') end_time
3259: FROM igs_ps_usec_occurs_all USO,
3260: igs_ps_unit_ofr_opt_all US,
3261: igs_ca_inst_all CA
3262: WHERE uso.uoo_id = cp_n_uoo_id AND
3263: uso.uoo_id = us.uoo_id AND

Line 3361: FROM igs_ps_usec_occurs_all

3357:
3358: FUNCTION get_usec_instructors(p_n_uoo_id IN NUMBER) RETURN VARCHAR2 AS
3359: CURSOR c_uso (cp_n_uoo_id IN NUMBER) IS
3360: SELECT unit_section_occurrence_id
3361: FROM igs_ps_usec_occurs_all
3362: WHERE uoo_id = cp_n_uoo_id
3363: ORDER BY unit_section_occurrence_id;
3364: CURSOR c_instr (cp_n_occurs_id IN NUMBER) IS
3365: SELECT pe.last_name || ', ' || pe.first_name || ' ' || pe.middle_name name

Line 4549: FROM igs_ps_usec_occurs_all uso

4545: DECODE(uso.thursday, 'Y', 'Th', NULL) ||
4546: DECODE(uso.friday, 'Y', 'F', NULL) ||
4547: DECODE(uso.saturday, 'Y', 'Sa', NULL) ||
4548: DECODE(uso.sunday, 'Y', 'Su', NULL) meetings
4549: FROM igs_ps_usec_occurs_all uso
4550: WHERE uso.unit_section_occurrence_id = cp_n_uso_id;
4551: rec_uso c_uso%ROWTYPE;
4552: l_c_ret_data varchar2(80);
4553: BEGIN

Line 4586: FROM igs_ps_usec_occurs_all uso

4582: CURSOR c_uso(cp_n_uso_id IN NUMBER) IS
4583: SELECT uso.no_set_day_ind,
4584: to_char(uso.start_time,'hh:miam') start_time,
4585: to_char(uso.end_time,'hh:miam') end_time
4586: FROM igs_ps_usec_occurs_all uso
4587: WHERE uso.unit_section_occurrence_id = cp_n_uso_id;
4588: rec_uso c_uso%ROWTYPE;
4589:
4590: l_c_ret_data varchar2(80);

Line 4626: FROM igs_ps_usec_occurs_all USO,

4622: SELECT TO_CHAR( NVL( NVL( USO.START_DATE, US.UNIT_SECTION_START_DATE),
4623: CA.START_DT), 'DD MON YYYY') || ' - ' ||
4624: TO_CHAR( NVL( NVL( USO.END_DATE, US.UNIT_SECTION_END_DATE),
4625: CA.END_DT), 'DD MON YYYY') effective_date
4626: FROM igs_ps_usec_occurs_all USO,
4627: igs_ps_unit_ofr_opt_all US,
4628: igs_ca_inst_all CA
4629: WHERE uso.unit_section_occurrence_id = cp_n_uso_id
4630: AND uso.uoo_id = us.uoo_id