APPS.BSC_LOCKS_PVT dependencies on BSC_SYS_DIM_LEVELS_B

Line 41: SELECT 1 FROM BSC_SYS_DIM_LEVELS_B

37: CURSOR c_validate_dimension(c_dim_group_id NUMBER) IS
38: SELECT 1 FROM BSC_SYS_DIM_GROUPS_TL
39: WHERE DIM_GROUP_ID = c_dim_group_id;
40: CURSOR c_validate_dimension_object(c_dim_level_id NUMBER) IS
41: SELECT 1 FROM BSC_SYS_DIM_LEVELS_B
42: WHERE DIM_LEVEL_ID = c_dim_level_id;
43: CURSOR c_validate_measure(c_dataset_id NUMBER) IS
44: SELECT 1 FROM BSC_SYS_DATASETS_B
45: WHERE DATASET_ID = c_dataset_id;

Line 1529: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

1525:
1526: CURSOR c_get_child_dimension(c_dim_group_id NUMBER) IS
1527: SELECT TO_CHAR(DIM_LEVEL_ID) OBJECT_KEY,
1528: 'DIMENSION_OBJECT' OBJECT_TYPE
1529: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
1530: WHERE DIM_GROUP_ID = c_dim_group_id;
1531:
1532: CURSOR c_get_child_measure(c_dataset_id NUMBER) IS
1533: SELECT TO_CHAR(MEASURE_ID1) OBJECT_KEY,

Line 2476: FROM BSC_SYS_DIM_LEVELS_B;

2472: FND_GLOBAL.USER_ID,
2473: SYSDATE,
2474: FND_GLOBAL.USER_ID,
2475: l_session_id
2476: FROM BSC_SYS_DIM_LEVELS_B;
2477:
2478: INSERT INTO BSC_OBJECT_LOCK_USERS (
2479: OBJECT_KEY,
2480: OBJECT_TYPE,

Line 2503: FROM BSC_SYS_DIM_LEVELS_B;

2499: SYSDATE,
2500: FND_GLOBAL.USER_ID,
2501: SYSDATE,
2502: FND_GLOBAL.USER_ID
2503: FROM BSC_SYS_DIM_LEVELS_B;
2504:
2505: INSERT INTO BSC_OBJECT_LOCK_USERS (
2506: OBJECT_KEY,
2507: OBJECT_TYPE,

Line 2530: FROM BSC_SYS_DIM_LEVELS_B;

2526: SYSDATE,
2527: FND_GLOBAL.USER_ID,
2528: SYSDATE,
2529: FND_GLOBAL.USER_ID
2530: FROM BSC_SYS_DIM_LEVELS_B;
2531:
2532: EXCEPTION
2533: WHEN FND_API.G_EXC_ERROR THEN
2534: x_return_status := FND_API.G_RET_STS_ERROR;