APPS.CN_PERIODS_API dependencies on CN_SRP_INTEL_PERIODS

Line 691: -- Populate cn_srp_intel_periods

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

Line 695: FROM cn_srp_intel_periods

691: -- Populate cn_srp_intel_periods
692: l_err_srp_id := srp.salesrep_id;
693:
694: SELECT COUNT(1) INTO l_count
695: FROM cn_srp_intel_periods
696: WHERE period_id = srp.period_id
697: AND salesrep_id = srp.salesrep_id
698: AND org_id = srp.org_id;
699:

Line 701: INSERT INTO cn_srp_intel_periods

697: AND salesrep_id = srp.salesrep_id
698: AND org_id = srp.org_id;
699:
700: IF l_count = 0 THEN
701: INSERT INTO cn_srp_intel_periods
702: (srp_intel_period_id,
703: salesrep_id,
704: org_id,
705: period_id,

Line 716: (cn_srp_intel_periods_s.NEXTVAL,

712: last_update_login,
713: start_date,
714: end_date
715: ) VALUES
716: (cn_srp_intel_periods_s.NEXTVAL,
717: srp.salesrep_id,
718: l_org_id,
719: srp.period_id,
720: 'CLEAN',