DBA Data[Home] [Help]

APPS.MSC_REFRESH_MV dependencies on ALL_OBJECTS

Line 25: FROM all_objects

21: AND b.application_id= p_schema_id;
22:
23: Cursor mv_exist(p_mv_trim_name varchar2, p_schema_name varchar2) IS
24: SELECT 1
25: FROM all_objects
26: WHERE object_name = p_mv_trim_name
27: AND owner = p_schema_name;
28:
29: BEGIN