APPS.HR_API_WF_EVENTS dependencies on HR_API_HOOKS

Line 86: , hr_api_hooks ahk

82: , ahk.legislation_function
83: , amd.module_name
84: , amd.data_within_business_group
85: from hr_api_modules amd
86: , hr_api_hooks ahk
87: where amd.api_module_id = ahk.api_module_id
88: and ahk.hook_package = p_hook_package
89: and amd.api_module_type='BP'
90: and ahk.api_hook_type='AP';

Line 341: from hr_api_hooks ahk

337: cursor csr_api_hook is
338: select ahm.api_module_id
339: , ahk.api_hook_id
340: , ahk.hook_procedure
341: from hr_api_hooks ahk
342: , hr_api_modules ahm
343: where ahk.hook_package = p_hook_package
344: and ahk.api_module_id = ahm.api_module_id
345: and ahm.api_module_type='BP'

Line 390: from hr_api_hooks ahk

386: procedure register_business_event(p_hook_package varchar2) is
387: --
388: cursor csr_api_hook is
389: select ahk.hook_procedure
390: from hr_api_hooks ahk
391: where ahk.hook_package = p_hook_package
392: and ahk.api_hook_type='AP';
393: --
394: cursor event_exists(p_event_name varchar2) is

Line 511: , hr_api_hooks ah

507: ,p_regenerate boolean) is
508: cursor get_hooks is
509: select distinct ah.hook_package
510: from hr_api_modules am
511: , hr_api_hooks ah
512: where am.api_module_id=ah.api_module_id
513: and am.module_package=p_api_package
514: and am.api_module_type='BP'
515: and ah.api_hook_type='AP';