APPS.BEN_ORG_DELETE dependencies on BEN_EXT_DFN

Line 218: is select 1 from BEN_EXT_DFN

214: is select 1 from BEN_EXT_CRIT_TYP
215: where business_group_id = p_bg_id;
216:
217: cursor c54(p_bg_id NUMBER)
218: is select 1 from BEN_EXT_DFN
219: where business_group_id = p_bg_id;
220:
221: cursor c55(p_bg_id NUMBER)
222: is select 1 from BEN_ORG_UNIT_PRDCT_F

Line 1976: -- Testing for values in BEN_EXT_DFN

1972: --
1973: close c53;
1974:
1975: --
1976: -- Testing for values in BEN_EXT_DFN
1977: --
1978: open c54(p_bg_id);
1979: --
1980: fetch c54 into l_temp;

Line 1984: fnd_message.set_token('TABLE_NAME','BEN_EXT_DFN');

1980: fetch c54 into l_temp;
1981: if c54%found then
1982: close c54;
1983: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1984: fnd_message.set_token('TABLE_NAME','BEN_EXT_DFN');
1985: fnd_message.raise_error;
1986: end if;
1987: --
1988: close c54;

Line 5736: delete from BEN_EXT_DFN

5732:
5733: delete from BEN_EXT_CRIT_TYP
5734: where business_group_id = p_bg_id;
5735:
5736: delete from BEN_EXT_DFN
5737: where business_group_id = p_bg_id;
5738:
5739: delete from BEN_ORG_UNIT_PRDCT_F
5740: where business_group_id = p_bg_id;