APPS.IGS_EN_GEN_008 dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 2148: FROM igs_pe_typ_instances_all

2144: -- depending on the course code passed into the function
2145: -- cursor is modified for performance bug 3696901
2146: CURSOR cur_typ_instances( cp_person_id igs_pe_hz_parties.party_id%TYPE) IS
2147: SELECT person_type_code
2148: FROM igs_pe_typ_instances_all
2149: WHERE person_id = cp_person_id AND
2150: course_cd = NVL(p_course_cd,course_cd) AND
2151: end_date IS NULL AND
2152: person_type_code IN ( SELECT person_type_code