2771: l_parent_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
2772: l_child_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
2773: parent_quota_id NUMBER;
2774: child_quota_id NUMBER;
2775: nt cn_calc_sql_exps_pvt.num_tbl_type;
2776: new_ss VARCHAR2 (4000);
2777: l_calc_sql_exp VARCHAR2 (4000);
2778: l_parent_start_date DATE;
2779: l_parent_end_date DATE;
2782: rs VARCHAR2 (50);
2783: mc NUMBER;
2784: md VARCHAR2 (50);
2785: BEGIN
2786: cn_calc_sql_exps_pvt.get_dependent_plan_elts (p_api_version => 1.0,
2787: p_node_type => 'F',
2788: p_node_id => x_calc_formula_id,
2789: x_plan_elt_id_tbl => nt,
2790: x_return_status => rs,