APPS.OKL_EQUIPMENT_EXCHANGE_PVT dependencies on OKL_TXL_ASSETS_V

Line 178: -- FUNCTION get_rec for: OKL_TXL_ASSETS_V

174:
175: END get_instance_id;
176:
177: ---------------------------------------------------------------------------
178: -- FUNCTION get_rec for: OKL_TXL_ASSETS_V
179: ---------------------------------------------------------------------------
180: FUNCTION get_tal_rec (
181: p_talv_tbl IN talv_tbl_type,
182: x_no_data_found OUT NOCOPY BOOLEAN

Line 253: FROM Okl_Txl_Assets_V

249: SALE_PROCEEDS,
250: REMOVAL_COST,
251: DNZ_ASSET_ID
252: ,DATE_DUE
253: FROM Okl_Txl_Assets_V
254: WHERE okl_txl_assets_v.tas_id = p_tas_id
255: AND okl_txl_assets_v.tal_type = p_tal_type;
256: l_okl_talv_pk okl_talv_pk_csr%ROWTYPE;
257: l_talv_tbl talv_tbl_type;

Line 254: WHERE okl_txl_assets_v.tas_id = p_tas_id

250: REMOVAL_COST,
251: DNZ_ASSET_ID
252: ,DATE_DUE
253: FROM Okl_Txl_Assets_V
254: WHERE okl_txl_assets_v.tas_id = p_tas_id
255: AND okl_txl_assets_v.tal_type = p_tal_type;
256: l_okl_talv_pk okl_talv_pk_csr%ROWTYPE;
257: l_talv_tbl talv_tbl_type;
258: BEGIN

Line 255: AND okl_txl_assets_v.tal_type = p_tal_type;

251: DNZ_ASSET_ID
252: ,DATE_DUE
253: FROM Okl_Txl_Assets_V
254: WHERE okl_txl_assets_v.tas_id = p_tas_id
255: AND okl_txl_assets_v.tal_type = p_tal_type;
256: l_okl_talv_pk okl_talv_pk_csr%ROWTYPE;
257: l_talv_tbl talv_tbl_type;
258: BEGIN
259: x_no_data_found := TRUE;