918: l_party_site_id okx_party_site_uses_v.PARTY_SITE_ID%TYPE;
919: l_location_id okx_party_site_uses_v.LOCATION_ID%TYPE;
920:
921: l_loc_rec OKL_BLK_AST_UPD_PUB.blk_rec_type;
922: l_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
923: x_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
924:
925: CURSOR okl_loc_csr (p_id1 IN OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE, p_id2 IN OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE) IS
926: SELECT
919: l_location_id okx_party_site_uses_v.LOCATION_ID%TYPE;
920:
921: l_loc_rec OKL_BLK_AST_UPD_PUB.blk_rec_type;
922: l_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
923: x_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
924:
925: CURSOR okl_loc_csr (p_id1 IN OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE, p_id2 IN OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE) IS
926: SELECT
927: PARTY_SITE_ID,