APPS.OKC_VERSION_PVT dependencies on OKC_CONDITION_HEADERS_B

Line 1241: WHERE id in (select id from OKC_CONDITION_HEADERS_BH

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')
1245: or (p_called_from = 'RESTORE_VERSION'

Line 1249: delete FROM OKC_CONDITION_HEADERS_BH

1245: or (p_called_from = 'RESTORE_VERSION'
1246: and (major_version > l_major_version
1247: or major_version = -1)));
1248: --
1249: delete FROM OKC_CONDITION_HEADERS_BH
1250: WHERE dnz_chr_id= p_chr_id
1251: and ((MAJOR_VERSION = -1
1252: and p_called_from = 'ERASE_SAVED_VERSION')
1253: or (p_called_from = 'RESTORE_VERSION'

Line 1869: WHERE id in (select id from OKC_CONDITION_HEADERS_B

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;
1873:

Line 1872: delete from OKC_CONDITION_HEADERS_B where DNZ_CHR_ID = p_chr_id;

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;
1873:
1874: delete from OKC_CONDITION_LINES_TL
1875: WHERE id in (select id from OKC_CONDITION_LINES_B
1876: WHERE dnz_chr_id= p_chr_id);