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 340: , hr_api_modules ahm

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

Line 508: from hr_api_modules am

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