APPS.HR_PUMP_META_MAPPER dependencies on HR_API_MODULES

Line 366: from hr_api_modules ham,

362: select upper(hrpmp.api_parameter_name),
363: upper(hrpmp.mapping_type),
364: upper(hrpmp.mapping_definition),
365: hrpmp.default_value
366: from hr_api_modules ham,
367: hr_pump_module_parameters hrpmp
368: where upper(ham.module_package) = upper(p_module_package)
369: and upper(ham.module_name) = upper(p_module_name)
370: and upper(ham.api_module_type) in ( 'AI', 'BP','DM' )

Line 440: hr_api_modules am

436: p_module_name in varchar2
437: ) is
438: select mp.mapping_package
439: from hr_pump_mapping_packages mp,
440: hr_api_modules am
441: where (mp.module_name is not null and
442: upper(mp.module_name) = upper(p_module_name) and
443: upper(am.module_name) = upper(p_module_name) and
444: upper(am.api_module_type) = upper(mp.api_module_type))

Line 1779: hr_api_modules ham

1775: is
1776: cursor csr_defaulting_style( p_module_name in varchar2 ) is
1777: select decode( count(0), 0, c_default_hr_api, c_default_null )
1778: from hr_pump_default_exceptions hrpde,
1779: hr_api_modules ham
1780: where upper(ham.module_package) = upper(p_module_package)
1781: and upper(ham.module_name) = upper(p_module_name)
1782: and upper(ham.api_module_type) in ('AI', 'BP', 'DM')
1783: and upper(hrpde.module_name) = upper(p_module_name)

Line 3686: from hr_api_modules

3682: --
3683: cursor csr_api_module_id
3684: (p_module_package in varchar2, p_module_name in varchar2) is
3685: select api_module_id
3686: from hr_api_modules
3687: where upper(module_name) = upper(p_module_name)
3688: and upper(module_package) = upper(p_module_package)
3689: and upper(api_module_type) in ('AI', 'BP', 'DM');
3690: begin

Line 4102: from hr_api_modules

4098: g_last_api_id := p_api_id;
4099: --
4100: select module_package,module_name
4101: into l_module_package,l_module_name
4102: from hr_api_modules
4103: where api_module_id = p_api_id;
4104: --
4105: hr_pump_meta_mapper.g_standard_generate := true;
4106: setup_parameter_data(