APPS.CN_SRP_PER_QUOTA_RC_PKG dependencies on CN_PERIOD_STATUSES

Line 13: -- Modified the cn_periods to cn_period_statuses

9: -- the quota type was changed from/to revenue
10: --04-AUG-95 P Cook Added insert of mandatory QUARTER_TO_DATE column
11: --
12: --08-SEP-99 S Kumar Modified this package with the date effectivity
13: -- Modified the cn_periods to cn_period_statuses
14: -- Added start date, end_date parameters.
15: -- Procedure Name
16: --
17: -- Purpose

Line 63: AND EXISTS ( select 1 from cn_period_statuses p

59: ELSE
60: -- Delete the specific periods
61: DELETE FROM cn_srp_per_quota_rc_all
62: WHERE srp_plan_assign_id = x_srp_plan_assign_id
63: AND EXISTS ( select 1 from cn_period_statuses p
64: WHERE p.start_date >= Nvl(x_start_date,p.start_date)
65: AND p.end_date <= Nvl(x_end_date ,p.end_date)
66: AND cn_srp_per_quota_rc_all.org_id = p.org_id
67: AND cn_srp_per_quota_rc_all.period_id = p.period_id);

Line 90: -- Modified from cn_periods to cn_period_statuses

86: -- quotas in preparation for insert of the new period quota range
87: -- OR the quota type was changed to one that does not support
88: -- revenue classes
89:
90: -- Modified from cn_periods to cn_period_statuses
91: -- Modified the the start_period_id, end_period_id to
92: -- start date and end date
93: DELETE FROM cn_srp_per_quota_rc_all
94: WHERE quota_id = x_quota_id

Line 95: AND EXISTS ( select 1 from cn_period_statuses p

91: -- Modified the the start_period_id, end_period_id to
92: -- start date and end date
93: DELETE FROM cn_srp_per_quota_rc_all
94: WHERE quota_id = x_quota_id
95: AND EXISTS ( select 1 from cn_period_statuses p
96: WHERE p.start_date >= Nvl(x_start_date,p.start_date)
97: AND p.end_date <= Nvl(x_end_date ,p.end_date)
98: AND cn_srp_per_quota_rc_all.period_id = p.period_id
99: AND cn_srp_per_quota_rc_all.org_id = p.org_id);

Line 266: AND exists (select 'x' from cn_period_statuses_all p

262: AND qr.quota_id = x_quota_id
263: AND q.quota_id = qr.quota_id
264: AND q.quota_type_code IN ('EXTERNAL','FORMULA')
265:
266: AND exists (select 'x' from cn_period_statuses_all p
267: where pq.period_id = p.period_id
268: AND pq.org_id = p.org_id
269: AND p.period_status in ('O','F')
270: AND p.start_date >= nvl(x_start_date, p.start_date)

Line 345: -- modified the cn_periods to cn_period_statuses

341:
342: -- New plan assignment or change in plan assigns date range
343: -- only consider difference of the range
344:
345: -- modified the cn_periods to cn_period_statuses
346: -- modified the start_period_id, end_period_id to
347: -- start date end date
348:
349: INSERT INTO cn_srp_per_quota_rc

Line 393: AND exists (select 'x' from cn_period_statuses_all p

389: AND pq.quota_id = qr.quota_id
390: AND qr.quota_id = q.quota_id
391: AND q.quota_type_code IN ('EXTERNAL','FORMULA')
392:
393: AND exists (select 'x' from cn_period_statuses_all p
394: where pq.period_id = p.period_id
395: AND pq.org_id = p.org_id
396: AND p.period_status in ('O','F')
397: AND p.start_date >= nvl(x_start_date, p.start_date)