[Home] [Help]
141: s_enrolment_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE ,
142: enrolment_cat igs_en_cpd_ext.enrolment_cat%TYPE,
143: s_student_comm_type igs_en_cpd_ext.s_student_comm_type%TYPE,
144: enr_method_type igs_en_cpd_ext.enr_method_type%TYPE,
145: step_group_type igs_lookups_view.step_group_type%TYPE,
146: s_rule_call_cd igs_en_cpd_ext.s_rule_call_cd%TYPE,
147: rul_sequence_number igs_en_cpd_ext.rul_sequence_number%TYPE,
148: stud_audit_lim igs_en_cpd_ext.stud_audit_lim%TYPE); -- added for Audit build
149:
226: IF l_system_type = 'STUDENT' THEN
227:
228: 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,
229: eru.s_rule_call_cd,eru.rul_sequence_number,eru.stud_audit_lim
230: FROM igs_en_cpd_ext eru, igs_lookups_view lkv
231: WHERE eru.s_enrolment_step_type =lkv.lookup_code AND
232: lkv.lookup_type = ''ENROLMENT_STEP_TYPE_EXT'' AND lkv.step_group_type =
233: ''UNIT'' AND eru.enrolment_cat = :1 AND eru.enr_method_type = :2
234: AND ( eru.s_student_comm_type = :3 OR eru.s_student_comm_type = ''ALL'')
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