APPS.CN_INTEL_CALC_PKG dependencies on CN_SRP_INTEL_PERIODS_S

Line 50: SELECT cn_srp_intel_periods_s.NEXTVAL

46: ) IS
47: l_srp_intel_period_id NUMBER(15);
48: l_rowid ROWID;
49: CURSOR u_id IS
50: SELECT cn_srp_intel_periods_s.NEXTVAL
51: FROM dual;
52: CURSOR c IS SELECT ROWID FROM cn_srp_intel_periods
53: WHERE srp_intel_period_id = l_srp_intel_period_id;
54: CURSOR rec IS

Line 325: UPDATE cn_srp_intel_periods SET

321: x_last_update_date IN DATE,
322: x_last_updated_by IN NUMBER,
323: x_last_update_login IN NUMBER) IS
324: BEGIN
325: UPDATE cn_srp_intel_periods SET
326: salesrep_id = x_salesrep_id,
327: period_id = x_period_id,
328: start_date = x_start_date,
329: end_date = x_end_date,