APPS.CN_PLAN_ELEMENT_PUB dependencies on CN_QUOTAS_V

Line 310: FROM cn_quotas_v

306: -- Get quota_id if this plan element already exist
307: BEGIN
308: SELECT quota_id
309: INTO l_pe_rec.quota_id
310: FROM cn_quotas_v
311: WHERE NAME = l_pe_rec.NAME
312: and org_id = l_pe_rec.ORG_ID;
313:
314: x_loading_status := 'PLN_QUOTA_EXISTS';

Line 614: FROM cn_quotas_v

610: description,
611: quota_type_code,
612: calc_formula_id,
613: target
614: FROM cn_quotas_v
615: WHERE NAME = p_pe_rec.NAME;
616:
617: l_pe_csr c_pe_csr%ROWTYPE;
618: l_api_name CONSTANT VARCHAR2 (30) := 'chk_pe_consistent';

Line 1536: FROM cn_quotas_v q

1532: pe_name cn_quotas.NAME%TYPE
1533: )
1534: IS
1535: SELECT q.quota_id
1536: FROM cn_quotas_v q
1537: WHERE q.NAME = pe_name;
1538: BEGIN
1539: -- Initialize API return status to success
1540: x_return_status := fnd_api.g_ret_sts_success;

Line 1831: FROM cn_quotas_v q

1827: -- clku, 5/9/2002
1828: q.quota_type_code,
1829: q.start_date,
1830: q.end_date
1831: FROM cn_quotas_v q
1832: WHERE q.NAME = pe_name;
1833: BEGIN
1834: -- Initialize API return status to success
1835: x_return_status := fnd_api.g_ret_sts_success;

Line 2818: FROM cn_quotas_v cq,

2814: l_quota_id NUMBER
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