APPS.OKL_LEASE_APP_PVT dependencies on DUAL

Line 540: l_seq_stmt := 'SELECT ' || p_seq_name || '.NEXTVAL FROM DUAL';

536: TYPE l_csr_typ IS REF CURSOR;
537: l_ref_csr l_csr_typ;
538: BEGIN
539: l_next_val := 0;
540: l_seq_stmt := 'SELECT ' || p_seq_name || '.NEXTVAL FROM DUAL';
541: l_query_stmt := 'SELECT ' ||
542: p_col_name ||
543: ' FROM ' ||
544: p_table_name ||

Line 594: l_seq_stmt := 'SELECT ' || p_seq_name || '.NEXTVAL FROM DUAL';

590: l_prefix VARCHAR2(30);
591: l_value VARCHAR(250);
592: BEGIN
593: l_next_val := 0;
594: l_seq_stmt := 'SELECT ' || p_seq_name || '.NEXTVAL FROM DUAL';
595: l_query_stmt := 'SELECT ' ||
596: p_col_name ||
597: ' FROM ' ||
598: p_table_name ||

Line 2140: FROM dual;

2136:
2137: -- Selects the nextval from sequence, used later for defining event key
2138: CURSOR okl_key_csr IS
2139: SELECT okl_wf_item_s.nextval
2140: FROM dual;
2141:
2142: BEGIN
2143: SAVEPOINT raise_event;
2144:

Line 10719: FROM DUAL;

10715: l_meaning VARCHAR2(80);
10716: BEGIN
10717: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10718: SELECT OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE INTO l_func_curr_code
10719: FROM DUAL;
10720:
10721: IF(p_curr_code IS NULL
10722: OR p_curr_code = OKL_API.G_MISS_CHAR)
10723: THEN