APPS.OKL_STREAM_BILLING_PVT dependencies on DUAL

Line 642: FROM dual;

638: l_request_id,
639: l_program_application_id,
640: l_program_id,
641: l_program_update_date
642: FROM dual;
643: EXCEPTION
644: WHEN OTHERS THEN
645: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
646: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'(Exception): When resolving request_id'||SQLERRM );

Line 1191: FROM dual;

1187:
1188: --cklee: start 3/16/07
1189: cursor c_seq is
1190: SELECT OKL_TXD_AR_LN_DTLS_B_S.NEXTVAL
1191: FROM dual;
1192: l_seq number;
1193: --cklee: start 3/16/07
1194:
1195: ------------------------------------------------------------

Line 1715: FROM dual;

1711: l_request_id,
1712: l_program_application_id,
1713: l_program_id,
1714: l_program_update_date
1715: FROM dual;
1716: EXCEPTION
1717: WHEN OTHERS THEN
1718: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1719: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'(Exception): When resolving request_id'||SQLERRM );

Line 3797: FROM dual;

3793: l_request_id NUMBER := -1;
3794: CURSOR req_id_csr IS
3795: SELECT
3796: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID)
3797: FROM dual;
3798: --Bug 7584183-Addition end
3799:
3800: BEGIN
3801: