APPS.OKL_MAINTAIN_CONTRACT_PVT dependencies on OKL_TXD_ASSETS_V

Line 70: FROM OKL_TXD_ASSETS_V

66: WHERE EXISTS (SELECT '1'
67: FROM OKL_TXL_ASSETS_V
68: WHERE asset_number = p_asset_number)
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);

Line 116: From OKL_TXD_ASSETS_V txdv,

112: --Cursor to check asset number on txd
113: CURSOR l_txdv_csr (p_finasst_id IN NUMBER, p_asstno IN VARCHAR2) is
114: Select txdv.id,
115: txdv.asset_number
116: From OKL_TXD_ASSETS_V txdv,
117: OKL_TXL_ASSETS_V txlv,
118: OKC_K_LINES_B cle,
119: OKC_LINE_STYLES_B lse
120: Where txdv.tal_id = txlv.id

Line 127: l_txd_id OKL_TXD_ASSETS_V.ID%TYPE;

123: And lse.lty_code = 'FIXED_ASSET'
124: And cle.cle_id = p_finasst_id
125: And txdv.asset_number = p_asstno;
126:
127: l_txd_id OKL_TXD_ASSETS_V.ID%TYPE;
128: l_txd_asset_number OKL_TXD_ASSETS_V.ASSET_NUMBER%TYPE;
129:
130: l_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
131: lx_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;

Line 128: l_txd_asset_number OKL_TXD_ASSETS_V.ASSET_NUMBER%TYPE;

124: And cle.cle_id = p_finasst_id
125: And txdv.asset_number = p_asstno;
126:
127: l_txd_id OKL_TXD_ASSETS_V.ID%TYPE;
128: l_txd_asset_number OKL_TXD_ASSETS_V.ASSET_NUMBER%TYPE;
129:
130: l_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
131: lx_tlpv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
132: