APPS.BSC_LOCKS_PVT dependencies on BSC_SYS_DIM_GROUPS_TL

Line 38: SELECT 1 FROM BSC_SYS_DIM_GROUPS_TL

34: CURSOR c_validate_objective(c_indicator NUMBER) IS
35: SELECT 1 FROM BSC_KPIS_B
36: WHERE INDICATOR = c_indicator;
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;

Line 2312: FROM BSC_SYS_DIM_GROUPS_TL;

2308: FND_GLOBAL.USER_ID,
2309: SYSDATE,
2310: FND_GLOBAL.USER_ID,
2311: l_session_id
2312: FROM BSC_SYS_DIM_GROUPS_TL;
2313:
2314: INSERT INTO BSC_OBJECT_LOCK_USERS (
2315: OBJECT_KEY,
2316: OBJECT_TYPE,

Line 2339: FROM BSC_SYS_DIM_GROUPS_TL;

2335: SYSDATE,
2336: FND_GLOBAL.USER_ID,
2337: SYSDATE,
2338: FND_GLOBAL.USER_ID
2339: FROM BSC_SYS_DIM_GROUPS_TL;
2340:
2341: INSERT INTO BSC_OBJECT_LOCK_USERS (
2342: OBJECT_KEY,
2343: OBJECT_TYPE,

Line 2366: FROM BSC_SYS_DIM_GROUPS_TL;

2362: SYSDATE,
2363: FND_GLOBAL.USER_ID,
2364: SYSDATE,
2365: FND_GLOBAL.USER_ID
2366: FROM BSC_SYS_DIM_GROUPS_TL;
2367:
2368: EXCEPTION
2369: WHEN FND_API.G_EXC_ERROR THEN
2370: x_return_status := FND_API.G_RET_STS_ERROR;