APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on DUAL

Line 4588: FROM dual;

4584: l_adjustment_number VARCHAR2(20);
4585:
4586: CURSOR c_adjustment_id IS
4587: SELECT ar_revenue_adjustments_s1.NEXTVAL
4588: FROM dual;
4589:
4590: CURSOR c_adjustment_number IS
4591: SELECT ar_revenue_adjustments_s2.NEXTVAL
4592: FROM dual;

Line 4592: FROM dual;

4588: FROM dual;
4589:
4590: CURSOR c_adjustment_number IS
4591: SELECT ar_revenue_adjustments_s2.NEXTVAL
4592: FROM dual;
4593:
4594: BEGIN
4595: IF PG_DEBUG in ('Y', 'C') THEN
4596: arp_util.debug('AR_Revenue_Adjustment_PVT.create_adjustment()+');

Line 4986: FROM dual;

4982: IF g_update_db_flag = 'Y'
4983: THEN
4984: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL
4985: INTO l_dist_id
4986: FROM dual;
4987:
4988: INSERT INTO ra_cust_trx_line_gl_dist
4989: (cust_trx_line_gl_dist_id
4990: ,customer_trx_line_id

Line 5116: FROM dual;

5112: IS
5113:
5114: CURSOR get_salesrep_line_id IS
5115: SELECT ra_cust_trx_line_salesreps_s.NEXTVAL
5116: FROM dual;
5117:
5118: CURSOR get_gldist_line_id IS
5119: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL
5120: FROM dual;

Line 5120: FROM dual;

5116: FROM dual;
5117:
5118: CURSOR get_gldist_line_id IS
5119: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL
5120: FROM dual;
5121:
5122: l_user_id NUMBER;
5123: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;
5124: l_gl_dist_id ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE;