APPS.BEN_ORG_DELETE dependencies on BEN_TTL_PRTT_RT_F

Line 698: is select 1 from BEN_TTL_PRTT_RT_F

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
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

Line 3776: -- Testing for values in BEN_TTL_PRTT_RT_F

3772: --
3773: close c174;
3774:
3775: --
3776: -- Testing for values in BEN_TTL_PRTT_RT_F
3777: --
3778: open c175(p_bg_id);
3779: --
3780: fetch c175 into l_temp;

Line 3784: fnd_message.set_token('TABLE_NAME','BEN_TTL_PRTT_RT_F');

3780: fetch c175 into l_temp;
3781: if c175%found then
3782: close c175;
3783: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3784: fnd_message.set_token('TABLE_NAME','BEN_TTL_PRTT_RT_F');
3785: fnd_message.raise_error;
3786: end if;
3787: --
3788: close c175;

Line 6096: delete from BEN_TTL_PRTT_RT_F

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;
6098:
6099: delete from BEN_VRBL_MTCHG_RT_F
6100: where business_group_id = p_bg_id;