APPS.BEN_ORG_DELETE dependencies on BEN_TTL_CVG_VOL_RT_F

Line 694: is select 1 from BEN_TTL_CVG_VOL_RT_F

690: is select 1 from BEN_TBCO_USE_RT_F
691: where business_group_id = p_bg_id;
692:
693: cursor c174(p_bg_id NUMBER)
694: is select 1 from BEN_TTL_CVG_VOL_RT_F
695: where business_group_id = p_bg_id;
696:
697: cursor c175(p_bg_id NUMBER)
698: is select 1 from BEN_TTL_PRTT_RT_F

Line 3761: -- Testing for values in BEN_TTL_CVG_VOL_RT_F

3757: --
3758: close c173;
3759:
3760: --
3761: -- Testing for values in BEN_TTL_CVG_VOL_RT_F
3762: --
3763: open c174(p_bg_id);
3764: --
3765: fetch c174 into l_temp;

Line 3769: fnd_message.set_token('TABLE_NAME','BEN_TTL_CVG_VOL_RT_F');

3765: fetch c174 into l_temp;
3766: if c174%found then
3767: close c174;
3768: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3769: fnd_message.set_token('TABLE_NAME','BEN_TTL_CVG_VOL_RT_F');
3770: fnd_message.raise_error;
3771: end if;
3772: --
3773: close c174;

Line 6093: delete from BEN_TTL_CVG_VOL_RT_F

6089:
6090: delete from BEN_TBCO_USE_RT_F
6091: where business_group_id = p_bg_id;
6092:
6093: delete from BEN_TTL_CVG_VOL_RT_F
6094: where business_group_id = p_bg_id;
6095:
6096: delete from BEN_TTL_PRTT_RT_F
6097: where business_group_id = p_bg_id;