APPS.IGS_FI_LOAD_EXT_CHG dependencies on IGS_PE_PERSON_TYPES

Line 906: FROM igs_pe_typ_instances_all pti, igs_pe_person_types pty

902: l_v_output VARCHAR2(1);
903:
904: CURSOR c_person_typ (cp_person_id igs_pe_typ_instances_all.person_id%TYPE) IS
905: SELECT 1
906: FROM igs_pe_typ_instances_all pti, igs_pe_person_types pty
907: WHERE pti.person_type_code = pty.person_type_code AND
908: pty.system_type IN ('STUDENT','FORMER_STUDENT') AND
909: pti.person_id = cp_person_id;
910: