APPS.CSM_QUERY_PKG dependencies on ALL_OBJECTS

Line 1474: SELECT 1 FROM ALL_OBJECTS

1470: WHERE QUERY_ID = c_QUERY_ID;
1471:
1472: CURSOR c_check_table_access (c_schema VARCHAR2,c_object_name VARCHAR2)
1473: IS
1474: SELECT 1 FROM ALL_OBJECTS
1475: WHERE OBJECT_NAME = c_object_name
1476: AND OWNER = c_schema
1477: AND OBJECT_TYPE IN('TABLE','VIEW','SYNONYM');
1478:

Line 1861: FROM all_objects

1857:
1858: CURSOR c_is_package_valid (c_package_name VARCHAR2, p_schema_name VARCHAR2)
1859: IS
1860: SELECT object_name
1861: FROM all_objects
1862: WHERE object_name = c_package_name
1863: AND OWNER = p_schema_name
1864: AND object_type = 'PACKAGE'
1865: AND status = 'VALID';