APPS.OKL_AM_TERMNT_INTERFACE_PVT dependencies on DUAL

Line 1982: SELECT trunc(SYSDATE) INTO l_sys_date FROM DUAL;

1978: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_AM_TERMNT_INTERFACE_PVT.create_quote.',
1979: 'p_record_number '||p_record_number);
1980: END IF;
1981: /* sysdate for date processed */
1982: SELECT trunc(SYSDATE) INTO l_sys_date FROM DUAL;
1983:
1984: --sechawla 7383445 : begin
1985: -- if any record which is part of this quote has auto_accept_yn='N'
1986: -- dont accept the quote

Line 4623: SELECT trunc(SYSDATE) INTO l_sys_date FROM DUAL;

4619: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4620: RAISE OKC_API.G_EXCEPTION_ERROR;
4621: END IF;
4622: -- this retrives the sysdate and passes to a local variable
4623: SELECT trunc(SYSDATE) INTO l_sys_date FROM DUAL;
4624: record_number:=0;
4625:
4626: -- loops through the records to populate the plsql table
4627: FOR termnt_rec IN get_termnt_intface_dtls_csr(p_status=>'ENTERED')