APPS.IGS_EN_ELGBL_UNIT dependencies on IGS_PE_USR_AVAL

Line 245: FROM igs_en_cpd_ext eru, igs_pe_usr_aval uact, igs_lookups_view lkv

241: -- removed the check so as to prepare the query for person type other than STUDENT and SS_ENROLL_STAFF also
242:
243: l_step_def_query := 'SELECT eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkv.step_group_type,
244: eru.s_rule_call_cd,eru.rul_sequence_number,eru.stud_audit_lim
245: FROM igs_en_cpd_ext eru, igs_pe_usr_aval uact, igs_lookups_view lkv
246: WHERE eru.s_enrolment_step_type =lkv.lookup_code AND
247: lkv.lookup_type = ''ENROLMENT_STEP_TYPE_EXT'' AND lkv.step_group_type = ''UNIT'' AND
248: eru.s_enrolment_step_type = uact.validation(+) AND
249: uact.person_type(+) = :1 AND NVL(uact.override_ind,''N'') = ''N'' AND

Line 4946: FROM IGS_PE_USR_AVAL

4942: WHERE person_type_code = cp_person_type_code;
4943:
4944: CURSOR c_admin_ovr (cp_person_type_code IN VARCHAR2) IS
4945: SELECT 'X'
4946: FROM IGS_PE_USR_AVAL
4947: WHERE PERSON_TYPE = cp_person_type_code
4948: AND validation = 'AWD_CRS_ONLY'
4949: AND OVERRIDE_IND = 'Y';
4950: