APPS.OKL_CONTRACT_PVT dependencies on OKC_K_ITEMS

Line 1197: okc_k_items cim

1193: Select lnk.id
1194: From okc_k_lines_b lnk,
1195: okc_line_styles_b lnk_lse,
1196: okc_statuses_b sts,
1197: okc_k_items cim
1198: Where lnk.id = cim.cle_id
1199: and lnk.dnz_chr_id = cim.dnz_chr_id
1200: and lnk.lse_id = lnk_lse.id
1201: and lnk_lse.lty_code in ('LINK_FEE_ASSET','LINK_SERV_ASSET','LINK_USAGE_ASSET')

Line 7805: --okc_k_items automatically when okc_k_lines is deleted.

7801: p_clev_rec => l_clev_rec);
7802:
7803:
7804: --12/10/01 ashish - changed this to call different okc api as we need to delete
7805: --okc_k_items automatically when okc_k_lines is deleted.
7806: --okc_contract_pub can be called directly here as there are no records involved
7807:
7808: --taken care of in another api with p_delete_cascade_yn flag
7809:

Line 10933: SELECT 'x' FROM okc_k_items cim

10929: SELECT 'Y' FROM okc_k_headers_b chr
10930: WHERE id = p_contract_id
10931: AND EXISTS
10932: (
10933: SELECT 'x' FROM okc_k_items cim
10934: WHERE cim.object1_id1 = to_char(chr.id)
10935: AND EXISTS
10936: (
10937: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse