DBA Data[Home] [Help]

APPS.BIS_DIMENSION_LEVEL_PVT dependencies on BIS_TARGET_LEVELS

Line 2391: SELECT COUNT(1) INTO l_target_usage FROM bis_target_levels tl, bis_target_values tv

2387:
2388: FUNCTION IS_TARGET_DEFINED( p_dim_level_id IN NUMBER) RETURN BOOLEAN IS
2389: l_target_usage NUMBER;
2390: BEGIN
2391: SELECT COUNT(1) INTO l_target_usage FROM bis_target_levels tl, bis_target_values tv
2392: WHERE ( tl.TIME_LEVEL_ID = p_dim_level_id OR
2393: tl.ORG_LEVEL_ID = p_dim_level_id OR
2394: tl.DIMENSION1_LEVEL_ID = p_dim_level_id OR
2395: tl.DIMENSION2_LEVEL_ID = p_dim_level_id OR