DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_K_ITEMS_V

Line 3311: FROM okc_k_items_v

3307: WHERE id = p_to_cle_id;
3308:
3309: CURSOR c_cimv IS
3310: SELECT id
3311: FROM okc_k_items_v
3312: WHERE cle_id = p_from_cle_id;
3313:
3314: BEGIN
3315: x_return_status := l_return_status;

Line 3778: FROM okc_k_items_v

3774: WHERE id = p_id;
3775:
3776: CURSOR c_cim(p_cle_id IN NUMBER) IS
3777: SELECT id
3778: FROM okc_k_items_v
3779: WHERE cle_id = p_cle_id
3780: AND priced_item_yn = 'Y';
3781:
3782: BEGIN

Line 3856: FROM okc_k_items_v

3852: l_actual_coverage_id NUMBER;
3853:
3854: CURSOR c_item IS
3855: SELECT object1_id1
3856: FROM okc_k_items_v
3857: WHERE cle_id = p_old_cle_id;
3858:
3859: Cursor l_ctr_csr (p_id Number) Is
3860: Select Counter_Group_id

Line 6796: FROM OKC_K_ITEMS_V

6792: UOM_CODE,
6793: EXCEPTION_YN,
6794: NUMBER_OF_ITEMS,
6795: PRICED_ITEM_YN
6796: FROM OKC_K_ITEMS_V
6797: WHERE ID = p_cim_id;
6798: BEGIN
6799: OPEN c_cimv_rec;
6800: FETCH c_cimv_rec