[Home] [Help]
63: select hjp1.parameter_value iv_mode,
64: hjp2.parameter_name iv_name,
65: hjp2.parameter_value iv_id_to,
66: hjp3.parameter_value iv_id_from
67: from hr_jp_parameters hjp1,
68: hr_jp_parameters hjp2,
69: hr_jp_parameters hjp3
70: where hjp1.owner = p_parameter_name
71: and hjp2.owner = hjp1.parameter_value
64: hjp2.parameter_name iv_name,
65: hjp2.parameter_value iv_id_to,
66: hjp3.parameter_value iv_id_from
67: from hr_jp_parameters hjp1,
68: hr_jp_parameters hjp2,
69: hr_jp_parameters hjp3
70: where hjp1.owner = p_parameter_name
71: and hjp2.owner = hjp1.parameter_value
72: and hjp2.parameter_name = hjp1.parameter_name
65: hjp2.parameter_value iv_id_to,
66: hjp3.parameter_value iv_id_from
67: from hr_jp_parameters hjp1,
68: hr_jp_parameters hjp2,
69: hr_jp_parameters hjp3
70: where hjp1.owner = p_parameter_name
71: and hjp2.owner = hjp1.parameter_value
72: and hjp2.parameter_name = hjp1.parameter_name
73: and hjp3.owner(+) = 'IV_COPY_FROM'
80: if p_mode = 'ELE_RR_COPY_TO' then
81: -- find ELE_RR_COPY_FROM element_type_id
82: l_element_type_id_to := p_parameter_value;
83: --
84: l_element_type_id_from := hr_jp_parameters_pkg.get_parameter_value('ELE_RR_COPY_FROM',p_parameter_name);
85:
86: if l_element_type_id_from is not null then
87: -- copy run result
88: