APPS.OKL_CONTRACT_PVT dependencies on OKC_K_ITEMS

Line 1165: okc_k_items cim

1161: Select lnk.id
1162: From okc_k_lines_b lnk,
1163: okc_line_styles_b lnk_lse,
1164: okc_statuses_b sts,
1165: okc_k_items cim
1166: Where lnk.id = cim.cle_id
1167: and lnk.dnz_chr_id = cim.dnz_chr_id
1168: and lnk.lse_id = lnk_lse.id
1169: and lnk_lse.lty_code in ('LINK_FEE_ASSET','LINK_SERV_ASSET','LINK_USAGE_ASSET')

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

7699: p_clev_rec => l_clev_rec);
7700:
7701:
7702: --12/10/01 ashish - changed this to call different okc api as we need to delete
7703: --okc_k_items automatically when okc_k_lines is deleted.
7704: --okc_contract_pub can be called directly here as there are no records involved
7705:
7706: --taken care of in another api with p_delete_cascade_yn flag
7707:

Line 10831: SELECT 'x' FROM okc_k_items cim

10827: SELECT 'Y' FROM okc_k_headers_b chr
10828: WHERE id = p_contract_id
10829: AND EXISTS
10830: (
10831: SELECT 'x' FROM okc_k_items cim
10832: WHERE cim.object1_id1 = to_char(chr.id)
10833: AND EXISTS
10834: (
10835: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse