APPS.EDW_COMPILE_PACKAGES dependencies on USER_OBJECTS

Line 15: SELECT distinct object_name from user_objects

11: l_stmt varchar2(100):= ' ALTER PACKAGE :S1 COMPILE';
12: l_dir varchar2(100);
13: l_expr varchar2(100);
14: cursor c_packages(p_type varchar2) is
15: SELECT distinct object_name from user_objects
16: where object_type = p_type and status = 'INVALID'
17: and object_name like l_expr;
18:
19: BEGIN