APPS.CN_PERIODS_API dependencies on CN_SRP_PER_QUOTA_RC_S

Line 835: cn_srp_per_quota_rc_s.nextval

831: ,year_to_date
832: ,period_to_date
833: ,quarter_to_date)
834: SELECT
835: cn_srp_per_quota_rc_s.nextval
836: ,pq.srp_period_quota_id
837: ,pq.srp_plan_assign_id
838: ,pq.salesrep_id
839: ,l_org_id

Line 856: FROM cn_srp_per_quota_rc spqr

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