285: BEGIN -- ADMP_GET_LVL_COMP
286: --This module finds the user defined tertiary education
287: --level of completion from the TAC level of completion
288: DECLARE
289: v_tertiary_edu_lvl_comp IGS_AD_TER_ED_LV_COM.tertiary_edu_lvl_comp%TYPE;
290: CURSOR c_teloc IS
291: SELECT teloc.tertiary_edu_lvl_comp
292: FROM IGS_AD_TER_ED_LV_COM teloc
293: WHERE teloc.tac_level_of_comp = p_tac_level_of_comp AND
288: DECLARE
289: v_tertiary_edu_lvl_comp IGS_AD_TER_ED_LV_COM.tertiary_edu_lvl_comp%TYPE;
290: CURSOR c_teloc IS
291: SELECT teloc.tertiary_edu_lvl_comp
292: FROM IGS_AD_TER_ED_LV_COM teloc
293: WHERE teloc.tac_level_of_comp = p_tac_level_of_comp AND
294: teloc.closed_ind = 'N';
295: BEGIN
296: OPEN c_teloc;