DBA Data[Home] [Help]

APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on DUAL

Line 4813: FROM dual;

4809: l_adjustment_number VARCHAR2(20);
4810:
4811: CURSOR c_adjustment_id IS
4812: SELECT ar_revenue_adjustments_s1.NEXTVAL
4813: FROM dual;
4814:
4815: CURSOR c_adjustment_number IS
4816: SELECT ar_revenue_adjustments_s2.NEXTVAL
4817: FROM dual;

Line 4817: FROM dual;

4813: FROM dual;
4814:
4815: CURSOR c_adjustment_number IS
4816: SELECT ar_revenue_adjustments_s2.NEXTVAL
4817: FROM dual;
4818:
4819: BEGIN
4820: IF PG_DEBUG in ('Y', 'C') THEN
4821: arp_util.debug('AR_Revenue_Adjustment_PVT.create_adjustment()+');

Line 5208: FROM dual;

5204: IF g_update_db_flag = 'Y'
5205: THEN
5206: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL
5207: INTO l_dist_id
5208: FROM dual;
5209:
5210: INSERT INTO ra_cust_trx_line_gl_dist
5211: (cust_trx_line_gl_dist_id
5212: ,customer_trx_line_id

Line 5337: FROM dual;

5333: IS
5334:
5335: CURSOR get_salesrep_line_id IS
5336: SELECT ra_cust_trx_line_salesreps_s.NEXTVAL
5337: FROM dual;
5338:
5339: CURSOR get_gldist_line_id IS
5340: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL
5341: FROM dual;

Line 5341: FROM dual;

5337: FROM dual;
5338:
5339: CURSOR get_gldist_line_id IS
5340: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL
5341: FROM dual;
5342:
5343: l_user_id NUMBER;
5344: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;
5345: l_gl_dist_id ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE;