APPS.OKC_VERSION_PVT dependencies on OKC_TIMEVALUES

Line 1486: delete FROM OKC_TIMEVALUES_TLH

1482: --
1483: */
1484: --Bug 3122962
1485: /*
1486: delete FROM OKC_TIMEVALUES_TLH
1487: WHERE id in (select id from OKC_TIMEVALUES_BH
1488: WHERE dnz_chr_id= p_chr_id)
1489: and ((MAJOR_VERSION = -1
1490: and p_called_from = 'ERASE_SAVED_VERSION')

Line 1487: WHERE id in (select id from OKC_TIMEVALUES_BH

1483: */
1484: --Bug 3122962
1485: /*
1486: delete FROM OKC_TIMEVALUES_TLH
1487: WHERE id in (select id from OKC_TIMEVALUES_BH
1488: WHERE dnz_chr_id= p_chr_id)
1489: and ((MAJOR_VERSION = -1
1490: and p_called_from = 'ERASE_SAVED_VERSION')
1491: or (p_called_from = 'RESTORE_VERSION'

Line 1497: delete FROM OKC_TIMEVALUES_H

1493: or major_version = -1)));
1494: */
1495: --
1496: --Bug 3122962
1497: delete FROM OKC_TIMEVALUES_H
1498: WHERE dnz_chr_id= p_chr_id
1499: and ((MAJOR_VERSION = -1
1500: and p_called_from = 'ERASE_SAVED_VERSION')
1501: or (p_called_from = 'RESTORE_VERSION'

Line 1948: delete from OKC_TIMEVALUES_TL

1944: delete from OKC_RULES_B where DNZ_CHR_ID = p_chr_id;
1945: */
1946: --Bug 3122962
1947: /*
1948: delete from OKC_TIMEVALUES_TL
1949: WHERE id in (select id from OKC_TIMEVALUES_B
1950: WHERE dnz_chr_id= p_chr_id);
1951: */
1952: --Bug 3122962

Line 1949: WHERE id in (select id from OKC_TIMEVALUES_B

1945: */
1946: --Bug 3122962
1947: /*
1948: delete from OKC_TIMEVALUES_TL
1949: WHERE id in (select id from OKC_TIMEVALUES_B
1950: WHERE dnz_chr_id= p_chr_id);
1951: */
1952: --Bug 3122962
1953: delete from OKC_TIMEVALUES where DNZ_CHR_ID = p_chr_id;

Line 1953: delete from OKC_TIMEVALUES where DNZ_CHR_ID = p_chr_id;

1949: WHERE id in (select id from OKC_TIMEVALUES_B
1950: WHERE dnz_chr_id= p_chr_id);
1951: */
1952: --Bug 3122962
1953: delete from OKC_TIMEVALUES where DNZ_CHR_ID = p_chr_id;
1954:
1955: delete from OKC_PRICE_ADJUSTMENTS
1956: WHERE chr_id = p_chr_id;
1957: