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_ALL

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 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)