APPS.CN_CALC_FORMULAS_PVT dependencies on CN_QUOTAS_V

Line 658: from cn_quotas_v qut, cn_srp_period_quotas spq

654: FROM dual;
655:
656: CURSOR c_srp_quota_detail IS
657: select spq.srp_period_quota_id
658: from cn_quotas_v qut, cn_srp_period_quotas spq
659: where qut.quota_id = spq.quota_id
660: and qut.calc_formula_id = p_calc_formula_id;
661:
662: CURSOR c1 IS

Line 681: select distinct qa.comp_plan_id from cn_quota_assigns qa, cn_quotas_v q

677: WHERE calc_formula_id = p_calc_formula_id;
678: rec_info c1%ROWTYPE;
679:
680: cursor get_plans is
681: select distinct qa.comp_plan_id from cn_quota_assigns qa, cn_quotas_v q
682: where qa.quota_id = q.quota_id
683: and q.calc_formula_id = p_calc_formula_id;
684:
685: BEGIN

Line 1510: from cn_quotas_v where calc_formula_id = p_calc_formula_id;

1506: RAISE fnd_api.g_exc_error;
1507: END IF;
1508:
1509: select count(1) into l_dummy
1510: from cn_quotas_v where calc_formula_id = p_calc_formula_id;
1511: if l_dummy > 0 THEN
1512: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1513: fnd_message.set_name('CN', 'CN_FORMULA_IN_USE');
1514: fnd_msg_pub.ADD;