APPS.OKL_AM_CONSOLIDATED_QTE_PVT dependencies on DUAL

Line 251: SELECT sysdate INTO l_sys_date FROM DUAL;

247: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.currency_conversion_date: ' || p_qtev_rec.currency_conversion_date);
248: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_qtev_rec.id: ' || p_qtev_rec.id);
249: END IF;
250: -- Get the sysdate
251: SELECT sysdate INTO l_sys_date FROM DUAL;
252:
253: -- Set the date_effective_from to date effective from of first quote
254: x_qtev_rec.date_effective_from := p_qtev_rec.date_effective_from;
255:

Line 957: SELECT SYSDATE INTO l_sys_date FROM DUAL;

953: -- If quotes passed
954: IF (p_qtev_tbl.COUNT > 0) THEN
955:
956: -- RMUNJULU 23-DEC-02 2726739 Added select to get sysdate
957: SELECT SYSDATE INTO l_sys_date FROM DUAL;
958:
959:
960: -- Validate the quotes that are passed
961: validate_quotes (

Line 1652: SELECT SYSDATE INTO l_sys_date FROM DUAL;

1648: END LOOP;
1649:
1650: END IF;
1651:
1652: SELECT SYSDATE INTO l_sys_date FROM DUAL;
1653:
1654: -- Set the consolidated quote before updating
1655: -- Set the qst_code to ACCEPTED and date_accepted, if the quote is accepted
1656: IF (lp_cons_rec.accepted_yn = G_YES) THEN