APPS.OKL_MAINTAIN_CONTRACT_PVT dependencies on OKL_TXL_ASSETS_V

Line 67: FROM OKL_TXL_ASSETS_V

63: CURSOR c_chk_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
64: SELECT 'Y'
65: FROM DUAL
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)

Line 100: From OKL_TXL_ASSETS_V txlv,

96: --Cursor to check asset number on txl
97: CURSOR l_txlv_csr (p_finasst_id IN NUMBER, p_asstno IN VARCHAR2) is
98: Select txlv.id,
99: txlv.asset_number
100: From OKL_TXL_ASSETS_V txlv,
101: OKC_K_LINES_B cle,
102: OKC_LINE_STYLES_B lse
103: Where txlv.kle_id = cle.id
104: And cle.lse_id = lse.id

Line 109: l_txl_id OKL_TXL_ASSETS_V.ID%TYPE;

105: And lse.lty_code = 'FIXED_ASSET'
106: And cle.cle_id = p_finasst_id
107: And txlv.asset_number = p_asstNo;
108:
109: l_txl_id OKL_TXL_ASSETS_V.ID%TYPE;
110: l_txl_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE;
111:
112: --Cursor to check asset number on txd
113: CURSOR l_txdv_csr (p_finasst_id IN NUMBER, p_asstno IN VARCHAR2) is

Line 110: l_txl_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE;

106: And cle.cle_id = p_finasst_id
107: And txlv.asset_number = p_asstNo;
108:
109: l_txl_id OKL_TXL_ASSETS_V.ID%TYPE;
110: l_txl_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE;
111:
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,

Line 117: OKL_TXL_ASSETS_V txlv,

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
121: And txlv.kle_id = cle.id