APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_TXL_ITM_INSTS

Line 82: FROM okl_txl_itm_insts

78:
79: -- get the party site use ID
80: CURSOR l_txlitminsts_csr(cp_kle_id IN NUMBER) IS
81: SELECT object_id1_new
82: FROM okl_txl_itm_insts
83: WHERE kle_id = cp_kle_id;
84:
85: -- get the party site id
86: CURSOR l_partysiteuses_csr(cp_party_site_use_id IN NUMBER) IS

Line 10965: FROM okl_txl_itm_insts

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:
10968: -- get the new location id
10969: --asawanka modified for bug # 6612165

Line 17583: okl_txl_itm_insts inst,

17579: -- ER#9327076
17580: CURSOR get_ast_reloc_khr(p_trx_id okl_trx_assets.ID%TYPE) IS
17581: SELECT cle.dnz_chr_id
17582: FROM okl_trx_assets trx,
17583: okl_txl_itm_insts inst,
17584: okc_k_lines_b cle
17585: WHERE trx.tas_type = 'ALG'
17586: AND inst.tas_id = trx.ID
17587: AND cle.ID = inst.kle_id