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