DBA Data[Home] [Help]

APPS.PAY_JP_FORMULA_FUNCTION_PKG dependencies on HR_JP_PARAMETERS

Line 216: SELECT parameter_value FROM hr_jp_parameters

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;

Line 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;