APPS.BSC_LOCKS_PVT dependencies on BSC_SYS_PERIODICITIES

Line 57: SELECT 1 FROM BSC_SYS_PERIODICITIES

53: CURSOR c_validate_launchpad(c_menu_id NUMBER) IS
54: SELECT 1 FROM FND_MENUS
55: WHERE MENU_ID = c_menu_id;
56: CURSOR c_validate_periodicity(c_periodicity_id NUMBER) IS
57: SELECT 1 FROM BSC_SYS_PERIODICITIES
58: WHERE PERIODICITY_ID = c_periodicity_id;
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;

Line 3299: FROM BSC_SYS_PERIODICITIES;

3295: FND_GLOBAL.USER_ID,
3296: SYSDATE,
3297: FND_GLOBAL.USER_ID,
3298: l_session_id
3299: FROM BSC_SYS_PERIODICITIES;
3300:
3301: INSERT INTO BSC_OBJECT_LOCK_USERS (
3302: OBJECT_KEY,
3303: OBJECT_TYPE,

Line 3326: FROM BSC_SYS_PERIODICITIES;

3322: SYSDATE,
3323: FND_GLOBAL.USER_ID,
3324: SYSDATE,
3325: FND_GLOBAL.USER_ID
3326: FROM BSC_SYS_PERIODICITIES;
3327:
3328: INSERT INTO BSC_OBJECT_LOCK_USERS (
3329: OBJECT_KEY,
3330: OBJECT_TYPE,

Line 3353: FROM BSC_SYS_PERIODICITIES;

3349: SYSDATE,
3350: FND_GLOBAL.USER_ID,
3351: SYSDATE,
3352: FND_GLOBAL.USER_ID
3353: FROM BSC_SYS_PERIODICITIES;
3354:
3355: EXCEPTION
3356: WHEN FND_API.G_EXC_ERROR THEN
3357: x_return_status := FND_API.G_RET_STS_ERROR;