APPS.BEN_ORG_DELETE dependencies on BEN_LGL_ENTY_RT_F

Line 650: is select 1 from BEN_LGL_ENTY_RT_F

646: is select 1 from BEN_ENRT_PERD_FOR_PL_F
647: where business_group_id = p_bg_id;
648:
649: cursor c163(p_bg_id NUMBER)
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

Line 3596: -- Testing for values in BEN_LGL_ENTY_RT_F

3592: --
3593: close c162;
3594:
3595: --
3596: -- Testing for values in BEN_LGL_ENTY_RT_F
3597: --
3598: open c163(p_bg_id);
3599: --
3600: fetch c163 into l_temp;

Line 3604: fnd_message.set_token('TABLE_NAME','BEN_LGL_ENTY_RT_F');

3600: fetch c163 into l_temp;
3601: if c163%found then
3602: close c163;
3603: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3604: fnd_message.set_token('TABLE_NAME','BEN_LGL_ENTY_RT_F');
3605: fnd_message.raise_error;
3606: end if;
3607: --
3608: close c163;

Line 6060: delete from BEN_LGL_ENTY_RT_F

6056:
6057: delete from BEN_ENRT_PERD_FOR_PL_F
6058: where business_group_id = p_bg_id;
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;

Line 6489: delete from BEN_LGL_ENTY_RT_F

6485:
6486: delete from BEN_POPL_ORG_F
6487: where organization_id = p_org_id;
6488:
6489: delete from BEN_LGL_ENTY_RT_F
6490: where organization_id = p_org_id;
6491:
6492: delete from BEN_ORG_UNIT_RT_F
6493: where organization_id = p_org_id;