APPS.OKL_MAINTAIN_CONTRACT_PVT dependencies on DUAL

Line 60: FROM dual;

56:
57: --cursor to get new asset number
58: Cursor c_asset_no IS
59: select 'CANCEL_'||TO_CHAR(OKL_FAN_SEQ.NEXTVAL)
60: FROM dual;
61:
62: --Cursors to find if asset number exists
63: CURSOR c_chk_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
64: SELECT 'Y'

Line 65: FROM DUAL

61:
62: --Cursors to find if asset number exists
63: CURSOR c_chk_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
64: SELECT 'Y'
65: FROM DUAL
66: WHERE EXISTS (SELECT '1'
67: FROM OKL_TXL_ASSETS_V
68: WHERE asset_number = p_asset_number)
69: OR EXISTS (SELECT '1'

Line 78: FROM DUAL

74: WHERE asset_number = p_asset_number);
75:
76: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
77: SELECT 'Y'
78: FROM DUAL
79: WHERE EXISTS (select '1'
80: from okc_k_lines_v kle,
81: okc_line_styles_b lse
82: where kle.name = p_asset_number

Line 747: FROM DUAL;

743: IF (p_new_contract_number IS NULL) THEN
744: -- Get Sequence Number to generate Contract Number
745: SELECT okl_rbk_seq.NEXTVAL
746: INTO l_seq_no
747: FROM DUAL;
748:
749: l_new_contract_number := l_orig_contract_number || '-CANCEL'|| l_seq_no;
750: ELSE
751: l_new_contract_number := p_new_contract_number;