APPS.BEN_ORG_DELETE dependencies on BEN_EXT_FLD

Line 142: is select 1 from BEN_EXT_FLD

138: is select 1 from BEN_EXT_FILE
139: where business_group_id = p_bg_id;
140:
141: cursor c35(p_bg_id NUMBER)
142: is select 1 from BEN_EXT_FLD
143: where business_group_id = p_bg_id;
144:
145: cursor c36(p_bg_id NUMBER)
146: is select 1 from BEN_EXT_RCD

Line 1691: -- Testing for values in BEN_EXT_FLD

1687: --
1688: close c34;
1689:
1690: --
1691: -- Testing for values in BEN_EXT_FLD
1692: --
1693: open c35(p_bg_id);
1694: --
1695: fetch c35 into l_temp;

Line 1699: fnd_message.set_token('TABLE_NAME','BEN_EXT_FLD');

1695: fetch c35 into l_temp;
1696: if c35%found then
1697: close c35;
1698: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1699: fnd_message.set_token('TABLE_NAME','BEN_EXT_FLD');
1700: fnd_message.raise_error;
1701: end if;
1702: --
1703: close c35;

Line 5679: delete from BEN_EXT_FLD

5675:
5676: delete from BEN_EXT_FILE
5677: where business_group_id = p_bg_id;
5678:
5679: delete from BEN_EXT_FLD
5680: where business_group_id = p_bg_id;
5681:
5682: delete from BEN_EXT_RCD
5683: where business_group_id = p_bg_id;