DBA Data[Home] [Help]

APPS.OKL_AM_CALCULATE_QUOTE_PVT dependencies on OKL_OPERANDS_V

Line 4331: l_operand_name okl_operands_v.name%TYPE;

4327: l_curr_char VARCHAR2(1);
4328: l_formula_id okl_formulae_v.id%TYPE := NULL;
4329: l_formula_string okl_formulae_v.formula_string%TYPE := NULL;
4330: l_temp_string okl_formulae_v.formula_string%TYPE := NULL;
4331: l_operand_name okl_operands_v.name%TYPE;
4332: l_dummy_value NUMBER;
4333:
4334: -- Extract evaluation string for a formula
4335: CURSOR l_formula_csr

Line 4350: okl_operands_v o

4346: cp_operand_label IN okl_fmla_oprnds_v.label%TYPE) IS
4347: SELECT o.name
4348: FROM okl_formulae_v f,
4349: okl_fmla_oprnds_v l,
4350: okl_operands_v o
4351: WHERE f.id = cp_formula_id
4352: AND l.fma_id = f.id
4353: AND l.label = cp_operand_label
4354: AND o.id = l.opd_id;

Line 4594: l_operand_name okl_operands_v.name%TYPE;

4590: l_curr_char VARCHAR2(1);
4591: l_formula_id okl_formulae_v.id%TYPE := NULL;
4592: l_formula_string okl_formulae_v.formula_string%TYPE := NULL;
4593: l_temp_string okl_formulae_v.formula_string%TYPE := NULL;
4594: l_operand_name okl_operands_v.name%TYPE;
4595: l_dummy_value NUMBER;
4596:
4597: -- Extract evaluation string for a formula
4598: CURSOR l_formula_csr

Line 4613: okl_operands_v o

4609: cp_operand_label IN okl_fmla_oprnds_v.label%TYPE) IS
4610: SELECT o.name
4611: FROM okl_formulae_v f,
4612: okl_fmla_oprnds_v l,
4613: okl_operands_v o
4614: WHERE f.id = cp_formula_id
4615: AND l.fma_id = f.id
4616: AND l.label = cp_operand_label
4617: AND o.id = l.opd_id;