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 339: from hr_api_hooks ahk

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

Line 388: from hr_api_hooks ahk

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

Line 509: , hr_api_hooks ah

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