APPS.IGS_SS_ENR_DETAILS dependencies on IGS_PE_PERSON_BASE_V

Line 1700: FROM igs_pe_person_base_v a,

1696: p_uoo_id IN NUMBER
1697: ) RETURN VARCHAR2 AS
1698: CURSOR cur_lead_instr_info IS
1699: SELECT first_name || ' ' || last_name Instructor_Name
1700: FROM igs_pe_person_base_v a,
1701: igs_ps_usec_tch_resp b
1702: WHERE b.uoo_id = p_uoo_id AND
1703: b.INSTRUCTOR_ID = a.person_id AND
1704: b.LEAD_INSTRUCTOR_FLAG = 'Y';

Line 3201: igs_pe_person_base_v pe

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);
3205: l_b_found boolean;

Line 3367: igs_pe_person_base_v pe

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);
3371: l_c_uso_instr VARCHAR2(32000);