APPS.OKL_MAINTAIN_CONTRACT_PVT dependencies on OKL_FAN_SEQ

Line 59: select 'CANCEL_'||TO_CHAR(OKL_FAN_SEQ.NEXTVAL)

55: WHERE id = p_fin_ast_id;
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