APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_QUOTAS_V

Line 58: FROM cn_quotas_v pe

54: pe.indirect_credit,
55: pe.quota_status,
56: pe.salesreps_enddated_flag,
57: NULL
58: FROM cn_quotas_v pe
59: WHERE pe.quota_id = p_quota_id;
60:
61: l_plan_element plan_element_rec_type;
62: BEGIN

Line 111: FROM cn_quotas_v

107: SELECT 1
108: INTO l_dummy
109: FROM DUAL
110: WHERE EXISTS (SELECT 1
111: FROM cn_quotas_v
112: WHERE quota_id = p_quota_id AND org_id = p_org_id);
113: EXCEPTION
114: WHEN NO_DATA_FOUND
115: THEN

Line 1635: FROM cn_quotas_v pe

1631: pe.indirect_credit,
1632: pe.quota_status,
1633: pe.salesreps_enddated_flag,
1634: NULL
1635: FROM cn_quotas_v pe
1636: WHERE pe.quota_id = qid;
1637:
1638: CURSOR get_number_dim (
1639: l_quota_id NUMBER

Line 1643: FROM cn_quotas_v cq,

1639: l_quota_id NUMBER
1640: )
1641: IS
1642: SELECT ccf.number_dim
1643: FROM cn_quotas_v cq,
1644: cn_calc_formulas ccf
1645: WHERE cq.quota_id = l_quota_id AND cq.calc_formula_id = ccf.calc_formula_id;
1646:
1647: CURSOR c_srp_period_quota_csr (

Line 2074: FROM cn_quotas_v

2070:
2071: -- API body
2072: SELECT NAME
2073: INTO l_quota_name
2074: FROM cn_quotas_v
2075: WHERE quota_id = p_plan_element.quota_id;
2076:
2077: -- Call the Delete Record Table Handler
2078: cn_quotas_pkg.DELETE_RECORD (x_quota_id => p_plan_element.quota_id, x_name => l_quota_name);

Line 2206: FROM cn_quotas_v

2202: IF (p_action = 'DELETE')
2203: THEN
2204: SELECT COUNT (*)
2205: INTO l_temp_count
2206: FROM cn_quotas_v
2207: WHERE quota_id = p_plan_element.quota_id;
2208:
2209: IF l_temp_count = 0
2210: THEN