APPS.EDW_SEC_POLICY dependencies on USER_VIEWS

Line 49: select count(*) into x_count from user_views

45:
46: -- The object will either be a view owned by APPS or a synonym pointing to a table
47: -- Check if the object is view
48:
49: select count(*) into x_count from user_views
50: where view_name = UPPER(fact_short_name);
51:
52:
53: IF x_count = 1 THEN /* It is a view owned by APPS */

Line 134: select count(*) into x_count from user_views

130:
131: -- The object will either be a view owned by APPS or a synonym pointing to a table
132: -- Check if the object is view
133:
134: select count(*) into x_count from user_views
135: where view_name = UPPER(fact_short_name);
136:
137:
138: IF x_count = 1 THEN /* It is a view owned by APPS */

Line 225: select count(*) into x_count from user_views

221:
222: -- The object will either be a view owned by APPS or a synonym pointing to a table
223: -- Check if the object is view
224:
225: select count(*) into x_count from user_views
226: where view_name = UPPER(fact_short_name);
227:
228:
229: IF x_count = 1 THEN /* It is a view owned by APPS */

Line 311: select count(*) into x_count from user_views

307:
308: -- The object will either be a view owned by APPS or a synonym pointing to a table
309: -- Check if the object is view
310:
311: select count(*) into x_count from user_views
312: where view_name = UPPER(fact_short_name);
313:
314:
315: IF x_count = 1 THEN /* It is a view owned by APPS */