APPS.BEN_ORG_DELETE dependencies on BEN_VSTG_SCHED_F

Line 166: is select 1 from BEN_VSTG_SCHED_F

162: is select 1 from BEN_PSTL_ZIP_RNG_F
163: where business_group_id = p_bg_id;
164:
165: cursor c41(p_bg_id NUMBER)
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

Line 1781: -- Testing for values in BEN_VSTG_SCHED_F

1777: --
1778: close c40;
1779:
1780: --
1781: -- Testing for values in BEN_VSTG_SCHED_F
1782: --
1783: open c41(p_bg_id);
1784: --
1785: fetch c41 into l_temp;

Line 1789: fnd_message.set_token('TABLE_NAME','BEN_VSTG_SCHED_F');

1785: fetch c41 into l_temp;
1786: if c41%found then
1787: close c41;
1788: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1789: fnd_message.set_token('TABLE_NAME','BEN_VSTG_SCHED_F');
1790: fnd_message.raise_error;
1791: end if;
1792: --
1793: close c41;

Line 5697: delete from BEN_VSTG_SCHED_F

5693:
5694: delete from BEN_PSTL_ZIP_RNG_F
5695: where business_group_id = p_bg_id;
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;