DBA Data[Home] [Help]

APPS.IGS_AD_PRC_TAC_OFFER dependencies on IGS_AD_TER_ED_LV_COM

Line 289: v_tertiary_edu_lvl_comp IGS_AD_TER_ED_LV_COM.tertiary_edu_lvl_comp%TYPE;

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

Line 292: FROM IGS_AD_TER_ED_LV_COM teloc

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;