APPS.OKL_MAINTAIN_CONTRACT_PVT dependencies on OKX_ASSETS_V

Line 63: CURSOR c_chk_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) 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'
65: FROM DUAL
66: WHERE EXISTS (SELECT '1'
67: FROM OKL_TXL_ASSETS_V

Line 73: FROM OKX_ASSETS_V

69: OR EXISTS (SELECT '1'
70: FROM OKL_TXD_ASSETS_V
71: WHERE asset_number = p_asset_number)
72: OR EXISTS (SELECT '1'
73: FROM OKX_ASSETS_V
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'

Line 76: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is

72: OR EXISTS (SELECT '1'
73: FROM OKX_ASSETS_V
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,