DBA Data[Home] [Help]

APPS.EDW_BSC_BRIDGE dependencies on EDW_LEVELS_MD_V

Line 926: from edw_levels_md_v lvl

922: ) RETURN VARCHAR2 IS
923: l_level_name EDW_DIMENSIONS_MD_V.DIM_NAME%TYPE;
924: BEGIN
925: select level_name into l_level_name
926: from edw_levels_md_v lvl
927: where dim_name = p_dim
928: and not exists(
929: select 1 from
930: edw_hierarchy_level_md_v hier

Line 941: l_level_name EDW_LEVELS_MD_V.LEVEL_NAME%TYPE;

937:
938: FUNCTION GET_LOWEST_LEVEL(
939: p_dim_id IN NUMBER
940: ) RETURN VARCHAR2 IS
941: l_level_name EDW_LEVELS_MD_V.LEVEL_NAME%TYPE;
942: BEGIN
943: select level_name into l_level_name
944: from edw_levels_md_v lvl
945: where dim_id = p_dim_id

Line 944: from edw_levels_md_v lvl

940: ) RETURN VARCHAR2 IS
941: l_level_name EDW_LEVELS_MD_V.LEVEL_NAME%TYPE;
942: BEGIN
943: select level_name into l_level_name
944: from edw_levels_md_v lvl
945: where dim_id = p_dim_id
946: and not exists(
947: select 1 from
948: edw_hierarchy_level_md_v hier