APPS.BEN_ORG_DELETE dependencies on BEN_YR_PERD

Line 170: is select 1 from BEN_YR_PERD

166: is select 1 from BEN_VSTG_SCHED_F
167: where business_group_id = p_bg_id;
168:
169: cursor c42(p_bg_id NUMBER)
170: is select 1 from BEN_YR_PERD
171: where business_group_id = p_bg_id;
172:
173: cursor c43(p_bg_id NUMBER)
174: is select 1 from BEN_CMBN_AGE_LOS_FCTR

Line 1796: -- Testing for values in BEN_YR_PERD

1792: --
1793: close c41;
1794:
1795: --
1796: -- Testing for values in BEN_YR_PERD
1797: --
1798: open c42(p_bg_id);
1799: --
1800: fetch c42 into l_temp;

Line 1804: fnd_message.set_token('TABLE_NAME','BEN_YR_PERD');

1800: fetch c42 into l_temp;
1801: if c42%found then
1802: close c42;
1803: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1804: fnd_message.set_token('TABLE_NAME','BEN_YR_PERD');
1805: fnd_message.raise_error;
1806: end if;
1807: --
1808: close c42;

Line 5700: delete from BEN_YR_PERD

5696:
5697: delete from BEN_VSTG_SCHED_F
5698: where business_group_id = p_bg_id;
5699:
5700: delete from BEN_YR_PERD
5701: where business_group_id = p_bg_id;
5702:
5703: delete from BEN_CMBN_AGE_LOS_FCTR
5704: where business_group_id = p_bg_id;