APPS.CN_PERIODS_API dependencies on CN_SRP_PER_QUOTA_RC

Line 816: -- populate cn_srp_per_quota_rc_pkg

812: ,x_end_period_id => srp.period_id
813: ,x_start_date => l_start_date
814: ,x_end_date => l_end_date );
815:
816: -- populate cn_srp_per_quota_rc_pkg
817: /* cn_srp_per_quota_rc_pkg.insert_record
818: (
819: x_srp_plan_assign_id => c.srp_plan_assign_id
820: ,x_quota_id => null

Line 817: /* cn_srp_per_quota_rc_pkg.insert_record

813: ,x_start_date => l_start_date
814: ,x_end_date => l_end_date );
815:
816: -- populate cn_srp_per_quota_rc_pkg
817: /* cn_srp_per_quota_rc_pkg.insert_record
818: (
819: x_srp_plan_assign_id => c.srp_plan_assign_id
820: ,x_quota_id => null
821: ,x_revenue_class_id => null

Line 825: INSERT INTO cn_srp_per_quota_rc

821: ,x_revenue_class_id => null
822: ,x_start_date => l_start_date
823: ,x_end_date => l_end_date );*/
824: -- denormalizing API call
825: INSERT INTO cn_srp_per_quota_rc
826: ( srp_per_quota_rc_id
827: ,srp_period_quota_id
828: ,srp_plan_assign_id
829: ,salesrep_id

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