APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_K_HISTORY_B

Line 5361: FROM okc_k_history_b

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

Line 5364: FROM OKC_K_HISTORY_B

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

Line 5620: UPDATE okc_k_history_b

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