APPS.CN_PERIODS_API dependencies on CN_PERIOD_SETS

Line 971: FROM cn_period_sets

967: WHERE period_type = x_period_type
968: AND org_id = x_org_id;
969: CURSOR c2 IS
970: SELECT period_set_id
971: FROM cn_period_sets
972: WHERE period_set_name = x_period_set_name
973: AND org_id = x_org_id;
974:
975: l_period_set_id NUMBER;

Line 1018: -- get the period_set_id from cn_period_sets.

1014: x_org_id);
1015: END IF;
1016: CLOSE c1;
1017:
1018: -- get the period_set_id from cn_period_sets.
1019: -- if there is no matching record, create one
1020: OPEN c2;
1021: FETCH c2 INTO x_period_set_id;
1022:

Line 1024: SELECT cn_period_sets_s.NEXTVAL

1020: OPEN c2;
1021: FETCH c2 INTO x_period_set_id;
1022:
1023: IF (c2%NOTFOUND) THEN
1024: SELECT cn_period_sets_s.NEXTVAL
1025: INTO x_period_set_id
1026: FROM dual;
1027: INSERT INTO cn_period_sets
1028: (period_set_id,

Line 1027: INSERT INTO cn_period_sets

1023: IF (c2%NOTFOUND) THEN
1024: SELECT cn_period_sets_s.NEXTVAL
1025: INTO x_period_set_id
1026: FROM dual;
1027: INSERT INTO cn_period_sets
1028: (period_set_id,
1029: period_set_name,
1030: org_id)
1031: VALUES