APPS.OKL_CONTRACT_PVT dependencies on OKL_TXL_ASSETS_V

Line 898: FROM OKL_TXL_ASSETS_V

894: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
895: SELECT 'Y'
896: FROM DUAL
897: WHERE EXISTS (SELECT '1'
898: FROM OKL_TXL_ASSETS_V
899: WHERE asset_number = p_asset_number);
900:
901: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
902: --start modified abhsaxen for performance SQLID 20562304

Line 952: From OKL_TXL_ASSETS_V txlv,

948: --Cursor to check asset number on txl
949: CURSOR l_txlv_csr (p_finasst_id IN NUMBER, P_Asstno IN VARCHAR2) is
950: Select txlv.id,
951: txlv.asset_number
952: From OKL_TXL_ASSETS_V txlv,
953: OKC_K_LINES_B cle,
954: OKC_LINE_STYLES_B lse
955: Where txlv.kle_id = cle.id
956: And cle.lse_id = lse.id

Line 961: l_txl_id OKL_TXL_ASSETS_V.ID%TYPE;

957: And lse.lty_code = 'FIXED_ASSET'
958: And cle.cle_id = p_finasst_id
959: And txlv.asset_number = p_asstNo;
960:
961: l_txl_id OKL_TXL_ASSETS_V.ID%TYPE;
962: l_txl_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE;
963:
964: --Cursor to check asset number on txd
965: CURSOR l_txdv_csr (p_finasst_id IN NUMBER, p_asstno IN VARCHAR2) is

Line 962: l_txl_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE;

958: And cle.cle_id = p_finasst_id
959: And txlv.asset_number = p_asstNo;
960:
961: l_txl_id OKL_TXL_ASSETS_V.ID%TYPE;
962: l_txl_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE;
963:
964: --Cursor to check asset number on txd
965: CURSOR l_txdv_csr (p_finasst_id IN NUMBER, p_asstno IN VARCHAR2) is
966: Select txdv.id,

Line 969: OKL_TXL_ASSETS_V txlv,

965: CURSOR l_txdv_csr (p_finasst_id IN NUMBER, p_asstno IN VARCHAR2) is
966: Select txdv.id,
967: txdv.asset_number
968: From OKL_TXD_ASSETS_V txdv,
969: OKL_TXL_ASSETS_V txlv,
970: OKC_K_LINES_B cle,
971: OKC_LINE_STYLES_B lse
972: Where txdv.tal_id = txlv.id
973: And txlv.kle_id = cle.id