APPS.BEN_ORG_DELETE dependencies on BEN_EXT_FILE

Line 138: is select 1 from BEN_EXT_FILE

134: is select 1 from BEN_EXT_CRIT_PRFL
135: where business_group_id = p_bg_id;
136:
137: cursor c34(p_bg_id NUMBER)
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

Line 1676: -- Testing for values in BEN_EXT_FILE

1672: --
1673: close c33;
1674:
1675: --
1676: -- Testing for values in BEN_EXT_FILE
1677: --
1678: open c34(p_bg_id);
1679: --
1680: fetch c34 into l_temp;

Line 1684: fnd_message.set_token('TABLE_NAME','BEN_EXT_FILE');

1680: fetch c34 into l_temp;
1681: if c34%found then
1682: close c34;
1683: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1684: fnd_message.set_token('TABLE_NAME','BEN_EXT_FILE');
1685: fnd_message.raise_error;
1686: end if;
1687: --
1688: close c34;

Line 5676: delete from BEN_EXT_FILE

5672:
5673: delete from BEN_EXT_CRIT_PRFL
5674: where business_group_id = p_bg_id;
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;