APPS.OKL_STREAM_BILLING_PVT dependencies on DUAL

Line 583: FROM dual;

579: l_request_id,
580: l_program_application_id,
581: l_program_id,
582: l_program_update_date
583: FROM dual;
584: EXCEPTION
585: WHEN OTHERS THEN
586: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
587: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'(Exception): When resolving request_id'||SQLERRM );

Line 1129: FROM dual;

1125:
1126: --cklee: start 3/16/07
1127: cursor c_seq is
1128: SELECT OKL_TXD_AR_LN_DTLS_B_S.NEXTVAL
1129: FROM dual;
1130: l_seq number;
1131: --cklee: start 3/16/07
1132:
1133: ------------------------------------------------------------

Line 1644: FROM dual;

1640: l_request_id,
1641: l_program_application_id,
1642: l_program_id,
1643: l_program_update_date
1644: FROM dual;
1645: EXCEPTION
1646: WHEN OTHERS THEN
1647: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1648: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'(Exception): When resolving request_id'||SQLERRM );

Line 3607: FROM dual;

3603: l_request_id NUMBER := -1;
3604: CURSOR req_id_csr IS
3605: SELECT
3606: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID)
3607: FROM dual;
3608: --Bug 7584183-Addition end
3609:
3610: BEGIN
3611: