DBA Data[Home] [Help]

APPS.OKC_VERSION_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 1381: WHERE id in (select id from OKC_K_PARTY_ROLES_BH

1377: and (major_version > l_major_version
1378: or major_version = -1)));
1379:
1380: delete FROM OKC_K_PARTY_ROLES_TLH
1381: WHERE id in (select id from OKC_K_PARTY_ROLES_BH
1382: WHERE dnz_chr_id= p_chr_id)
1383: and ((MAJOR_VERSION = -1
1384: and p_called_from = 'ERASE_SAVED_VERSION')
1385: or (p_called_from = 'RESTORE_VERSION'

Line 1389: delete FROM OKC_K_PARTY_ROLES_BH

1385: or (p_called_from = 'RESTORE_VERSION'
1386: and (major_version > l_major_version
1387: or major_version = -1)));
1388: --
1389: delete FROM OKC_K_PARTY_ROLES_BH
1390: WHERE dnz_chr_id= p_chr_id
1391: and ((MAJOR_VERSION = -1
1392: and p_called_from = 'ERASE_SAVED_VERSION')
1393: or (p_called_from = 'RESTORE_VERSION'

Line 1914: WHERE id in (select id from OKC_K_PARTY_ROLES_B

1910:
1911: delete from OKC_K_LINES_B where DNZ_CHR_ID = p_chr_id;
1912:
1913: delete from OKC_K_PARTY_ROLES_TL
1914: WHERE id in (select id from OKC_K_PARTY_ROLES_B
1915: WHERE dnz_chr_id= p_chr_id);
1916:
1917: delete from OKC_K_PARTY_ROLES_B where DNZ_CHR_ID = p_chr_id;
1918:

Line 1917: delete from OKC_K_PARTY_ROLES_B where DNZ_CHR_ID = p_chr_id;

1913: delete from OKC_K_PARTY_ROLES_TL
1914: WHERE id in (select id from OKC_K_PARTY_ROLES_B
1915: WHERE dnz_chr_id= p_chr_id);
1916:
1917: delete from OKC_K_PARTY_ROLES_B where DNZ_CHR_ID = p_chr_id;
1918:
1919: delete from OKC_K_PROCESSES where CHR_ID = p_chr_id;
1920:
1921: delete from OKC_OUTCOME_ARGUMENTS where DNZ_CHR_ID = p_chr_id;