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_PERIODS_API dependencies on CN_QUOTAS

Line 349: FROM cn_quotas

345: ORDER BY period_id;
346:
347: CURSOR affected_quotas IS
348: SELECT quota_id
349: FROM cn_quotas
350: WHERE (end_date IS NULL OR end_date >= l_start_date)
351: AND start_date <= l_end_date;
352:
353: BEGIN

Line 625: from cn_quota_assigns qa, cn_quotas q

621: AND nvl(end_date,l_null_date) >= l_start_date;
622:
623: CURSOR get_credit_types(l_comp_plan_id IN NUMBER) IS
624: select distinct q.credit_type_id
625: from cn_quota_assigns qa, cn_quotas q
626: where qa.comp_plan_id = l_comp_plan_id
627: and qa.quota_id = q.quota_id;
628:
629: CURSOR get_pd_info(l_period_id IN NUMBER) IS

Line 853: ,cn_quotas q

849: ,0 -- ptd
850: ,0 -- qtd
851: FROM cn_srp_period_quotas pq -- periods that rep/plan uses quota
852: ,cn_quota_rules qr
853: ,cn_quotas q
854: WHERE pq.srp_plan_assign_id = c.srp_plan_assign_id
855: AND pq.quota_id = qr.quota_id
856: AND qr.quota_id = q.quota_id
857: AND q.quota_type_code IN ('EXTERNAL','FORMULA')