DBA Data[Home] [Help]

APPS.HR_JP_DATA_MIGRATION_PKG dependencies on HR_JP_PARAMETERS

Line 82: from hr_jp_parameters hjp1,

78: select hjp1.parameter_value iv_mode,
79: hjp2.parameter_name iv_name,
80: hjp2.parameter_value iv_id_to,
81: hjp3.parameter_value iv_id_from
82: from hr_jp_parameters hjp1,
83: hr_jp_parameters hjp2,
84: hr_jp_parameters hjp3
85: where hjp1.owner = p_parameter_name
86: and hjp2.owner = hjp1.parameter_value

Line 83: hr_jp_parameters hjp2,

79: hjp2.parameter_name iv_name,
80: hjp2.parameter_value iv_id_to,
81: hjp3.parameter_value iv_id_from
82: from hr_jp_parameters hjp1,
83: hr_jp_parameters hjp2,
84: hr_jp_parameters hjp3
85: where hjp1.owner = p_parameter_name
86: and hjp2.owner = hjp1.parameter_value
87: and hjp2.parameter_name = hjp1.parameter_name

Line 84: hr_jp_parameters hjp3

80: hjp2.parameter_value iv_id_to,
81: hjp3.parameter_value iv_id_from
82: from hr_jp_parameters hjp1,
83: hr_jp_parameters hjp2,
84: hr_jp_parameters hjp3
85: where hjp1.owner = p_parameter_name
86: and hjp2.owner = hjp1.parameter_value
87: and hjp2.parameter_name = hjp1.parameter_name
88: and hjp3.owner(+) = 'IV_COPY_FROM'

Line 99: l_element_type_id_from := hr_jp_parameters_pkg.get_parameter_value('ELE_RR_COPY_FROM',p_parameter_name);

95: if p_mode = 'ELE_RR_COPY_TO' then
96: -- find ELE_RR_COPY_FROM element_type_id
97: l_element_type_id_to := p_parameter_value;
98: --
99: l_element_type_id_from := hr_jp_parameters_pkg.get_parameter_value('ELE_RR_COPY_FROM',p_parameter_name);
100:
101: if l_element_type_id_from is not null then
102: -- copy run result
103: