APPS.PAYWSDYG_PKG dependencies on USER_OBJECTS

Line 2686: USER_OBJECTS B,

2682: from hr_api_hooks h,
2683: hr_api_modules m
2684: where m.api_module_id = h.api_module_id
2685: and m.module_name = cp_tab_name) V,
2686: USER_OBJECTS B,
2687: SYS.ARGUMENT$ A
2688: WHERE A.OBJ# = B.OBJECT_ID
2689: AND B.OBJECT_NAME = V.hook_package
2690: AND A.LEVEL# = 0

Line 2696: -- FROM USER_OBJECTS B,

2692: AND B.object_type = 'PACKAGE'
2693: AND rownum = 1;
2694: -- Commented for bug fix 7006158.
2695: -- SELECT /*+ ORDERED */ a.pls_type
2696: -- FROM USER_OBJECTS B,
2697: -- SYS.ARGUMENT$ A
2698: -- WHERE A.OBJ# = B.OBJECT_ID
2699: -- AND B.OBJECT_NAME in (select hook_package
2700: -- from hr_api_hooks h, hr_api_modules m

Line 3958: select status from user_objects

3954: l_dt_pkg_name pay_dated_tables.dyn_trigger_package_name%type;
3955: l_dt_pkg_gen pay_dated_tables.dyn_trig_pkg_generated%type;
3956:
3957: cursor csr_pkg_exist(cp_pkg in varchar2) is
3958: select status from user_objects
3959: where object_type = 'PACKAGE BODY'
3960: and object_name = cp_pkg;
3961: l_pkg_status all_objects.status%type;
3962: