APPS.CN_PERIOD_QUOTAS_PKG dependencies on CN_PERIOD_QUOTAS_S

Line 23: SELECT cn_period_quotas_s.NEXTVAL

19: x_period_quota_id IN OUT NOCOPY NUMBER
20: )
21: IS
22: BEGIN
23: SELECT cn_period_quotas_s.NEXTVAL
24: INTO x_period_quota_id
25: FROM DUAL;
26: END get_uid;
27:

Line 176: SELECT --cn_period_quotas_s.nextval,

172: )
173: IS
174: CURSOR l_period_quotas_cr
175: IS
176: SELECT --cn_period_quotas_s.nextval,
177: p_period_id c1,
178: p_quota_id c2,
179: p_period_target c3,
180: 0 c4,

Line 209: SELECT cn_period_quotas_s.NEXTVAL

205: IF p_quota_id IS NOT NULL
206: THEN
207: FOR l_period_quota IN l_period_quotas_cr
208: LOOP
209: SELECT cn_period_quotas_s.NEXTVAL
210: INTO l_pqs
211: FROM DUAL;
212:
213: INSERT INTO cn_period_quotas

Line 332: SELECT cn_period_quotas_s.NEXTVAL

328: IF (x_quota_id IS NOT NULL AND l_insert_flag = 'Y') THEN
329:
330: FOR l_period_quota IN l_period_quotas_cr
331: LOOP
332: SELECT cn_period_quotas_s.NEXTVAL
333: INTO l_pqs
334: FROM DUAL;
335:
336: INSERT INTO cn_period_quotas