DBA Data[Home] [Help]

APPS.OKS_SETUP_UTIL_PUB dependencies on OKC_K_ITEMS

Line 1493: FROM okc_k_lines_b a, okc_k_items b

1489:
1490: -- Gets the new covered lines that are covering the old item instance.
1491: Cursor get_new_cps(oldItemInst number) IS
1492: SELECT b.id
1493: FROM okc_k_lines_b a, okc_k_items b
1494: WHERE b.cle_id = a.id and a.lse_id = 9 and b.object1_id1 = oldItemInst
1495: AND a.dnz_chr_id = p_new_chr_id;
1496:
1497: Begin

Line 2642: FROM okc_k_items

2638:
2639:
2640: CURSOR get_item_csr (p_cle_id NUMBER) IS
2641: SELECT COUNT(id) cnt
2642: FROM okc_k_items
2643: WHERE cle_id = p_cle_id;
2644: get_item_rec get_item_csr%ROWTYPE;
2645:
2646: /*