DBA Data[Home] [Help]

APPS.HR_API_USER_HOOKS_UTILITY dependencies on HR_LOOKUPS

Line 247: from hr_lookups hlk

243: cursor csr_modules is
244: select amd.api_module_id
245: , hlk.meaning
246: , amd.module_name
247: from hr_lookups hlk
248: , hr_api_modules amd
249: where hlk.lookup_type = 'API_MODULE_TYPE'
250: and hlk.lookup_code = amd.api_module_type
251: and amd.api_module_type in ('BP', 'RH')

Line 260: from hr_lookups hlk

256: cursor csr_hooks (p_module_id number) is
257: select hlk.meaning
258: , ahk.hook_package
259: , ahk.hook_procedure
260: from hr_lookups hlk
261: , hr_api_hooks ahk
262: where hlk.lookup_type = 'API_HOOK_TYPE'
263: and hlk.lookup_code = ahk.api_hook_type
264: and ahk.api_module_id = p_module_id

Line 538: from hr_lookups hlk

534: cursor csr_hooks (p_api_module_id number
535: ,p_hook_package varchar2) is
536: select hlk.meaning
537: , ahk.api_hook_id
538: from hr_lookups hlk
539: , hr_api_hooks ahk
540: where hlk.lookup_type = 'API_HOOK_TYPE'
541: and hlk.lookup_code = ahk.api_hook_type
542: and ahk.api_module_id = p_api_module_id

Line 698: from hr_lookups hlk

694: cursor csr_modules is
695: select amd.api_module_id
696: , hlk.meaning
697: , amd.module_name
698: from hr_lookups hlk
699: , hr_api_modules amd
700: where hlk.lookup_type = 'API_MODULE_TYPE'
701: and hlk.lookup_code = amd.api_module_type
702: and amd.api_module_type in ('BP', 'RH')

Line 765: from hr_lookups hlk

761: --
762: cursor cur_module is
763: select amd.module_name
764: , hlk.meaning
765: from hr_lookups hlk
766: , hr_api_modules amd
767: where amd.api_module_id = p_api_module_id
768: and hlk.lookup_type = 'API_MODULE_TYPE'
769: and hlk.lookup_code = amd.api_module_type