APPS.BEN_ORG_DELETE dependencies on BEN_VRBL_MTCHG_RT_F

Line 702: is select 1 from BEN_VRBL_MTCHG_RT_F

698: is select 1 from BEN_TTL_PRTT_RT_F
699: where business_group_id = p_bg_id;
700:
701: cursor c176(p_bg_id NUMBER)
702: is select 1 from BEN_VRBL_MTCHG_RT_F
703: where business_group_id = p_bg_id;
704:
705: cursor c177(p_bg_id NUMBER)
706: is select 1 from BEN_VRBL_RT_PRFL_RL_F

Line 3791: -- Testing for values in BEN_VRBL_MTCHG_RT_F

3787: --
3788: close c175;
3789:
3790: --
3791: -- Testing for values in BEN_VRBL_MTCHG_RT_F
3792: --
3793: open c176(p_bg_id);
3794: --
3795: fetch c176 into l_temp;

Line 3799: fnd_message.set_token('TABLE_NAME','BEN_VRBL_MTCHG_RT_F');

3795: fetch c176 into l_temp;
3796: if c176%found then
3797: close c176;
3798: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3799: fnd_message.set_token('TABLE_NAME','BEN_VRBL_MTCHG_RT_F');
3800: fnd_message.raise_error;
3801: end if;
3802: --
3803: close c176;

Line 6099: delete from BEN_VRBL_MTCHG_RT_F

6095:
6096: delete from BEN_TTL_PRTT_RT_F
6097: where business_group_id = p_bg_id;
6098:
6099: delete from BEN_VRBL_MTCHG_RT_F
6100: where business_group_id = p_bg_id;
6101:
6102: delete from BEN_VRBL_RT_PRFL_RL_F
6103: where business_group_id = p_bg_id;