APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKX_PARTY_SITE_USES_V

Line 10963: OBJECT_ID1_NEW, -- ID of okx_party_site_uses_v

10959:
10960: -- get the trx line details
10961: CURSOR l_txlitminsts_csr(cp_id IN NUMBER) IS
10962: SELECT kle_id, -- Id of INST_ITEM line
10963: OBJECT_ID1_NEW, -- ID of okx_party_site_uses_v
10964: DNZ_CLE_ID -- id of FREE_FORM1
10965: FROM okl_txl_itm_insts
10966: WHERE tas_id = cp_id;
10967:

Line 10972: FROM okx_party_site_uses_v

10968: -- get the new location id
10969: --asawanka modified for bug # 6612165
10970: CURSOR l_partysiteuses_csr(cp_id1 IN NUMBER) IS
10971: SELECT location_id, party_site_id
10972: FROM okx_party_site_uses_v
10973: WHERE id1 = cp_id1
10974: AND site_use_type = 'INSTALL_AT';
10975:
10976: -- get the acive upfront tax sources for this asset