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