526: ,l_user_id
527: ,l_login_id
528: ,qa.org_id
529: FROM cn_srp_quota_assigns_all qa
530: ,cn_period_quotas_all pq
531: ,cn_srp_plan_assigns_all pa
532: ,cn_period_statuses p
533: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id
534: AND pa.srp_plan_assign_id = x_srp_plan_assign_id
638: ,l_user_id
639: ,l_login_id
640: ,qa.org_id
641: FROM cn_srp_quota_assigns_all qa
642: ,cn_period_quotas_all pq
643: ,cn_srp_plan_assigns_all pa
644: ,cn_period_statuses p
645: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id
646: AND pa.srp_plan_assign_id = qa.srp_plan_assign_id