DBA Data[Home] [Help]

APPS.OKC_VERSION_PVT dependencies on OKC_OUTCOMES_B

Line 1414: WHERE id in (select id from OKC_OUTCOMES_BH

1410: and (major_version > l_major_version
1411: or major_version = -1)));
1412: --
1413: delete FROM OKC_OUTCOMES_TLH
1414: WHERE id in (select id from OKC_OUTCOMES_BH
1415: WHERE dnz_chr_id= p_chr_id)
1416: and ((MAJOR_VERSION = -1
1417: and p_called_from = 'ERASE_SAVED_VERSION')
1418: or (p_called_from = 'RESTORE_VERSION'

Line 1422: delete FROM OKC_OUTCOMES_BH

1418: or (p_called_from = 'RESTORE_VERSION'
1419: and (major_version > l_major_version
1420: or major_version = -1)));
1421: --
1422: delete FROM OKC_OUTCOMES_BH
1423: WHERE dnz_chr_id= p_chr_id
1424: and ((MAJOR_VERSION = -1
1425: and p_called_from = 'ERASE_SAVED_VERSION')
1426: or (p_called_from = 'RESTORE_VERSION'

Line 1924: WHERE id in (select id from OKC_OUTCOMES_B

1920:
1921: delete from OKC_OUTCOME_ARGUMENTS where DNZ_CHR_ID = p_chr_id;
1922:
1923: delete from OKC_OUTCOMES_TL
1924: WHERE id in (select id from OKC_OUTCOMES_B
1925: WHERE dnz_chr_id= p_chr_id);
1926:
1927: delete from OKC_OUTCOMES_B where DNZ_CHR_ID = p_chr_id;
1928:

Line 1927: delete from OKC_OUTCOMES_B where DNZ_CHR_ID = p_chr_id;

1923: delete from OKC_OUTCOMES_TL
1924: WHERE id in (select id from OKC_OUTCOMES_B
1925: WHERE dnz_chr_id= p_chr_id);
1926:
1927: delete from OKC_OUTCOMES_B where DNZ_CHR_ID = p_chr_id;
1928:
1929: delete from OKC_REACT_INTERVALS where DNZ_CHR_ID = p_chr_id;
1930:
1931: delete from OKC_RG_PARTY_ROLES where DNZ_CHR_ID = p_chr_id;