APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKC_K_ITEMS

Line 283: SELECT 'x' FROM okc_k_items cim

279: SELECT 'Y' FROM okc_k_headers_b chr
280: WHERE id = p_contract_id
281: AND EXISTS
282: (
283: SELECT 'x' FROM okc_k_items cim
284: WHERE cim.object1_id1 = to_char(chr.id)
285: AND EXISTS
286: (
287: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse

Line 1510: okc_k_items ite,

1506: FROM okc_k_lines_b kle_fa,
1507: okc_line_styles_b lse_fa,
1508: okc_k_lines_b kle_ml,
1509: okc_line_styles_b lse_ml,
1510: okc_k_items ite,
1511: okl_k_headers_full_v khr
1512: WHERE kle_fa.id = cp_cle_id
1513: AND kle_fa.chr_id = cp_chr_id
1514: AND lse_fa.id = kle_fa.lse_id

Line 1542: FROM okc_k_items

1538:
1539: -- cursor to get parent kle_id
1540: CURSOR get_parent_kle_id_csr (p_kle_id NUMBER) IS
1541: SELECT object1_id1
1542: FROM okc_k_items
1543: WHERE cle_id = p_kle_id;
1544:
1545: --Added by kthiruva on 14-May-2007
1546: --cursor to fetch the contract dff information for SLA Uptake