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 621: from cn_quota_assigns qa, cn_quotas q

617: AND start_date <= l_start_date AND end_date >= l_end_date;
618:
619: CURSOR get_credit_types(l_comp_plan_id IN NUMBER) IS
620: select distinct q.credit_type_id
621: from cn_quota_assigns qa, cn_quotas q
622: where qa.comp_plan_id = l_comp_plan_id
623: and qa.quota_id = q.quota_id;
624:
625: CURSOR get_pd_info(l_period_id IN NUMBER) IS

Line 849: ,cn_quotas q

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