APPS.OKL_BLK_AST_UPD_PVT dependencies on OKL_TRX_ASSETS

Line 225: FROM OKL_TRX_ASSETS TRX,

221: --asawanka added for ebtax start
222: CURSOR c_get_entered_alc_trx(cp_kle_id IN NUMBER)
223: IS
224: SELECT 'X'
225: FROM OKL_TRX_ASSETS TRX,
226: OKL_TXL_ITM_INSTS TXL,
227: OKL_TRX_TYPES_B TRY
228: WHERE TRX.ID = TXL.TAS_ID
229: AND TRX.TRY_ID = TRY.ID

Line 747: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(

743: RAISE OKL_API.G_EXCEPTION_ERROR;
744: END IF;
745: -- evaluate conditions, build outcomes for true conditions and
746: -- put them on outcome queue
747: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(
748: p_api_version => p_api_version,
749: p_init_msg_list => p_init_msg_list,
750: x_return_status => x_return_status,
751: x_msg_count => x_msg_count,

Line 810: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

806: RAISE OKL_API.G_EXCEPTION_ERROR;
807: END IF;
808: -- evaluate conditions, build outcomes for true conditions and
809: -- put them on outcome queue
810: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
811: p_api_version => p_api_version,
812: p_init_msg_list => p_init_msg_list,
813: x_return_status => x_return_status,
814: x_msg_count => x_msg_count,

Line 1768: FROM OKL_TRX_ASSETS TRX,

1764: CURSOR c_get_entered_alc_trx(cp_kle_id IN NUMBER) IS
1765: SELECT TRX.ID,TRX.TSU_CODE, TXL.object_id1_new, TXL.object_id2_new,
1766: TXL.object_id1_old,object_id2_old,psu.location_id, psu.party_site_id,
1767: TRX.DATE_TRANS_OCCURRED,TRX.req_asset_id
1768: FROM OKL_TRX_ASSETS TRX,
1769: OKL_TXL_ITM_INSTS TXL,
1770: OKL_TRX_TYPES_B TRY,
1771: OKX_PARTY_SITE_USES_V psu
1772: WHERE TRX.ID = TXL.TAS_ID