APPS.CN_PERIODS_API dependencies on CN_SRP_PER_QUOTA_RC

Line 812: -- populate cn_srp_per_quota_rc_pkg

808: ,x_end_period_id => srp.period_id
809: ,x_start_date => l_start_date
810: ,x_end_date => l_end_date );
811:
812: -- populate cn_srp_per_quota_rc_pkg
813: /* cn_srp_per_quota_rc_pkg.insert_record
814: (
815: x_srp_plan_assign_id => c.srp_plan_assign_id
816: ,x_quota_id => null

Line 813: /* cn_srp_per_quota_rc_pkg.insert_record

809: ,x_start_date => l_start_date
810: ,x_end_date => l_end_date );
811:
812: -- populate cn_srp_per_quota_rc_pkg
813: /* cn_srp_per_quota_rc_pkg.insert_record
814: (
815: x_srp_plan_assign_id => c.srp_plan_assign_id
816: ,x_quota_id => null
817: ,x_revenue_class_id => null

Line 821: INSERT INTO cn_srp_per_quota_rc

817: ,x_revenue_class_id => null
818: ,x_start_date => l_start_date
819: ,x_end_date => l_end_date );*/
820: -- denormalizing API call
821: INSERT INTO cn_srp_per_quota_rc
822: ( srp_per_quota_rc_id
823: ,srp_period_quota_id
824: ,srp_plan_assign_id
825: ,salesrep_id

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