DBA Data[Home] [Help]

APPS.BSC_MO_HELPER_PKG dependencies on USER_OBJECTS

Line 4720: SELECT count(1) FROM USER_OBJECTS

4716: l_count NUMBER;
4717: l_stmt varchar2(1000);
4718:
4719: CURSOR cObject IS
4720: SELECT count(1) FROM USER_OBJECTS
4721: WHERE OBJECT_NAME = upper(ObjectName);
4722: BEGIN
4723: l_count := 0;
4724: --The object name is searched in USER_OBJECTS. It works for APPS or Personal

Line 4724: --The object name is searched in USER_OBJECTS. It works for APPS or Personal

4720: SELECT count(1) FROM USER_OBJECTS
4721: WHERE OBJECT_NAME = upper(ObjectName);
4722: BEGIN
4723: l_count := 0;
4724: --The object name is searched in USER_OBJECTS. It works for APPS or Personal
4725: --mode. IF the object is in BSC schema in APPS schema should exist a SYNONYM.
4726:
4727: open cObject;
4728: FETCH cObject into l_count;