APPS.IGS_EN_GEN_015 dependencies on IGS_PE_USR_AVAL

Line 126: CURSOR c_step_overridden (cp_validation igs_pe_usr_aval.validation%TYPE,

122:
123: l_cur_person_types cur_person_types%ROWTYPE;
124: l_system_person_type igs_pe_person_types.system_type%TYPE;
125:
126: CURSOR c_step_overridden (cp_validation igs_pe_usr_aval.validation%TYPE,
127: cp_person_type igs_pe_person_types.person_type_code%TYPE) IS
128: SELECT override_ind
129: FROM igs_pe_usr_aval
130: WHERE validation = cp_validation

Line 129: FROM igs_pe_usr_aval

125:
126: CURSOR c_step_overridden (cp_validation igs_pe_usr_aval.validation%TYPE,
127: cp_person_type igs_pe_person_types.person_type_code%TYPE) IS
128: SELECT override_ind
129: FROM igs_pe_usr_aval
130: WHERE validation = cp_validation
131: AND override_ind = 'Y'
132: AND person_type = cp_person_type;
133:

Line 134: l_step_overridden igs_pe_usr_aval.override_ind%TYPE;

130: WHERE validation = cp_validation
131: AND override_ind = 'Y'
132: AND person_type = cp_person_type;
133:
134: l_step_overridden igs_pe_usr_aval.override_ind%TYPE;
135:
136: BEGIN
137:
138: l_step_overridden := 'N';

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