DBA Data[Home] [Help]

APPS.PAYWSDYG_PKG dependencies on ARGUMENT$

Line 2650: SYS.ARGUMENT$ A

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

Line 2660: -- SYS.ARGUMENT$ A

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