DBA Data[Home] [Help]

APPS.IGS_AD_GEN_006 dependencies on IGS_AD_TER_ED_LVL_QF

Line 241: FROM IGS_AD_TER_ED_LVL_QF

237: -- from the TAC level of qualification.
238: DECLARE
239: CURSOR c_telq IS
240: SELECT tertiary_edu_lvl_qual
241: FROM IGS_AD_TER_ED_LVL_QF
242: WHERE tac_level_of_qual = p_tac_level_of_qual AND
243: closed_ind = 'N';
244: v_tertiary_edu_lvl_qual
245: IGS_AD_TER_ED_LVL_QF.tertiary_edu_lvl_qual%TYPE DEFAULT NULL;

Line 245: IGS_AD_TER_ED_LVL_QF.tertiary_edu_lvl_qual%TYPE DEFAULT NULL;

241: FROM IGS_AD_TER_ED_LVL_QF
242: WHERE tac_level_of_qual = p_tac_level_of_qual AND
243: closed_ind = 'N';
244: v_tertiary_edu_lvl_qual
245: IGS_AD_TER_ED_LVL_QF.tertiary_edu_lvl_qual%TYPE DEFAULT NULL;
246: BEGIN
247: -- Cursor handling
248: OPEN c_telq ;
249: FETCH c_telq INTO v_tertiary_edu_lvl_qual;