DBA Data[Home] [Help]

APPS.BSC_OAF_VIEWS_PVT dependencies on BSC_SYS_DIM_LEVELS_VL

Line 670: BSC_SYS_DIM_LEVELS_VL PL

666: ) RETURN VARCHAR2 IS
667: CURSOR c_parents IS
668: SELECT PL.NAME
669: FROM BSC_SYS_DIM_LEVEL_RELS LR,
670: BSC_SYS_DIM_LEVELS_VL PL
671: WHERE LR.DIM_LEVEL_ID = p_level_id
672: AND PL.DIM_LEVEL_ID = PARENT_DIM_LEVEL_ID;
673: v_name BSC_SYS_DIM_LEVELS_TL.NAME%TYPE;
674: v_parents VARCHAR2(3000) := '';