APPS.OKL_REVERSE_CONTRACT_PVT dependencies on OKL_TRX_ASSETS

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 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 469: OKL_TRX_ASSETS_PUB.update_trx_ass_h_Def(

465: LOOP
466: l_thpv_rec.id := asset_trx_rec.tas_id;
467: l_thpv_rec.TSU_CODE := G_CANCELED;
468: l_thpv_rec.transaction_date := asset_trx_rec.transaction_date;
469: OKL_TRX_ASSETS_PUB.update_trx_ass_h_Def(
470: p_api_version => l_api_version
471: ,p_init_msg_list => l_init_msg_list
472: ,x_return_status => l_return_status
473: ,x_msg_count => l_msg_count