APPS.BEN_ORG_DELETE dependencies on BEN_LOS_RT_F

Line 654: is select 1 from BEN_LOS_RT_F

650: is select 1 from BEN_LGL_ENTY_RT_F
651: where business_group_id = p_bg_id;
652:
653: cursor c164(p_bg_id NUMBER)
654: is select 1 from BEN_LOS_RT_F
655: where business_group_id = p_bg_id;
656:
657: cursor c165(p_bg_id NUMBER)
658: is select 1 from BEN_ORG_UNIT_RT_F

Line 3611: -- Testing for values in BEN_LOS_RT_F

3607: --
3608: close c163;
3609:
3610: --
3611: -- Testing for values in BEN_LOS_RT_F
3612: --
3613: open c164(p_bg_id);
3614: --
3615: fetch c164 into l_temp;

Line 3619: fnd_message.set_token('TABLE_NAME','BEN_LOS_RT_F');

3615: fetch c164 into l_temp;
3616: if c164%found then
3617: close c164;
3618: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3619: fnd_message.set_token('TABLE_NAME','BEN_LOS_RT_F');
3620: fnd_message.raise_error;
3621: end if;
3622: --
3623: close c164;

Line 6063: delete from BEN_LOS_RT_F

6059:
6060: delete from BEN_LGL_ENTY_RT_F
6061: where business_group_id = p_bg_id;
6062:
6063: delete from BEN_LOS_RT_F
6064: where business_group_id = p_bg_id;
6065:
6066: delete from BEN_ORG_UNIT_RT_F
6067: where business_group_id = p_bg_id;