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_QUOTA_ASSIGNS_PKG dependencies on CN_QUOTA_ASSIGNS_ALL

Line 172: SELECT 1 FROM cn_quota_assigns_all cqa

168: FROM cn_srp_plan_assigns_all csqa
169: WHERE csqa.srp_plan_assign_id = p_srp_plan_assign_id
170: AND EXISTS
171: (
172: SELECT 1 FROM cn_quota_assigns_all cqa
173: WHERE cqa.comp_plan_id = csqa.comp_plan_id
174: AND EXISTS
175: (
176: SELECT 1 FROM cn_quotas_all cq

Line 398: ,cn_quota_assigns_all qa

394: ,l_login_id
395: ,q.org_id
396: FROM cn_quotas_all q
397: ,cn_srp_plan_assigns_all pa
398: ,cn_quota_assigns_all qa
399: WHERE pa.srp_plan_assign_id = x_srp_plan_assign_id
400: AND pa.comp_plan_id = qa.comp_plan_id
401: AND q.quota_id = qa.quota_id
402: ;