APPS.PAYWSDYG_PKG dependencies on USER_OBJECTS

Line 2649: USER_OBJECTS B,

2645: from hr_api_hooks h,
2646: hr_api_modules m
2647: where m.api_module_id = h.api_module_id
2648: and m.module_name = cp_tab_name) V,
2649: USER_OBJECTS B,
2650: SYS.ARGUMENT$ A
2651: WHERE A.OBJ# = B.OBJECT_ID
2652: AND B.OBJECT_NAME = V.hook_package
2653: AND A.LEVEL# = 0

Line 2659: -- FROM USER_OBJECTS B,

2655: AND B.object_type = 'PACKAGE'
2656: AND rownum = 1;
2657: -- Commented for bug fix 7006158.
2658: -- SELECT /*+ ORDERED */ a.pls_type
2659: -- FROM USER_OBJECTS B,
2660: -- SYS.ARGUMENT$ A
2661: -- WHERE A.OBJ# = B.OBJECT_ID
2662: -- AND B.OBJECT_NAME in (select hook_package
2663: -- from hr_api_hooks h, hr_api_modules m

Line 3920: select status from user_objects

3916: l_dt_pkg_name pay_dated_tables.dyn_trigger_package_name%type;
3917: l_dt_pkg_gen pay_dated_tables.dyn_trig_pkg_generated%type;
3918:
3919: cursor csr_pkg_exist(cp_pkg in varchar2) is
3920: select status from user_objects
3921: where object_type = 'PACKAGE BODY'
3922: and object_name = cp_pkg;
3923: l_pkg_status all_objects.status%type;
3924: