APPS.OKL_CONTRACT_PVT dependencies on OKL_TXD_ASSETS_V

Line 893: FROM OKL_TXD_ASSETS_V

889: CURSOR c_txd_assets_v (p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
890: SELECT 'Y'
891: FROM DUAL
892: WHERE EXISTS (SELECT '1'
893: FROM OKL_TXD_ASSETS_V
894: WHERE asset_number = p_asset_number);
895:
896:
897: l_asset_exists Varchar2(1) default 'N';

Line 936: From OKL_TXD_ASSETS_V txdv,

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

Line 947: l_txd_id OKL_TXD_ASSETS_V.ID%TYPE;

943: And lse.lty_code = 'FIXED_ASSET'
944: And cle.cle_id = p_finasst_id
945: And txdv.asset_number = p_asstno;
946:
947: l_txd_id OKL_TXD_ASSETS_V.ID%TYPE;
948: l_txd_asset_number OKL_TXD_ASSETS_V.ASSET_NUMBER%TYPE;
949:
950: l_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
951: lx_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;

Line 948: l_txd_asset_number OKL_TXD_ASSETS_V.ASSET_NUMBER%TYPE;

944: And cle.cle_id = p_finasst_id
945: And txdv.asset_number = p_asstno;
946:
947: l_txd_id OKL_TXD_ASSETS_V.ID%TYPE;
948: l_txd_asset_number OKL_TXD_ASSETS_V.ASSET_NUMBER%TYPE;
949:
950: l_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
951: lx_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
952: l_adpv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;