DBA Data[Home] [Help]

APPS.PAY_JP_FORMULA_FUNCTION_PKG dependencies on HR_JP_PARAMETERS

Line 212: SELECT parameter_value FROM hr_jp_parameters

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;

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