APPS.CN_PLAN_ELEMENT_PUB dependencies on CN_CALC_FORMULAS

Line 327: FROM cn_calc_formulas

323: IF p_plan_element_rec.calc_formula_name IS NOT NULL
324: THEN
325: SELECT calc_formula_id
326: INTO l_pe_rec.calc_formula_id
327: FROM cn_calc_formulas
328: WHERE NAME = l_pe_rec.calc_formula_name
329: and org_id = l_pe_rec.ORG_ID;
330: END IF;
331: EXCEPTION

Line 2819: cn_calc_formulas ccf

2815: )
2816: IS
2817: SELECT ccf.number_dim
2818: FROM cn_quotas_v cq,
2819: cn_calc_formulas ccf
2820: WHERE cq.quota_id = l_quota_id AND cq.calc_formula_id = ccf.calc_formula_id;
2821: BEGIN
2822: -- Standard Start of API savepoint
2823: SAVEPOINT update_plan_element;

Line 3124: FROM cn_calc_formulas

3120: ELSIF l_pe_rec.calc_formula_id <> l_pe_rec_old.calc_formula_id
3121: THEN
3122: SELECT number_dim
3123: INTO l_number_dim_old
3124: FROM cn_calc_formulas
3125: WHERE calc_formula_id = l_pe_rec_old.calc_formula_id;
3126:
3127: SELECT number_dim
3128: INTO l_number_dim_new

Line 3129: FROM cn_calc_formulas

3125: WHERE calc_formula_id = l_pe_rec_old.calc_formula_id;
3126:
3127: SELECT number_dim
3128: INTO l_number_dim_new
3129: FROM cn_calc_formulas
3130: WHERE calc_formula_id = l_pe_rec.calc_formula_id;
3131:
3132: IF l_number_dim_new <> l_number_dim_old
3133: THEN

Line 4184: cn_calc_formulas cf,

4180: q.indirect_credit,
4181: q.salesreps_enddated_flag
4182: FROM cn_quotas q,
4183: cn_credit_types ct,
4184: cn_calc_formulas cf,
4185: cn_interval_types cit
4186: WHERE q.NAME = pe_name
4187: AND q.org_id = p_org_id
4188: --AND q.credit_type_id = ct.credit_type_id(+)