212: p_owner IN VARCHAR2,
213: p_parameter_name IN VARCHAR2) RETURN VARCHAR2 IS
214: --
215: CURSOR cel_jp_parameter IS
216: SELECT parameter_value FROM hr_jp_parameters
217: WHERE owner = p_owner
218: AND parameter_name = p_parameter_name;
219: --
220: l_parameter_value hr_jp_parameters.parameter_value%TYPE;
216: SELECT parameter_value FROM hr_jp_parameters
217: WHERE owner = p_owner
218: AND parameter_name = p_parameter_name;
219: --
220: l_parameter_value hr_jp_parameters.parameter_value%TYPE;
221: --
222: BEGIN
223: --
224: OPEN cel_jp_parameter;