APPS.CN_PERIOD_QUOTAS_PKG dependencies on DUAL

Line 25: FROM DUAL;

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:
28: --| ---------------------------------------------------------------------+
29: --| Function Name : previous_period

Line 211: FROM DUAL;

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
214: (period_quota_id,
215: period_id,

Line 247: FROM DUAL;

243: l_period_quota.c12,
244: l_period_quota.c13,
245: l_period_quota.c14,
246: l_period_quota.org_id
247: FROM DUAL;
248:
249: -- clku, call populate_itd_values to populate itd value
250: -- of the newly inserted records
251: populate_itd_values (l_pqs, l_period_quota.c2);

Line 334: FROM DUAL;

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
337: (period_quota_id,
338: period_id,

Line 369: FROM DUAL;

365: l_period_quota.c12,
366: l_period_quota.c13,
367: l_period_quota.c14,
368: l_period_quota.org_id
369: FROM DUAL;
370:
371: -- clku, call populate_itd_values to populate itd value
372: -- of the newly inserted records
373: -- populate_itd_values (l_pqs, l_period_quota.c2);