APPS.PAYWSDYG_PKG dependencies on HR_API_HOOKS

Line 2645: from hr_api_hooks h,

2641: is
2642: SELECT /*+ ORDERED */ a.pls_type
2643: FROM (select /*+ NO_MERGE */
2644: DISTINCT hook_package
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,

Line 2663: -- from hr_api_hooks h, hr_api_modules m

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
2665: -- and m.module_name = cp_tab_name)
2666: -- AND A.LEVEL# = 0
2667: -- AND A.argument = cp_param_name

Line 2778: from hr_api_hooks h, hr_api_modules m

2774: select hook_package pkg, hook_procedure proc
2775: ,decode(hook_procedure, 'AFTER_INSERT', 'PI',
2776: 'AFTER_UPDATE', 'PU',
2777: 'AFTER_DELETE', 'PD') usage_type
2778: from hr_api_hooks h, hr_api_modules m
2779: where m.api_module_id = h.api_module_id
2780: and m.module_name = cp_tab_name;
2781: --
2782:

Line 3861: hr_api_hooks ah,

3857: set enabled_flag = l_hooks
3858: where api_hook_call_id in (
3859: select api_hook_call_id
3860: from hr_api_hook_calls ahc,
3861: hr_api_hooks ah,
3862: hr_api_modules am
3863: where ahc.api_hook_id = ah.api_hook_id
3864: and ah.api_module_id = am.api_module_id
3865: and ahc.call_package = (select dyn_trigger_package_name

Line 3900: hr_api_hooks ah,

3896:
3897: cursor csr_dyt_pkg_hook is
3898: select count(*)
3899: from hr_api_hook_calls ahc,
3900: hr_api_hooks ah,
3901: hr_api_modules am
3902: where ahc.api_hook_id = ah.api_hook_id
3903: and ah.api_module_id = am.api_module_id
3904: and ahc.call_package = (select dyn_trigger_package_name