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