APPS.IGS_PS_FAC_CREDT_WRKLOAD dependencies on IGS_PE_PERSON_ID_TYP

Line 42: igs_pe_person_id_typ ppi,

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
46: pe.person_id = pit.pe_person_id (+) AND