APPS.OKL_LEASE_APP_PVT dependencies on DUAL

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

578: TYPE l_csr_typ IS REF CURSOR;
579: l_ref_csr l_csr_typ;
580: BEGIN
581: l_next_val := 0;
582: l_seq_stmt := 'SELECT ' || p_seq_name || '.NEXTVAL FROM DUAL';
583: l_query_stmt := 'SELECT ' ||
584: p_col_name ||
585: ' FROM ' ||
586: p_table_name ||

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

632: l_prefix VARCHAR2(30);
633: l_value VARCHAR(250);
634: BEGIN
635: l_next_val := 0;
636: l_seq_stmt := 'SELECT ' || p_seq_name || '.NEXTVAL FROM DUAL';
637: l_query_stmt := 'SELECT ' ||
638: p_col_name ||
639: ' FROM ' ||
640: p_table_name ||

Line 2182: FROM dual;

2178:
2179: -- Selects the nextval from sequence, used later for defining event key
2180: CURSOR okl_key_csr IS
2181: SELECT okl_wf_item_s.nextval
2182: FROM dual;
2183:
2184: BEGIN
2185: SAVEPOINT raise_event;
2186:

Line 10871: FROM DUAL;

10867: l_meaning VARCHAR2(80);
10868: BEGIN
10869: l_return_status := OKL_API.G_RET_STS_SUCCESS;
10870: SELECT OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE INTO l_func_curr_code
10871: FROM DUAL;
10872:
10873: IF(p_curr_code IS NULL
10874: OR p_curr_code = OKL_API.G_MISS_CHAR)
10875: THEN