APPS.IGS_PS_USEC_SCHEDULE dependencies on IGS_PS_USEC_TCH_RESP

Line 237: l_lead_instructor_id igs_ps_usec_tch_resp.instructor_id%TYPE;

233: l_end_date igs_ca_inst.end_dt%TYPE;
234: l_trans_type igs_ps_sch_int_all.transaction_type%TYPE;
235: l_int_usec_id igs_ps_sch_usec_int_all.int_usec_id%TYPE;
236: l_max_enr_meet_grp igs_ps_uso_clas_meet_v.enrollment_maximum%TYPE;
237: l_lead_instructor_id igs_ps_usec_tch_resp.instructor_id%TYPE;
238: l_surname igs_pe_person.surname%TYPE ;
239: l_given_names igs_pe_person.given_names%TYPE ;
240: l_middle_name igs_pe_person.middle_name%TYPE;
241: l_data_found BOOLEAN := FALSE; -- Added as a part of Bug # 2383553

Line 326: FROM igs_ps_usec_tch_resp

322: FUNCTION get_instructor_info (p_n_uoo_id IN NUMBER) RETURN BOOLEAN AS
323: -- Get the lead instructor identifier
324: CURSOR c_lead_instructor (cp_n_uoo_id IN NUMBER) IS
325: SELECT instructor_id
326: FROM igs_ps_usec_tch_resp
327: WHERE uoo_id = cp_n_uoo_id
328: AND lead_instructor_flag = 'Y' ;
329:
330: -- Get the given name (first name), middle name and last name for the given Instructor Identifier