DBA Data[Home] [Help]

APPS.HR_API_WF_EVENTS dependencies on HR_API_MODULES

Line 85: from hr_api_modules amd

81: , ahk.legislation_package
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'

Line 342: , hr_api_modules ahm

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'
346: and ahk.api_hook_type='AP';

Line 510: from hr_api_modules am

506: procedure add_events_for_api(p_api_package varchar2
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'