APPS.CN_SRP_PERIODS_PKG dependencies on CN_SRP_PERIODS_ALL

Line 44: FROM cn_srp_periods_all srp

40: BEGIN
41: -- Find closest previous record
42: SELECT MAX(end_date)
43: INTO l_max_end_date
44: FROM cn_srp_periods_all srp
45: WHERE salesrep_id = p_salesrep_id
46: AND org_id = p_org_id
47: AND role_id = p_role_id
48: AND quota_id = p_quota_id

Line 54: FROM cn_srp_periods_all

50: AND end_date < p_start_date;
51: -- Get all data from previous record
52: SELECT *
53: INTO x_srp_prd_row
54: FROM cn_srp_periods_all
55: WHERE salesrep_id = p_salesrep_id
56: AND org_id = p_org_id
57: AND role_id = p_role_id
58: AND quota_id = p_quota_id

Line 253: INSERT INTO cn_srp_periods_all

249: SELECT cn_srp_periods_s.NEXTVAL
250: INTO X_SRP_PERIOD_ID
251: FROM dual;
252:
253: INSERT INTO cn_srp_periods_all
254: (SRP_PERIOD_ID ,
255: SALESREP_ID ,
256: org_id,
257: PERIOD_ID ,

Line 558: SELECT 1 INTO l_dummy FROM CN_SRP_PERIODS_all

554: x_last_updated_by ,
555: x_last_update_login
556: );
557:
558: SELECT 1 INTO l_dummy FROM CN_SRP_PERIODS_all
559: WHERE SRP_PERIOD_ID = x_srp_period_id;
560:
561: END Insert_Row;
562:

Line 573: DELETE FROM cn_srp_periods_all

569: PROCEDURE Delete_row( x_srp_period_id NUMBER ) IS
570:
571: BEGIN
572:
573: DELETE FROM cn_srp_periods_all
574: WHERE srp_period_id = x_srp_period_id ;
575: IF (SQL%NOTFOUND) THEN
576: RAISE NO_DATA_FOUND;
577: END IF;