APPS.CN_UPGRADE_PE_FORMULA_PKG dependencies on CN_QUOTAS_ALL

Line 13: FROM cn_quotas_all

9: IS
10: CURSOR l_quota_csr
11: IS
12: SELECT *
13: FROM cn_quotas_all
14: WHERE quota_id = p_quota_id;
15:
16: l_quota cn_quotas_all%ROWTYPE;
17: l_formula_name VARCHAR2 (30) := '';

Line 16: l_quota cn_quotas_all%ROWTYPE;

12: SELECT *
13: FROM cn_quotas_all
14: WHERE quota_id = p_quota_id;
15:
16: l_quota cn_quotas_all%ROWTYPE;
17: l_formula_name VARCHAR2 (30) := '';
18: BEGIN
19: OPEN l_quota_csr;
20:

Line 316: cn_quotas_all q

312: CURSOR l_formula_csr
313: IS
314: SELECT f.calc_formula_id
315: FROM cn_calc_formulas_all f,
316: cn_quotas_all q
317: WHERE f.NAME = l_formula_name
318: AND q.quota_id = p_quota_id
319: AND ((q.org_id = f.org_id) OR (q.org_id IS NULL AND f.org_id IS NULL));
320: BEGIN

Line 420: FROM cn_quotas_all

416:
417: CURSOR l_quota_csr
418: IS
419: SELECT *
420: FROM cn_quotas_all
421: WHERE quota_id = p_quota_id;
422:
423: l_quota cn_quotas_all%ROWTYPE;
424:

Line 423: l_quota cn_quotas_all%ROWTYPE;

419: SELECT *
420: FROM cn_quotas_all
421: WHERE quota_id = p_quota_id;
422:
423: l_quota cn_quotas_all%ROWTYPE;
424:
425: CURSOR l_discount_option_csr(p_org_id number)
426: IS
427: SELECT calc_formula_id

Line 717: FROM cn_quotas_all

713: )
714: IS
715: CURSOR l_quota_csr IS
716: SELECT *
717: FROM cn_quotas_all
718: WHERE quota_id = p_quota_id;
719:
720: l_quota cn_quotas_all%ROWTYPE;
721: BEGIN

Line 720: l_quota cn_quotas_all%ROWTYPE;

716: SELECT *
717: FROM cn_quotas_all
718: WHERE quota_id = p_quota_id;
719:
720: l_quota cn_quotas_all%ROWTYPE;
721: BEGIN
722: x_return_status := 'S';
723:
724: OPEN l_quota_csr;