DBA Data[Home] [Help]

APPS.OKC_VERSION_PVT dependencies on OKC_CONDITION_HEADERS_BH

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'