APPS.PAYWSDYG_PKG dependencies on HR_API_HOOKS

Line 2682: from hr_api_hooks h,

2678: is
2679: SELECT /*+ ORDERED */ a.pls_type
2680: FROM (select /*+ NO_MERGE */
2681: DISTINCT hook_package
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,

Line 2700: -- from hr_api_hooks h, hr_api_modules m

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
2702: -- and m.module_name = cp_tab_name)
2703: -- AND A.LEVEL# = 0
2704: -- AND A.argument = cp_param_name

Line 2815: from hr_api_hooks h, hr_api_modules m

2811: select hook_package pkg, hook_procedure proc
2812: ,decode(hook_procedure, 'AFTER_INSERT', 'PI',
2813: 'AFTER_UPDATE', 'PU',
2814: 'AFTER_DELETE', 'PD') usage_type
2815: from hr_api_hooks h, hr_api_modules m
2816: where m.api_module_id = h.api_module_id
2817: and m.module_name = cp_tab_name;
2818: --
2819:

Line 3899: hr_api_hooks ah,

3895: set enabled_flag = l_hooks
3896: where api_hook_call_id in (
3897: select api_hook_call_id
3898: from hr_api_hook_calls ahc,
3899: hr_api_hooks ah,
3900: hr_api_modules am
3901: where ahc.api_hook_id = ah.api_hook_id
3902: and ah.api_module_id = am.api_module_id
3903: and ahc.call_package = (select dyn_trigger_package_name

Line 3938: hr_api_hooks ah,

3934:
3935: cursor csr_dyt_pkg_hook is
3936: select count(*)
3937: from hr_api_hook_calls ahc,
3938: hr_api_hooks ah,
3939: hr_api_modules am
3940: where ahc.api_hook_id = ah.api_hook_id
3941: and ah.api_module_id = am.api_module_id
3942: and ahc.call_package = (select dyn_trigger_package_name