APPS.OKL_AM_QUOTES_WF dependencies on DUAL

Line 30: FROM DUAL;

26:
27: -- Cursor to get the value of the sequence
28: CURSOR okl_key_csr IS
29: SELECT okl_wf_item_s.nextval
30: FROM DUAL;
31: -- for debug logging
32: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'raise_pre_proceeds_event';
33: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
34: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

Line 102: FROM DUAL;

98:
99: -- Cursor to get the value of the sequence
100: CURSOR okl_key_csr IS
101: SELECT okl_wf_item_s.nextval
102: FROM DUAL;
103:
104: -- for debug logging
105: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'raise_repurchase_quote_event';
106: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

Line 1435: SELECT SYSDATE INTO l_termination_date FROM DUAL;

1431: itemtype => itemtype,
1432: itemkey => itemkey,
1433: aname => 'CONTRACT_NUMBER');
1434:
1435: SELECT SYSDATE INTO l_termination_date FROM DUAL;
1436:
1437: -- Get the org id for the contract
1438: l_org_id := OKL_AM_UTIL_PVT.get_chr_org_id(l_contract_id);
1439: