eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 93: -- Modified from cn_periods to cn_period_statuses

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

Line 98: AND EXISTS ( select 1 from cn_period_statuses p

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

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

268: AND qr.quota_id = x_quota_id
269: AND q.quota_id = qr.quota_id
270: AND q.quota_type_code IN ('EXTERNAL','FORMULA')
271:
272: AND exists (select 'x' from cn_period_statuses_all p
273: where pq.period_id = p.period_id
274: AND pq.org_id = p.org_id
275: AND p.period_status in ('O','F')
276: AND p.start_date >= nvl(x_start_date, p.start_date)

Line 351: -- modified the cn_periods to cn_period_statuses

347:
348: -- New plan assignment or change in plan assigns date range
349: -- only consider difference of the range
350:
351: -- modified the cn_periods to cn_period_statuses
352: -- modified the start_period_id, end_period_id to
353: -- start date end date
354:
355: INSERT INTO cn_srp_per_quota_rc

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

395: AND pq.quota_id = qr.quota_id
396: AND qr.quota_id = q.quota_id
397: AND q.quota_type_code IN ('EXTERNAL','FORMULA')
398:
399: AND exists (select 'x' from cn_period_statuses_all p
400: where pq.period_id = p.period_id
401: AND pq.org_id = p.org_id
402: AND p.period_status in ('O','F')
403: AND p.start_date >= nvl(x_start_date, p.start_date)