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: