APPS.OKL_AM_UTIL_PVT dependencies on OKL_FORMULAE_V

Line 521: FROM okl_formulae_v f,

517: CURSOR l_operand_csr
518: (cp_formula_name VARCHAR2
519: ,cp_operand_name VARCHAR2) IS
520: SELECT o.description
521: FROM okl_formulae_v f,
522: okl_fmla_oprnds_v fo,
523: okl_operands_v o
524: WHERE f.name = cp_formula_name
525: AND f.start_date <= SYSDATE

Line 1382: (cp_formula_name IN okl_formulae_v.name%TYPE) IS

1378: RETURN VARCHAR2 IS
1379:
1380: -- Extract evaluation string for a formula
1381: CURSOR l_formula_csr
1382: (cp_formula_name IN okl_formulae_v.name%TYPE) IS
1383: SELECT f.formula_string
1384: FROM okl_formulae_v f
1385: WHERE f.name = cp_formula_name
1386: AND f.start_date <= SYSDATE

Line 1384: FROM okl_formulae_v f

1380: -- Extract evaluation string for a formula
1381: CURSOR l_formula_csr
1382: (cp_formula_name IN okl_formulae_v.name%TYPE) IS
1383: SELECT f.formula_string
1384: FROM okl_formulae_v f
1385: WHERE f.name = cp_formula_name
1386: AND f.start_date <= SYSDATE
1387: AND NVL (f.end_date, sysdate) >= SYSDATE;
1388:

Line 1389: l_formula_string okl_formulae_v.formula_string%TYPE := NULL;

1385: WHERE f.name = cp_formula_name
1386: AND f.start_date <= SYSDATE
1387: AND NVL (f.end_date, sysdate) >= SYSDATE;
1388:
1389: l_formula_string okl_formulae_v.formula_string%TYPE := NULL;
1390:
1391: BEGIN
1392:
1393: OPEN l_formula_csr (p_formula_name);