APPS.IGS_EN_GEN_015 dependencies on IGS_PE_USR_AVAL_ALL

Line 2172: FROM igs_en_cpd_ext eru, igs_pe_usr_aval_all uact, igs_lookups_view lkv

2168: --IF l_system_type = 'SS_ENROLL_STAFF' THEN -- if the log on user is self service enrollment staff
2169: -- removed the check so as to prepare the query for person type other than STUDENT and SS_ENROLL_STAFF also
2170:
2171: 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
2172: FROM igs_en_cpd_ext eru, igs_pe_usr_aval_all uact, igs_lookups_view lkv
2173: WHERE eru.s_enrolment_step_type = ''SPL_PERM'' AND
2174: eru.s_enrolment_step_type =lkv.lookup_code AND
2175: lkv.lookup_type = ''ENROLMENT_STEP_TYPE_EXT'' AND lkv.step_group_type = ''UNIT'' AND
2176: eru.s_enrolment_step_type = uact.validation(+) AND

Line 2351: igs_pe_usr_aval_all uact,

2347: SELECT
2348: eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkv.step_group_type --modified by nishikant
2349: FROM
2350: igs_en_cpd_ext eru,
2351: igs_pe_usr_aval_all uact,
2352: igs_lookups_view lkv
2353: WHERE
2354: eru.s_enrolment_step_type = cp_step AND
2355: eru.s_enrolment_step_type =lkv.lookup_code AND