APPS.CN_PERIODS_API dependencies on CN_SRP_PER_QUOTA_RC_S

Line 839: cn_srp_per_quota_rc_s.nextval

835: ,year_to_date
836: ,period_to_date
837: ,quarter_to_date)
838: SELECT
839: cn_srp_per_quota_rc_s.nextval
840: ,pq.srp_period_quota_id
841: ,pq.srp_plan_assign_id
842: ,pq.salesrep_id
843: ,l_org_id

Line 860: FROM cn_srp_per_quota_rc spqr

856: AND qr.quota_id = q.quota_id
857: AND q.quota_type_code IN ('EXTERNAL','FORMULA')
858: AND l_period_status in ('O','F')
859: AND NOT EXISTS (SELECT 'srp_period_quota_rc already exists'
860: FROM cn_srp_per_quota_rc spqr
861: WHERE spqr.srp_period_quota_id = pq.srp_period_quota_id
862: AND spqr.srp_plan_assign_id = pq.srp_plan_assign_id
863: AND spqr.revenue_class_id = qr.revenue_class_id)
864: ;