APPS.CN_OVER_ASSIGN_PVT dependencies on CN_SRP_QUOTA_CATES

Line 13: ( quota_category_id cn_srp_quota_cates.quota_category_id%TYPE,

9: G_CREATED_BY NUMBER := fnd_global.user_id;
10: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
11:
12: TYPE quota_amount_rec_type IS RECORD
13: ( quota_category_id cn_srp_quota_cates.quota_category_id%TYPE,
14: quota_amount cn_srp_quota_cates.amount%TYPE,
15: planning_amt cn_srp_quota_cates.planning_amt%TYPE,
16: prorated_amount cn_srp_quota_cates.prorated_amount%TYPE);
17:

Line 14: quota_amount cn_srp_quota_cates.amount%TYPE,

10: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
11:
12: TYPE quota_amount_rec_type IS RECORD
13: ( quota_category_id cn_srp_quota_cates.quota_category_id%TYPE,
14: quota_amount cn_srp_quota_cates.amount%TYPE,
15: planning_amt cn_srp_quota_cates.planning_amt%TYPE,
16: prorated_amount cn_srp_quota_cates.prorated_amount%TYPE);
17:
18: TYPE quota_amount_tbl_type IS TABLE OF quota_amount_rec_type

Line 15: planning_amt cn_srp_quota_cates.planning_amt%TYPE,

11:
12: TYPE quota_amount_rec_type IS RECORD
13: ( quota_category_id cn_srp_quota_cates.quota_category_id%TYPE,
14: quota_amount cn_srp_quota_cates.amount%TYPE,
15: planning_amt cn_srp_quota_cates.planning_amt%TYPE,
16: prorated_amount cn_srp_quota_cates.prorated_amount%TYPE);
17:
18: TYPE quota_amount_tbl_type IS TABLE OF quota_amount_rec_type
19: INDEX BY BINARY_INTEGER;

Line 16: prorated_amount cn_srp_quota_cates.prorated_amount%TYPE);

12: TYPE quota_amount_rec_type IS RECORD
13: ( quota_category_id cn_srp_quota_cates.quota_category_id%TYPE,
14: quota_amount cn_srp_quota_cates.amount%TYPE,
15: planning_amt cn_srp_quota_cates.planning_amt%TYPE,
16: prorated_amount cn_srp_quota_cates.prorated_amount%TYPE);
17:
18: TYPE quota_amount_tbl_type IS TABLE OF quota_amount_rec_type
19: INDEX BY BINARY_INTEGER;
20:

Line 42: FROM cn_srp_quota_cates

38: CURSOR c_quota_amount
39: (c_srp_role_id NUMBER,
40: c_quota_category_id NUMBER) IS
41: SELECT Nvl(amount,0) amount,Nvl(planning_amt,0) planning_amt,Nvl(prorated_amount,0) prorated_amount
42: FROM cn_srp_quota_cates
43: WHERE srp_role_id = c_srp_role_id
44: AND quota_category_id = c_quota_category_id;
45:
46: l_sr_start_date DATE;

Line 48: l_quota_amount cn_srp_quota_cates.amount%TYPE;

44: AND quota_category_id = c_quota_category_id;
45:
46: l_sr_start_date DATE;
47: l_sr_end_date DATE;
48: l_quota_amount cn_srp_quota_cates.amount%TYPE;
49: l_planning_amt cn_srp_quota_cates.planning_amt%TYPE;
50: l_prorated_amount cn_srp_quota_cates.prorated_amount%TYPE;
51: BEGIN
52:

Line 49: l_planning_amt cn_srp_quota_cates.planning_amt%TYPE;

45:
46: l_sr_start_date DATE;
47: l_sr_end_date DATE;
48: l_quota_amount cn_srp_quota_cates.amount%TYPE;
49: l_planning_amt cn_srp_quota_cates.planning_amt%TYPE;
50: l_prorated_amount cn_srp_quota_cates.prorated_amount%TYPE;
51: BEGIN
52:
53: -- Get plan assign start/end period

Line 50: l_prorated_amount cn_srp_quota_cates.prorated_amount%TYPE;

46: l_sr_start_date DATE;
47: l_sr_end_date DATE;
48: l_quota_amount cn_srp_quota_cates.amount%TYPE;
49: l_planning_amt cn_srp_quota_cates.planning_amt%TYPE;
50: l_prorated_amount cn_srp_quota_cates.prorated_amount%TYPE;
51: BEGIN
52:
53: -- Get plan assign start/end period
54: OPEN srp_role_info;

Line 333: FROM cn_srp_quota_cates sqc,cn_quota_categories qc

329: SELECT sqc.quota_category_id,
330: SUM(Nvl(sqc.amount,0) * c_prorate_rate) amount,
331: SUM(Nvl(sqc.planning_amt,0) * c_prorate_rate) planning_amt,
332: SUM(Nvl(sqc.prorated_amount,0) * c_prorate_rate) prorated_amount
333: FROM cn_srp_quota_cates sqc,cn_quota_categories qc
334: WHERE sqc.quota_category_id = qc.quota_category_id
335: AND qc.TYPE = 'VAR_QUOTA'
336: AND sqc.srp_role_id = c_srp_role_id
337: GROUP BY sqc.quota_category_id