APPS.BSC_LOCKS_PVT dependencies on BSC_DB_TABLES

Line 63: SELECT 1 FROM BSC_DB_TABLES

59: CURSOR c_validate_calendar(c_calendar_id NUMBER) IS
60: SELECT 1 FROM BSC_SYS_CALENDARS_B
61: WHERE CALENDAR_ID = c_calendar_id;
62: CURSOR c_validate_table(c_table_name VARCHAR2) IS
63: SELECT 1 FROM BSC_DB_TABLES
64: WHERE TABLE_NAME = c_table_name;
65:
66: BEGIN
67: --DBMS_OUTPUT.PUT_LINE('VALIDATE_OBJECT: '||p_object_key||' '||p_object_type);

Line 3627: FROM BSC_DB_TABLES;

3623: FND_GLOBAL.USER_ID,
3624: SYSDATE,
3625: FND_GLOBAL.USER_ID,
3626: l_session_id
3627: FROM BSC_DB_TABLES;
3628:
3629: INSERT INTO BSC_OBJECT_LOCK_USERS (
3630: OBJECT_KEY,
3631: OBJECT_TYPE,

Line 3654: FROM BSC_DB_TABLES;

3650: SYSDATE,
3651: FND_GLOBAL.USER_ID,
3652: SYSDATE,
3653: FND_GLOBAL.USER_ID
3654: FROM BSC_DB_TABLES;
3655:
3656: INSERT INTO BSC_OBJECT_LOCK_USERS (
3657: OBJECT_KEY,
3658: OBJECT_TYPE,

Line 3681: FROM BSC_DB_TABLES;

3677: SYSDATE,
3678: FND_GLOBAL.USER_ID,
3679: SYSDATE,
3680: FND_GLOBAL.USER_ID
3681: FROM BSC_DB_TABLES;
3682:
3683: EXCEPTION
3684: WHEN FND_API.G_EXC_ERROR THEN
3685: x_return_status := FND_API.G_RET_STS_ERROR;