APPS.BSC_MO_HELPER_PKG dependencies on DUAL

Line 306: SELECT BSC_APPS.Get_Tablespace_Clause_Tbl FROM DUAL;

302: l_stmt varchar2(1000);
303: l_return_value varchar2(1000);
304: cv CurTyp;
305: CURSOR cTableSpace IS
306: SELECT BSC_APPS.Get_Tablespace_Clause_Tbl FROM DUAL;
307: BEGIN
308:
309: OPEN cTableSpace;
310: FETCH cTableSpace INTO l_return_value;

Line 329: l_stmt := 'SELECT BSC_APPS.Get_Tablespace_Clause_Idx FROM DUAL';

325: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
326: bsc_mo_helper_pkg.writeTmp('Inside getTablespaceClauseIdx', FND_LOG.LEVEL_PROCEDURE);
327: END IF;
328:
329: l_stmt := 'SELECT BSC_APPS.Get_Tablespace_Clause_Idx FROM DUAL';
330:
331: OPEN cv FOR l_stmt;
332: FETCH cv INTO l_return_value;
333: CLOSE cv;

Line 350: SELECT BSC_APPS.Get_Storage_Clause FROM DUAL;

346: FUNCTION getStorageClause RETURN VARCHAR2 IS
347: l_stmt varchar2(1000);
348: l_return_value varchar2(1000);
349: CURSOR cStorage IS
350: SELECT BSC_APPS.Get_Storage_Clause FROM DUAL;
351:
352: BEGIN
353: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
354: bsc_mo_helper_pkg.writeTmp('Inside getStorageClause', FND_LOG.LEVEL_PROCEDURE);