APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKX_PARTY_SITE_USES_V

Line 10928: OBJECT_ID1_NEW, -- ID of okx_party_site_uses_v

10924:
10925: -- get the trx line details
10926: CURSOR l_txlitminsts_csr(cp_id IN NUMBER) IS
10927: SELECT kle_id, -- Id of INST_ITEM line
10928: OBJECT_ID1_NEW, -- ID of okx_party_site_uses_v
10929: DNZ_CLE_ID -- id of FREE_FORM1
10930: FROM okl_txl_itm_insts
10931: WHERE tas_id = cp_id;
10932:

Line 10937: FROM okx_party_site_uses_v

10933: -- get the new location id
10934: --asawanka modified for bug # 6612165
10935: CURSOR l_partysiteuses_csr(cp_id1 IN NUMBER) IS
10936: SELECT location_id, party_site_id
10937: FROM okx_party_site_uses_v
10938: WHERE id1 = cp_id1
10939: AND site_use_type = 'INSTALL_AT';
10940:
10941: -- get the acive upfront tax sources for this asset