DBA Data[Home] [Help]

APPS.BSC_LOCKS_PVT dependencies on BSC_TABS_B

Line 32: SELECT 1 FROM BSC_TABS_B

28: l_object_key1 NUMBER;
29: l_object_key2 NUMBER;
30:
31: CURSOR c_validate_scorecard(c_tab_id NUMBER) IS
32: SELECT 1 FROM BSC_TABS_B
33: WHERE TAB_ID = c_tab_id;
34: CURSOR c_validate_objective(c_indicator NUMBER) IS
35: SELECT 1 FROM BSC_KPIS_B
36: WHERE INDICATOR = c_indicator;

Line 1984: FROM BSC_TABS_B;

1980: FND_GLOBAL.USER_ID,
1981: SYSDATE,
1982: FND_GLOBAL.USER_ID,
1983: l_session_id
1984: FROM BSC_TABS_B;
1985:
1986: INSERT INTO BSC_OBJECT_LOCK_USERS (
1987: OBJECT_KEY,
1988: OBJECT_TYPE,

Line 2011: FROM BSC_TABS_B;

2007: SYSDATE,
2008: FND_GLOBAL.USER_ID,
2009: SYSDATE,
2010: FND_GLOBAL.USER_ID
2011: FROM BSC_TABS_B;
2012:
2013: INSERT INTO BSC_OBJECT_LOCK_USERS (
2014: OBJECT_KEY,
2015: OBJECT_TYPE,

Line 2038: FROM BSC_TABS_B;

2034: SYSDATE,
2035: FND_GLOBAL.USER_ID,
2036: SYSDATE,
2037: FND_GLOBAL.USER_ID
2038: FROM BSC_TABS_B;
2039:
2040: EXCEPTION
2041: WHEN FND_API.G_EXC_ERROR THEN
2042: x_return_status := FND_API.G_RET_STS_ERROR;