APPS.IGS_PS_USEC_SCHEDULE dependencies on IGS_PE_PERSON_BASE_V

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 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);