APPS.CN_RT_QUOTA_ASGNS_PKG dependencies on CN_CALC_FORMULAS

Line 374: FROM cn_calc_formulas

370: FROM cn_formula_inputs
371: WHERE calc_formula_id = l_parent_id
372: UNION
373: SELECT output_exp_id
374: FROM cn_calc_formulas
375: WHERE calc_formula_id = l_parent_id);
376:
377: TYPE stack_type IS TABLE OF cn_calc_formulas.calc_formula_id%TYPE;
378:

Line 377: TYPE stack_type IS TABLE OF cn_calc_formulas.calc_formula_id%TYPE;

373: SELECT output_exp_id
374: FROM cn_calc_formulas
375: WHERE calc_formula_id = l_parent_id);
376:
377: TYPE stack_type IS TABLE OF cn_calc_formulas.calc_formula_id%TYPE;
378:
379: l_stack stack_type;
380: l_parent_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
381: l_child_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;

Line 380: l_parent_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;

376:
377: TYPE stack_type IS TABLE OF cn_calc_formulas.calc_formula_id%TYPE;
378:
379: l_stack stack_type;
380: l_parent_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
381: l_child_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
382:
383: CURSOR rt_quota_asgn_curs (
384: l_calc_formula_id NUMBER,

Line 381: l_child_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;

377: TYPE stack_type IS TABLE OF cn_calc_formulas.calc_formula_id%TYPE;
378:
379: l_stack stack_type;
380: l_parent_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
381: l_child_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
382:
383: CURSOR rt_quota_asgn_curs (
384: l_calc_formula_id NUMBER,
385: l_quota_id NUMBER