APPS.ARP_DET_DIST_PKG dependencies on DUAL

Line 405: FROM DUAL;

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

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

9155: 9,'UNEDLINE',
9156: 10,'UNEDFREIGHT',
9157: 11,'UNEDTAX',
9158: 12,'UNEDCHARGES',NULL) act
9159: FROM DUAL CONNECT BY ROWNUM < 13 ) b
9160: WHERE REF_CUSTOMER_TRX_ID = p_customer_trx_id
9161: AND gt_id = p_gt_id
9162: AND REF_CUST_TRX_LINE_GL_DIST_ID IS NOT NULL
9163: AND gp_level = 'D'

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

9340: 9,'UNEDLINE',
9341: 10,'UNEDFREIGHT',
9342: 11,'UNEDTAX',
9343: 12,'UNEDCHARGES',NULL) act
9344: FROM DUAL CONNECT BY ROWNUM < 13 ) b
9345: WHERE REF_CUSTOMER_TRX_ID = p_customer_trx_id
9346: AND gt_id = p_gt_id
9347: AND REF_CUST_TRX_LINE_GL_DIST_ID IS NOT NULL
9348: AND gp_level = 'D'

Line 16960: FROM DUAL;

16956: RETURN NUMBER
16957: IS
16958: CURSOR c IS
16959: SELECT ar_cash_basis_distributions_s.NEXTVAL
16960: FROM DUAL;
16961: l_num NUMBER;
16962: BEGIN
16963: OPEN c;
16964: FETCH c INTO l_num;