APPS.IGS_PS_FAC_CREDT_WRKLOAD dependencies on IGS_PE_PERSON_BASE_V

Line 35: sommukhe 14-FEB-2006 Bug #3104276, replaced igs_pe_person with igs_pe_person_base_v for cursor cur_lead_instructor

31: Know limitations, enhancements or remarks
32: Change History
33: Who When What
34: (reverse chronological order - newest change first)
35: sommukhe 14-FEB-2006 Bug #3104276, replaced igs_pe_person with igs_pe_person_base_v for cursor cur_lead_instructor
36: ***************************************************************/
37:
38: CURSOR cur_lead_instructor IS
39: SELECT pe.last_name || ', ' || pe.title || ' ' || NVL(pe.known_as,pe.first_name) instructor_name

Line 41: igs_pe_person_base_v pe,

37:
38: CURSOR cur_lead_instructor IS
39: SELECT pe.last_name || ', ' || pe.title || ' ' || NVL(pe.known_as,pe.first_name) instructor_name
40: FROM igs_ps_usec_tch_resp utr,
41: igs_pe_person_base_v pe,
42: igs_pe_person_id_typ ppi,
43: igs_pe_alt_pers_id pit
44: WHERE utr.instructor_id = pe.person_id AND
45: utr.uoo_id = p_uoo_id AND