APPS.OKL_AM_TERMNT_INTERFACE_PVT dependencies on DUAL

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

1788: lp_qpyv_tbl := p_qpyv_tbl;
1789: batch_offset := p_batch_offset;
1790: qdt_counter := 0;
1791: /* sysdate for date processed */
1792: SELECT trunc(SYSDATE) INTO l_sys_date FROM DUAL;
1793: /* calls the create_termination_quote API and retrives the quote_id */
1794: OKL_AM_CREATE_QUOTE_PUB.create_terminate_quote(p_api_version => p_api_version
1795: ,p_init_msg_list => OKC_API.G_FALSE
1796: ,x_msg_data => x_msg_data

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

3061: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3062: RAISE OKC_API.G_EXCEPTION_ERROR;
3063: END IF;
3064: -- this retrives the sysdate and passes to a local variable
3065: SELECT trunc(SYSDATE) INTO l_sys_date FROM DUAL;
3066: record_number:=0;
3067:
3068: -- loops through the records to populate the plsql table
3069: FOR termnt_rec IN get_termnt_intface_dtls_csr(p_status=>'ENTERED')