APPS.OKC_VERSION_PVT dependencies on OKC_RULE_GROUPS_B

Line 1447: WHERE id in (select id from OKC_RULE_GROUPS_BH

1443: and (major_version > l_major_version
1444: or major_version = -1)));
1445: --
1446: delete FROM OKC_RULE_GROUPS_TLH
1447: WHERE id in (select id from OKC_RULE_GROUPS_BH
1448: WHERE dnz_chr_id= p_chr_id)
1449: and ((MAJOR_VERSION = -1
1450: and p_called_from = 'ERASE_SAVED_VERSION')
1451: or (p_called_from = 'RESTORE_VERSION'

Line 1455: delete FROM OKC_RULE_GROUPS_BH

1451: or (p_called_from = 'RESTORE_VERSION'
1452: and (major_version > l_major_version
1453: or major_version = -1)));
1454: --
1455: delete FROM OKC_RULE_GROUPS_BH
1456: WHERE dnz_chr_id= p_chr_id
1457: and ((MAJOR_VERSION = -1
1458: and p_called_from = 'ERASE_SAVED_VERSION')
1459: or (p_called_from = 'RESTORE_VERSION'

Line 1934: WHERE id in (select id from OKC_RULE_GROUPS_B

1930:
1931: delete from OKC_RG_PARTY_ROLES where DNZ_CHR_ID = p_chr_id;
1932:
1933: delete from OKC_RULE_GROUPS_TL
1934: WHERE id in (select id from OKC_RULE_GROUPS_B
1935: WHERE dnz_chr_id= p_chr_id);
1936:
1937: delete from OKC_RULE_GROUPS_B where DNZ_CHR_ID = p_chr_id;
1938: --Bug 3055393

Line 1937: delete from OKC_RULE_GROUPS_B where DNZ_CHR_ID = p_chr_id;

1933: delete from OKC_RULE_GROUPS_TL
1934: WHERE id in (select id from OKC_RULE_GROUPS_B
1935: WHERE dnz_chr_id= p_chr_id);
1936:
1937: delete from OKC_RULE_GROUPS_B where DNZ_CHR_ID = p_chr_id;
1938: --Bug 3055393
1939: /*
1940: delete from OKC_RULES_TL
1941: WHERE id in (select id from OKC_RULES_B