APPS.ARP_DET_DIST_PKG dependencies on DUAL

Line 403: FROM DUAL;

399: x_msg_data IN OUT NOCOPY VARCHAR2)
400: IS
401: CURSOR c_gt IS
402: SELECT ar_distribution_split_s.NEXTVAL
403: FROM DUAL;
404: no_sequence EXCEPTION;
405: BEGIN
406: IF PG_DEBUG = 'Y' THEN
407: localdebug('arp_det_dist_pkg.get_gt_sequence()+');

Line 7811: FROM DUAL CONNECT BY ROWNUM < 13 ) b

7807: 9,'UNEDLINE',
7808: 10,'UNEDFREIGHT',
7809: 11,'UNEDTAX',
7810: 12,'UNEDCHARGES',NULL) act
7811: FROM DUAL CONNECT BY ROWNUM < 13 ) b
7812: WHERE REF_CUSTOMER_TRX_ID = p_customer_trx_id
7813: AND gt_id = p_gt_id
7814: AND REF_CUST_TRX_LINE_GL_DIST_ID IS NOT NULL
7815: AND gp_level = 'D'

Line 7990: FROM DUAL CONNECT BY ROWNUM < 13 ) b

7986: 9,'UNEDLINE',
7987: 10,'UNEDFREIGHT',
7988: 11,'UNEDTAX',
7989: 12,'UNEDCHARGES',NULL) act
7990: FROM DUAL CONNECT BY ROWNUM < 13 ) b
7991: WHERE REF_CUSTOMER_TRX_ID = p_customer_trx_id
7992: AND gt_id = p_gt_id
7993: AND REF_CUST_TRX_LINE_GL_DIST_ID IS NOT NULL
7994: AND gp_level = 'D'

Line 15248: FROM DUAL;

15244: RETURN NUMBER
15245: IS
15246: CURSOR c IS
15247: SELECT ar_cash_basis_distributions_s.NEXTVAL
15248: FROM DUAL;
15249: l_num NUMBER;
15250: BEGIN
15251: OPEN c;
15252: FETCH c INTO l_num;