APPS.CN_CALC_SUBMISSION_PVT dependencies on CN_QUOTAS

Line 30: (name cn_quotas.name%TYPE,

26: salesrep_id jtf_rs_salesreps.salesrep_id%TYPE,
27: calc_sub_entry_id cn_calc_submission_entries.calc_sub_entry_id%TYPE);
28:
29: TYPE quota_entry_rec_type IS RECORD
30: (name cn_quotas.name%TYPE,
31: quota_id cn_quotas.quota_id%TYPE,
32: calc_sub_quota_id cn_calc_sub_quotas.calc_sub_quota_id%TYPE);
33:
34: TYPE rep_entry_tbl_type IS TABLE OF rep_entry_rec_type INDEX BY BINARY_INTEGER;

Line 31: quota_id cn_quotas.quota_id%TYPE,

27: calc_sub_entry_id cn_calc_submission_entries.calc_sub_entry_id%TYPE);
28:
29: TYPE quota_entry_rec_type IS RECORD
30: (name cn_quotas.name%TYPE,
31: quota_id cn_quotas.quota_id%TYPE,
32: calc_sub_quota_id cn_calc_sub_quotas.calc_sub_quota_id%TYPE);
33:
34: TYPE rep_entry_tbl_type IS TABLE OF rep_entry_rec_type INDEX BY BINARY_INTEGER;
35: TYPE quota_entry_tbl_type IS TABLE OF quota_entry_rec_type INDEX BY BINARY_INTEGER;

Line 132: l_quota_name cn_quotas.name%TYPE;

128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2)
130: IS
131: l_dummy NUMBER;
132: l_quota_name cn_quotas.name%TYPE;
133:
134: CURSOR name_check (p_batch_name cn_calc_submission_batches.name%TYPE ) IS
135: SELECT 1
136: FROM cn_calc_submission_batches_all

Line 152: FROM cn_quotas_all

148: AND trunc(p_start_date) BETWEEN trunc(start_date) AND trunc(end_date);
149:
150: CURSOR quota_check(p_quota_id NUMBER) IS
151: SELECT name
152: FROM cn_quotas_all
153: WHERE quota_id = p_quota_id
154: AND org_id = p_sub_batch_rec.org_id
155: AND incentive_type_code = 'BONUS'
156: AND (interval_type_id = p_sub_batch_rec.interval_type_id OR

Line 751: cn_quotas b

747:
748: CURSOR quotas IS
749: SELECT b.name, a.quota_id, a.calc_sub_quota_id
750: FROM cn_calc_sub_quotas a,
751: cn_quotas b
752: WHERE a.calc_sub_batch_id = p_calc_sub_batch_id
753: AND a.quota_id = b.quota_id;
754:
755: CURSOR interval_types IS