APPS.OKL_REVERSE_CONTRACT_PVT dependencies on OKL_TXL_ASSETS_B

Line 120: FROM OKL_TRX_ASSETS A, OKL_TXL_ASSETS_B B, OKL_TRX_TYPES_B TTB

116: G_UPFRONT_TAX); -- G_UPFRONT_TAX introduced for R12 ebTax requirement
117:
118: CURSOR asset_cur IS
119: SELECT '1'
120: FROM OKL_TRX_ASSETS A, OKL_TXL_ASSETS_B B, OKL_TRX_TYPES_B TTB
121: WHERE B.DNZ_KHR_ID = p_contract_id
122: AND A.ID = B.TAS_ID
123: AND A.TRY_ID = TTB.ID
124: AND TTB.TRX_TYPE_CLASS NOT IN (G_INTERNAL_ASSET_CREATION);

Line 180: ,p_token1_value => g_okl_txl_assets_b);

176: IF NOT (l_row_notfound) THEN
177: OKC_API.SET_MESSAGE(p_app_name => g_app_name
178: ,p_msg_name => okl_lla_cont_rev_trx_type
179: ,p_token1 => g_source_table
180: ,p_token1_value => g_okl_txl_assets_b);
181: x_return_status := G_RET_STS_ERROR;
182: RAISE G_EXCEPTION_ERROR;
183: END IF;
184:

Line 263: FROM OKL_TXL_ASSETS_B TA,OKL_TRX_ASSETS TAS

259: WHERE TCN_ID = p_tcn_id;
260:
261: CURSOR asset_trx_cur IS
262: SELECT DISTINCT TAS.ID TAS_ID,TAS.TRANSACTION_DATE
263: FROM OKL_TXL_ASSETS_B TA,OKL_TRX_ASSETS TAS
264: WHERE TA.DNZ_KHR_ID = p_contract_id
265: AND TA.TAS_ID=TAS.ID;
266:
267: CURSOR asset_trx_lines_cur (p_tas_id NUMBER) IS

Line 269: FROM OKL_TXL_ASSETS_B TA

265: AND TA.TAS_ID=TAS.ID;
266:
267: CURSOR asset_trx_lines_cur (p_tas_id NUMBER) IS
268: SELECT ID
269: FROM OKL_TXL_ASSETS_B TA
270: WHERE TA.TAS_ID = p_tas_id;
271:
272: -- sjalasut, modified the cursor to refer khr_id from okl_txl_ap_inv_lns_all_b instead
273: -- of okl_trx_ap_invoices_b. changes made as part of OKLR12B disbursements project

Line 496: p_source_table => G_OKL_TXL_ASSETS_B,

492: x_return_status => l_return_status,
493: x_msg_count => l_msg_count,
494: x_msg_data => l_msg_data,
495: p_source_id => asset_trx_lines_rec.id,
496: p_source_table => G_OKL_TXL_ASSETS_B,
497: p_acct_date => p_transaction_date);
498:
499:
500: IF l_return_status = G_RET_STS_ERROR THEN

Line 721: FROM OKL_TXL_ASSETS_B

717: AND b.KHR_ID = p_contract_id;
718:
719: CURSOR asset_trx_cur IS
720: SELECT '1'
721: FROM OKL_TXL_ASSETS_B
722: WHERE DNZ_KHR_ID = p_contract_id;
723:
724: -- Start Manu 11-Aug-2004.
725: -- Cursor to find if there are any Rollover Fee lines on a contract