APPS.IGS_SS_ENR_DETAILS dependencies on IGS_PS_USO_INSTRCTRS

Line 209: -- table igs_ps_uso_instrctrs

205: --
206: -- Change History:
207: -- Who When What
208: -- prgoyal 14-Oct-2001 Modifed the function to fetch the instructors from
209: -- table igs_ps_uso_instrctrs
210: -- kamohan 1/15/02 Modified for ENCR014
211: -- Added Start_date, End_date and TBA
212: -- kkillams 15-04-2003 Modified c_igs_ps_usec_occurs cursor as part of performance bug 2749732
213: ------------------------------------------------------------------------------

Line 255: igs_ps_uso_instrctrs usoi

251: SELECT
252: person_Last_name ||', '||Person_first_name||' '|| person_middle_name instructor_name
253: FROM
254: hz_parties hz,
255: igs_ps_uso_instrctrs usoi
256: WHERE
257: hz.party_id = usoi.instructor_id AND
258: usoi.unit_section_occurrence_id = p_unit_section_occurence_id;
259:

Line 1781: igs_ps_uso_instrctrs a

1777: IS
1778: SELECT hz.person_last_name || ', '||hz.person_first_name || ' '||hz.person_middle_name instructor_name
1779: FROM
1780: hz_parties hz,
1781: igs_ps_uso_instrctrs a
1782: WHERE a.instructor_id(+) = hz.party_id
1783: AND a.unit_section_occurrence_id = p_uoo_id
1784: ORDER BY 1 ;
1785:

Line 3200: FROM igs_ps_uso_instrctrs instr,

3196:
3197: FUNCTION get_uso_instructors(p_n_uso_id IN NUMBER) RETURN VARCHAR2 IS
3198: CURSOR c_instr (cp_n_occurs_id IN NUMBER) IS
3199: SELECT pe.last_name || ', ' || pe.first_name || ' ' || pe.middle_name name
3200: FROM igs_ps_uso_instrctrs instr,
3201: igs_pe_person_base_v pe
3202: WHERE instr.unit_section_occurrence_id = cp_n_occurs_id AND
3203: instr.instructor_id = pe.person_id;
3204: l_c_instr VARCHAR2(32000);

Line 3366: FROM igs_ps_uso_instrctrs instr,

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
3366: FROM igs_ps_uso_instrctrs instr,
3367: igs_pe_person_base_v pe
3368: WHERE instr.unit_section_occurrence_id = cp_n_occurs_id AND
3369: instr.uso_instructor_id = pe.person_id;
3370: l_c_instr VARCHAR2(32000);