DBA Data[Home] [Help]

APPS.HR_APPRAISALS_UTIL_SS dependencies on FF_FORMULAS_F

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

98:
99: l_effective_date DATE := trunc(sysdate);
100: e_wrong_parameters EXCEPTION;
101: l_line_formula_id NUMBER;
102: l_formula_name ff_formulas_f.formula_name%TYPE := '&formula_name';
103: l_inputs ff_exec.inputs_t;
104: l_outputs ff_exec.outputs_t;
105: l_line_score NUMBER;
106:

Line 121: FROM ff_formulas_f ff

117: --
118: CURSOR csr_get_line_ff
119: IS
120: SELECT ff.formula_id, ff.formula_name
121: FROM ff_formulas_f ff
122: WHERE l_effective_date BETWEEN
123: ff.effective_start_date AND ff.effective_end_date
124: AND ff.formula_id = p_line_formula_id;
125:

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

246:
247: l_effective_date DATE := trunc(sysdate);
248: e_wrong_parameters EXCEPTION;
249: l_final_formula_id NUMBER;
250: l_formula_name ff_formulas_f.formula_name%TYPE := '&formula_name';
251: l_inputs ff_exec.inputs_t;
252: l_outputs ff_exec.outputs_t;
253: l_line_score NUMBER;
254:

Line 269: FROM ff_formulas_f ff

265: --
266: CURSOR csr_get_line_ff
267: IS
268: SELECT ff.formula_id, ff.formula_name
269: FROM ff_formulas_f ff
270: WHERE l_effective_date BETWEEN
271: ff.effective_start_date AND ff.effective_end_date
272: AND ff.formula_id = p_final_formula_id;
273: