APPS.IGS_PS_USEC_SCHEDULE dependencies on IGS_PE_PERSON

Line 238: l_surname igs_pe_person.surname%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
242: usec_occur_rec usec_occur%ROWTYPE;

Line 239: l_given_names igs_pe_person.given_names%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
242: usec_occur_rec usec_occur%ROWTYPE;
243: rec_end_dt c_end_dt%ROWTYPE;

Line 240: l_middle_name igs_pe_person.middle_name%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
242: usec_occur_rec usec_occur%ROWTYPE;
243: rec_end_dt c_end_dt%ROWTYPE;
244: l_cal BOOLEAN := TRUE; -- Added as a part of Bug # 2833850

Line 335: FROM igs_pe_person_base_v

331: CURSOR c_get_names(cp_n_ins_id IN NUMBER) IS
332: SELECT first_name,
333: middle_name,
334: last_name
335: FROM igs_pe_person_base_v
336: WHERE person_id = cp_n_ins_id;
337: l_ret_type BOOLEAN;
338: BEGIN
339: l_lead_instructor_id := NULL;

Line 902: sommukhe 24-Jan-2006 Bug #4926548,replaced igs_pe_person_v with hz_parties for cursor instrs

898:
899: Change History
900:
901: Who When What
902: sommukhe 24-Jan-2006 Bug #4926548,replaced igs_pe_person_v with hz_parties for cursor instrs
903: ***************************************************************/
904: l_int_occurs_id igs_ps_sch_int_all.int_occurs_id%TYPE;
905: -- Get the reference code and reference code type
906: CURSOR ref_cd( l_usec_id igs_ps_usec_occurs.unit_section_occurrence_id%TYPE) IS

Line 4385: CURSOR c_ins_name(cp_n_lead_instructor_id igs_pe_person_base_v.person_id%TYPE) IS

4381: (reverse chronological order - newest change first)
4382: sarakshi 12-Jan-2006 Bug#4926548, created cursors bld_desc,rom_desc and cur_lookup_meaning and used them appropriately
4383: ************************************************************************/
4384:
4385: CURSOR c_ins_name(cp_n_lead_instructor_id igs_pe_person_base_v.person_id%TYPE) IS
4386: SELECT first_name , last_name
4387: FROM igs_pe_person_base_v
4388: WHERE person_id = cp_n_lead_instructor_id;
4389:

Line 4387: FROM igs_pe_person_base_v

4383: ************************************************************************/
4384:
4385: CURSOR c_ins_name(cp_n_lead_instructor_id igs_pe_person_base_v.person_id%TYPE) IS
4386: SELECT first_name , last_name
4387: FROM igs_pe_person_base_v
4388: WHERE person_id = cp_n_lead_instructor_id;
4389:
4390: rec_ins_name c_ins_name%ROWTYPE;
4391: l_str VARCHAR2(1000);