DBA Data[Home] [Help]

APPS.OKS_SETUP_UTIL_PUB dependencies on OKC_K_ITEMS

Line 1501: FROM okc_k_lines_b a, okc_k_items b

1497:
1498: -- Gets the new covered lines that are covering the old item instance.
1499: Cursor get_new_cps(oldItemInst number) IS
1500: SELECT b.id
1501: FROM okc_k_lines_b a, okc_k_items b
1502: WHERE b.cle_id = a.id and a.lse_id = 9 and b.object1_id1 = oldItemInst
1503: AND a.dnz_chr_id = p_new_chr_id;
1504:
1505: Begin

Line 2651: FROM okc_k_items

2647:
2648:
2649: CURSOR get_item_csr (p_cle_id NUMBER) IS
2650: SELECT COUNT(id) cnt
2651: FROM okc_k_items
2652: WHERE cle_id = p_cle_id;
2653: get_item_rec get_item_csr%ROWTYPE;
2654:
2655: /*