APPS.BSC_UTILITY dependencies on USER_OBJECTS

Line 479: user_objects

475: object_name
476: INTO
477: l_object_name
478: FROM
479: user_objects
480: WHERE
481: object_name = l_edw_obj_name
482: AND object_type IN ('VIEW', 'SYNONYM');
483:

Line 536: user_objects

532: object_name
533: INTO
534: l_object_name
535: FROM
536: user_objects
537: WHERE
538: object_name = l_bsc_obj_name
539: AND object_type = 'PACKAGE BODY';
540:

Line 633: user_objects

629: object_name
630: INTO
631: l_object_name
632: FROM
633: user_objects
634: WHERE
635: object_name = l_edw_obj_name
636: AND object_type IN ('VIEW', 'SYNONYM');
637:

Line 693: user_objects

689: object_name
690: INTO
691: l_object_name
692: FROM
693: user_objects
694: WHERE
695: object_name = l_bsc_obj_name
696: AND object_type = 'PACKAGE BODY';
697:

Line 1454: FROM user_objects

1450:
1451: CURSOR c_object_type(c_object_name VARCHAR2)
1452: IS
1453: SELECT object_type
1454: FROM user_objects
1455: WHERE object_name = c_object_name;
1456:
1457: CURSOR c_owner(c_syn_name VARCHAR2)
1458: IS

Line 3158: FROM USER_OBJECTS A

3154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3155: END IF;
3156:
3157: SELECT COUNT(1) INTO l_Count
3158: FROM USER_OBJECTS A
3159: WHERE A.OBJECT_NAME = l_Package_Name
3160: AND A.STATUS = C_PACKAGE_STATUS_INVALID;
3161:
3162: -- BIS_PLSQL_PKG_NOT_EXIST