DBA Data[Home] [Help]

APPS.OKC_VERSION_PVT dependencies on OKC_CONDITION_HEADERS_TL

Line 1240: delete FROM OKC_CONDITION_HEADERS_TLH

1236:
1237: IF SQL%NOTFOUND THEN
1238:
1239: --
1240: delete FROM OKC_CONDITION_HEADERS_TLH
1241: WHERE id in (select id from OKC_CONDITION_HEADERS_BH
1242: WHERE dnz_chr_id= p_chr_id)
1243: and ((MAJOR_VERSION = -1
1244: and p_called_from = 'ERASE_SAVED_VERSION')

Line 1868: delete from OKC_CONDITION_HEADERS_TL

1864: fetch l_status_csr into l_Contract_old_status;
1865: close l_status_csr;
1866:
1867:
1868: delete from OKC_CONDITION_HEADERS_TL
1869: WHERE id in (select id from OKC_CONDITION_HEADERS_B
1870: WHERE dnz_chr_id= p_chr_id);
1871:
1872: delete from OKC_CONDITION_HEADERS_B where DNZ_CHR_ID = p_chr_id;