APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_PE_PERSON_TYPES

Line 940: FROM igs_pe_person_types typ,

936: -- former student
937: --
938: CURSOR cur_student_type (cp_person_id IN NUMBER) IS
939: SELECT 'Y' current_student
940: FROM igs_pe_person_types typ,
941: igs_pe_typ_instances_all inst
942: WHERE inst.person_id = cp_person_id
943: AND inst.person_type_code = typ.person_type_code
944: AND typ.system_type = 'STUDENT'