APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_K_HISTORY_B

Line 5360: FROM okc_k_history_b

5356:
5357: -- Cursor for status change history
5358: CURSOR history_csr(p_chr_id NUMBER) IS
5359: SELECT id
5360: FROM okc_k_history_b
5361: WHERE TO_CHAR(CREATION_DATE, 'DD-MON-YYYY HH:MI:SS') =
5362: (SELECT MAX(TO_CHAR(CREATION_DATE, 'DD-MON-YYYY HH:MI:SS'))
5363: FROM OKC_K_HISTORY_B
5364: WHERE CHR_ID = p_chr_id)

Line 5363: FROM OKC_K_HISTORY_B

5359: SELECT id
5360: FROM okc_k_history_b
5361: WHERE TO_CHAR(CREATION_DATE, 'DD-MON-YYYY HH:MI:SS') =
5362: (SELECT MAX(TO_CHAR(CREATION_DATE, 'DD-MON-YYYY HH:MI:SS'))
5363: FROM OKC_K_HISTORY_B
5364: WHERE CHR_ID = p_chr_id)
5365: AND CHR_ID = p_chr_id;
5366:
5367:

Line 5619: UPDATE okc_k_history_b

5615: FETCH history_csr INTO l_history_id;
5616: CLOSE history_csr;
5617:
5618: If l_history_id IS NOT NULL Then
5619: UPDATE okc_k_history_b
5620: SET reason_code = 'RENEW'
5621: WHERE id = l_history_id;
5622: End If;
5623: