DBA Data[Home] [Help]

APPS.HR_APPRAISALS_UTIL_SS dependencies on FF_FORMULAS_F

Line 92: l_formula_name ff_formulas_f.formula_name%TYPE := '&formula_name';

88:
89: l_effective_date DATE := trunc(sysdate);
90: e_wrong_parameters EXCEPTION;
91: l_line_formula_id NUMBER;
92: l_formula_name ff_formulas_f.formula_name%TYPE := '&formula_name';
93: l_inputs ff_exec.inputs_t;
94: l_outputs ff_exec.outputs_t;
95: l_line_score NUMBER;
96:

Line 111: FROM ff_formulas_f ff

107: --
108: CURSOR csr_get_line_ff
109: IS
110: SELECT ff.formula_id, ff.formula_name
111: FROM ff_formulas_f ff
112: WHERE l_effective_date BETWEEN
113: ff.effective_start_date AND ff.effective_end_date
114: AND ff.formula_id = p_line_formula_id;
115:

Line 238: l_formula_name ff_formulas_f.formula_name%TYPE := '&formula_name';

234:
235: l_effective_date DATE := trunc(sysdate);
236: e_wrong_parameters EXCEPTION;
237: l_final_formula_id NUMBER;
238: l_formula_name ff_formulas_f.formula_name%TYPE := '&formula_name';
239: l_inputs ff_exec.inputs_t;
240: l_outputs ff_exec.outputs_t;
241: l_line_score NUMBER;
242:

Line 257: FROM ff_formulas_f ff

253: --
254: CURSOR csr_get_line_ff
255: IS
256: SELECT ff.formula_id, ff.formula_name
257: FROM ff_formulas_f ff
258: WHERE l_effective_date BETWEEN
259: ff.effective_start_date AND ff.effective_end_date
260: AND ff.formula_id = p_final_formula_id;
261: