APPS.IGS_EN_GEN_015 dependencies on IGS_LOOKUPS_VIEW

Line 2020: step_group_type igs_lookups_view.step_group_type%TYPE);

2016: s_enrolment_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE ,
2017: enrolment_cat igs_en_cpd_ext.enrolment_cat%TYPE,
2018: s_student_comm_type igs_en_cpd_ext.s_student_comm_type%TYPE,
2019: enr_method_type igs_en_cpd_ext.enr_method_type%TYPE,
2020: step_group_type igs_lookups_view.step_group_type%TYPE);
2021:
2022: TYPE cur_step_def IS REF CURSOR;
2023:
2024: cur_step_def_var cur_step_def; -- REF cursor variable

Line 2158: FROM igs_en_cpd_ext eru, igs_lookups_view lkv

2154:
2155: -- if the user log on is a student
2156: IF l_system_type = 'STUDENT' THEN
2157: 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
2158: FROM igs_en_cpd_ext eru, igs_lookups_view lkv
2159: WHERE eru.s_enrolment_step_type = ''SPL_PERM'' AND
2160: eru.s_enrolment_step_type =lkv.lookup_code AND
2161: lkv.lookup_type = ''ENROLMENT_STEP_TYPE_EXT'' AND lkv.step_group_type =
2162: ''UNIT'' AND eru.enrolment_cat = :1 AND eru.enr_method_type = :2

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 2321: CURSOR c_stud_step_def(cp_step IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE,

2317: FROM igs_pe_person_types
2318: WHERE person_type_code = cp_person_type;
2319:
2320:
2321: CURSOR c_stud_step_def(cp_step IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE,
2322: cp_enrollment_Category IGS_EN_CAT_PRC_DTL.enrolment_cat%TYPE,
2323: cp_enr_method IGS_EN_CAT_PRC_DTL.ENR_METHOD_TYPE%TYPE,
2324: cp_commencement_type IGS_EN_CAT_PRC_DTL.S_STUDENT_COMM_TYPE%TYPE
2325: ) IS

Line 2330: igs_lookups_view lkv

2326: SELECT
2327: eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkv.step_group_type --modified by nishikant
2328: FROM
2329: igs_en_cpd_ext eru,
2330: igs_lookups_view lkv
2331: WHERE
2332: eru.s_enrolment_step_type = cp_step AND
2333: eru.s_enrolment_step_type =lkv.lookup_code AND
2334: lkv.lookup_type = 'ENROLMENT_STEP_TYPE_EXT' AND

Line 2341: CURSOR c_staff_step_def(cp_step IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE,

2337: eru.enr_method_type = cp_enr_method AND
2338: (eru.s_student_comm_type = cp_commencement_type OR eru.s_student_comm_type = 'ALL')
2339: ORDER BY eru.step_order_num;
2340:
2341: CURSOR c_staff_step_def(cp_step IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE,
2342: cp_person_type igs_pe_person_types.PERSON_TYPE_CODE%TYPE,
2343: cp_enrollment_Category IGS_EN_CAT_PRC_DTL.enrolment_cat%TYPE,
2344: cp_enr_method IGS_EN_CAT_PRC_DTL.ENR_METHOD_TYPE%TYPE,
2345: cp_commencement_type IGS_EN_CAT_PRC_DTL.S_STUDENT_COMM_TYPE%TYPE

Line 2352: igs_lookups_view lkv

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
2356: lkv.lookup_type = 'ENROLMENT_STEP_TYPE_EXT' AND