APPS.HR_API_MODULE_INTERNAL dependencies on HR_API_MODULES

Line 28: l_api_module_id hr_api_modules.api_module_id%TYPE;

24: l_effective_date date;
25: --
26: -- Out variables
27: --
28: l_api_module_id hr_api_modules.api_module_id%TYPE;
29: --
30: l_proc varchar2(72) := g_package||'create_module';
31: --
32: -- Declare a cursor that will check whether the passed

Line 36: select api_module_id from hr_api_modules ham

32: -- Declare a cursor that will check whether the passed
33: -- in module type and module name form a unique combination
34: --
35: cursor csr_valid_combo is
36: select api_module_id from hr_api_modules ham
37: where ham.module_name = p_module_name
38: and ham.api_module_type = p_api_module_type;
39: --
40: begin