103:
104: Function Enrp_Get_Ecps_Group(
105: p_s_enrolment_step_type IN VARCHAR2 )
106: RETURN VARCHAR2 AS
107: v_step_group_type IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE;
108: CURSOR c_sest (cp_s_enrolment_step_type
109: IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE) IS
110: SELECT step_group_type
111: FROM IGS_LOOKUPS_VIEW
105: p_s_enrolment_step_type IN VARCHAR2 )
106: RETURN VARCHAR2 AS
107: v_step_group_type IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE;
108: CURSOR c_sest (cp_s_enrolment_step_type
109: IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE) IS
110: SELECT step_group_type
111: FROM IGS_LOOKUPS_VIEW
112: WHERE LOOKUP_CODE = cp_s_enrolment_step_type AND
113: LOOKUP_TYPE = 'ENROLMENT_STEP_TYPE';
107: v_step_group_type IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE;
108: CURSOR c_sest (cp_s_enrolment_step_type
109: IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE) IS
110: SELECT step_group_type
111: FROM IGS_LOOKUPS_VIEW
112: WHERE LOOKUP_CODE = cp_s_enrolment_step_type AND
113: LOOKUP_TYPE = 'ENROLMENT_STEP_TYPE';
114: BEGIN
115: v_step_group_type := NULL;