DBA Data[Home] [Help]

APPS.IGS_EN_ELGBL_OVERRIDE dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 907: FROM igs_pe_typ_instances_all pti,

903: -- Cursor to check whether active sevis person type exists for that person
904: -- modified by ckasu as a part of bug 5300119
905: CURSOR c_sevis_person_type IS
906: SELECT 'X'
907: FROM igs_pe_typ_instances_all pti,
908: igs_pe_person_types pt
909: WHERE pt.person_type_code = pti.person_type_code
910: AND system_type IN ('NONIMG_STUDENT')
911: AND person_id = p_person_id