APPS.PAY_CN_ELEMENT_TEMPLATE_PKG dependencies on FF_FORMULAS_F
Line 33: l_formula_id ff_formulas_f.formula_id%TYPE ;
29: ,p_formula_name IN VARCHAR2
30: )
31: RETURN NUMBER
32: IS 33: l_formula_id ff_formulas_f.formula_id%TYPE ; 34: BEGIN
35:
36: SELECT formula_id
37: INTO l_formula_id
Line 38: FROM ff_formulas_f
34: BEGIN
35:
36: SELECT formula_id
37: INTO l_formula_id 38: FROM ff_formulas_f 39: WHERE legislation_code = 'CN'
40: AND formula_name = p_formula_name
41: AND p_effective_date BETWEEN effective_start_Date AND effective_end_date;
42: