APPS.OKL_CONTRACT_PVT dependencies on OKL_TXL_ASSETS_V

Line 866: FROM OKL_TXL_ASSETS_V

862: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
863: SELECT 'Y'
864: FROM DUAL
865: WHERE EXISTS (SELECT '1'
866: FROM OKL_TXL_ASSETS_V
867: WHERE asset_number = p_asset_number);
868:
869: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
870: --start modified abhsaxen for performance SQLID 20562304

Line 920: From OKL_TXL_ASSETS_V txlv,

916: --Cursor to check asset number on txl
917: CURSOR l_txlv_csr (p_finasst_id IN NUMBER, P_Asstno IN VARCHAR2) is
918: Select txlv.id,
919: txlv.asset_number
920: From OKL_TXL_ASSETS_V txlv,
921: OKC_K_LINES_B cle,
922: OKC_LINE_STYLES_B lse
923: Where txlv.kle_id = cle.id
924: And cle.lse_id = lse.id

Line 929: l_txl_id OKL_TXL_ASSETS_V.ID%TYPE;

925: And lse.lty_code = 'FIXED_ASSET'
926: And cle.cle_id = p_finasst_id
927: And txlv.asset_number = p_asstNo;
928:
929: l_txl_id OKL_TXL_ASSETS_V.ID%TYPE;
930: l_txl_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE;
931:
932: --Cursor to check asset number on txd
933: CURSOR l_txdv_csr (p_finasst_id IN NUMBER, p_asstno IN VARCHAR2) is

Line 930: l_txl_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE;

926: And cle.cle_id = p_finasst_id
927: And txlv.asset_number = p_asstNo;
928:
929: l_txl_id OKL_TXL_ASSETS_V.ID%TYPE;
930: l_txl_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE;
931:
932: --Cursor to check asset number on txd
933: CURSOR l_txdv_csr (p_finasst_id IN NUMBER, p_asstno IN VARCHAR2) is
934: Select txdv.id,

Line 937: OKL_TXL_ASSETS_V txlv,

933: CURSOR l_txdv_csr (p_finasst_id IN NUMBER, p_asstno IN VARCHAR2) is
934: Select txdv.id,
935: txdv.asset_number
936: From OKL_TXD_ASSETS_V txdv,
937: OKL_TXL_ASSETS_V txlv,
938: OKC_K_LINES_B cle,
939: OKC_LINE_STYLES_B lse
940: Where txdv.tal_id = txlv.id
941: And txlv.kle_id = cle.id