APPS.CN_PERIODS_API dependencies on CN_SRP_INTEL_PERIODS

Line 695: -- Populate cn_srp_intel_periods

691: l_curr_srp_id := srp.salesrep_id;
692: l_curr_pd_id := srp.period_id;
693:
694: IF l_period_status IN ('O', 'F') THEN
695: -- Populate cn_srp_intel_periods
696: l_err_srp_id := srp.salesrep_id;
697:
698: SELECT COUNT(1) INTO l_count
699: FROM cn_srp_intel_periods

Line 699: FROM cn_srp_intel_periods

695: -- Populate cn_srp_intel_periods
696: l_err_srp_id := srp.salesrep_id;
697:
698: SELECT COUNT(1) INTO l_count
699: FROM cn_srp_intel_periods
700: WHERE period_id = srp.period_id
701: AND salesrep_id = srp.salesrep_id
702: AND org_id = srp.org_id;
703:

Line 705: INSERT INTO cn_srp_intel_periods

701: AND salesrep_id = srp.salesrep_id
702: AND org_id = srp.org_id;
703:
704: IF l_count = 0 THEN
705: INSERT INTO cn_srp_intel_periods
706: (srp_intel_period_id,
707: salesrep_id,
708: org_id,
709: period_id,

Line 720: (cn_srp_intel_periods_s.NEXTVAL,

716: last_update_login,
717: start_date,
718: end_date
719: ) VALUES
720: (cn_srp_intel_periods_s.NEXTVAL,
721: srp.salesrep_id,
722: l_org_id,
723: srp.period_id,
724: 'CLEAN',