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_SRP_PLAN_ASSIGNS_ALL

Line 168: FROM cn_srp_plan_assigns_all csqa

164: FROM dual
165: WHERE EXISTS
166: (
167: SELECT 1
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

Line 186: FROM cn_srp_plan_assigns_all cspa

182: AND
183: EXISTS
184: (
185: SELECT 1
186: FROM cn_srp_plan_assigns_all cspa
187: WHERE cspa.srp_plan_assign_id = p_srp_plan_assign_id
188: AND EXISTS
189: (
190: SELECT 1

Line 397: ,cn_srp_plan_assigns_all pa

393: ,l_user_id
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