APPS.OKL_CONTRACT_PVT dependencies on OKL_TXD_ASSETS_V

Line 925: FROM OKL_TXD_ASSETS_V

921: CURSOR c_txd_assets_v (p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
922: SELECT 'Y'
923: FROM DUAL
924: WHERE EXISTS (SELECT '1'
925: FROM OKL_TXD_ASSETS_V
926: WHERE asset_number = p_asset_number);
927:
928:
929: l_asset_exists Varchar2(1) default 'N';

Line 968: From OKL_TXD_ASSETS_V txdv,

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,
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

Line 979: l_txd_id OKL_TXD_ASSETS_V.ID%TYPE;

975: And lse.lty_code = 'FIXED_ASSET'
976: And cle.cle_id = p_finasst_id
977: And txdv.asset_number = p_asstno;
978:
979: l_txd_id OKL_TXD_ASSETS_V.ID%TYPE;
980: l_txd_asset_number OKL_TXD_ASSETS_V.ASSET_NUMBER%TYPE;
981:
982: l_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
983: lx_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;

Line 980: l_txd_asset_number OKL_TXD_ASSETS_V.ASSET_NUMBER%TYPE;

976: And cle.cle_id = p_finasst_id
977: And txdv.asset_number = p_asstno;
978:
979: l_txd_id OKL_TXD_ASSETS_V.ID%TYPE;
980: l_txd_asset_number OKL_TXD_ASSETS_V.ASSET_NUMBER%TYPE;
981:
982: l_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
983: lx_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
984: l_adpv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;