APPS.OKL_BLK_AST_UPD_PVT dependencies on OKL_TRX_ASSETS

Line 257: FROM OKL_TRX_ASSETS TRX,

253: --asawanka added for ebtax start
254: CURSOR c_get_entered_alc_trx(cp_kle_id IN NUMBER)
255: IS
256: SELECT 'X'
257: FROM OKL_TRX_ASSETS TRX,
258: OKL_TXL_ITM_INSTS TXL,
259: OKL_TRX_TYPES_B TRY
260: WHERE TRX.ID = TXL.TAS_ID
261: AND TRX.TRY_ID = TRY.ID

Line 779: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(

775: RAISE OKL_API.G_EXCEPTION_ERROR;
776: END IF;
777: -- evaluate conditions, build outcomes for true conditions and
778: -- put them on outcome queue
779: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(
780: p_api_version => p_api_version,
781: p_init_msg_list => p_init_msg_list,
782: x_return_status => x_return_status,
783: x_msg_count => x_msg_count,

Line 842: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

838: RAISE OKL_API.G_EXCEPTION_ERROR;
839: END IF;
840: -- evaluate conditions, build outcomes for true conditions and
841: -- put them on outcome queue
842: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
843: p_api_version => p_api_version,
844: p_init_msg_list => p_init_msg_list,
845: x_return_status => x_return_status,
846: x_msg_count => x_msg_count,

Line 1800: FROM OKL_TRX_ASSETS TRX,

1796: CURSOR c_get_entered_alc_trx(cp_kle_id IN NUMBER) IS
1797: SELECT TRX.ID,TRX.TSU_CODE, TXL.object_id1_new, TXL.object_id2_new,
1798: TXL.object_id1_old,object_id2_old,psu.location_id, psu.party_site_id,
1799: TRX.DATE_TRANS_OCCURRED,TRX.req_asset_id
1800: FROM OKL_TRX_ASSETS TRX,
1801: OKL_TXL_ITM_INSTS TXL,
1802: OKL_TRX_TYPES_B TRY,
1803: OKX_PARTY_SITE_USES_V psu
1804: WHERE TRX.ID = TXL.TAS_ID