DBA Data[Home] [Help]

APPS.PAYWSDYG_PKG dependencies on ARGUMENT$

Line 2687: SYS.ARGUMENT$ A

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
2691: AND A.argument = cp_param_name

Line 2697: -- SYS.ARGUMENT$ A

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
2701: -- where m.api_module_id = h.api_module_id