APPS.OKC_VERSION_PVT dependencies on OKC_CONDITION_LINES_B

Line 1258: WHERE id in (select id from OKC_CONDITION_LINES_BH

1254: and (major_version > l_major_version
1255: or major_version = -1)));
1256: --
1257: delete FROM OKC_CONDITION_LINES_TLH
1258: WHERE id in (select id from OKC_CONDITION_LINES_BH
1259: WHERE dnz_chr_id= p_chr_id)
1260: and ((MAJOR_VERSION = -1
1261: and p_called_from = 'ERASE_SAVED_VERSION')
1262: or (p_called_from = 'RESTORE_VERSION'

Line 1266: delete FROM OKC_CONDITION_LINES_BH

1262: or (p_called_from = 'RESTORE_VERSION'
1263: and (major_version > l_major_version
1264: or major_version = -1)));
1265: --
1266: delete FROM OKC_CONDITION_LINES_BH
1267: WHERE dnz_chr_id= p_chr_id
1268: and ((MAJOR_VERSION = -1
1269: and p_called_from = 'ERASE_SAVED_VERSION')
1270: or (p_called_from = 'RESTORE_VERSION'

Line 1875: WHERE id in (select id from OKC_CONDITION_LINES_B

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);
1877:
1878: delete from OKC_CONDITION_LINES_B where DNZ_CHR_ID = p_chr_id;
1879:

Line 1878: delete from OKC_CONDITION_LINES_B where DNZ_CHR_ID = p_chr_id;

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);
1877:
1878: delete from OKC_CONDITION_LINES_B where DNZ_CHR_ID = p_chr_id;
1879:
1880: delete from OKC_CONTACTS where DNZ_CHR_ID = p_chr_id;
1881:
1882: delete from OKC_COVER_TIMES where DNZ_CHR_ID = p_chr_id;