APPS.BEN_ORG_DELETE dependencies on BEN_ENRT_PERD_FOR_PL_F

Line 646: is select 1 from BEN_ENRT_PERD_FOR_PL_F

642: is select 1 from BEN_DSGN_RQMT_RLSHP_TYP
643: where business_group_id = p_bg_id;
644:
645: cursor c162(p_bg_id NUMBER)
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

Line 3581: -- Testing for values in BEN_ENRT_PERD_FOR_PL_F

3577: --
3578: close c161;
3579:
3580: --
3581: -- Testing for values in BEN_ENRT_PERD_FOR_PL_F
3582: --
3583: open c162(p_bg_id);
3584: --
3585: fetch c162 into l_temp;

Line 3589: fnd_message.set_token('TABLE_NAME','BEN_ENRT_PERD_FOR_PL_F');

3585: fetch c162 into l_temp;
3586: if c162%found then
3587: close c162;
3588: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3589: fnd_message.set_token('TABLE_NAME','BEN_ENRT_PERD_FOR_PL_F');
3590: fnd_message.raise_error;
3591: end if;
3592: --
3593: close c162;

Line 6057: delete from BEN_ENRT_PERD_FOR_PL_F

6053:
6054: delete from BEN_DSGN_RQMT_RLSHP_TYP
6055: where business_group_id = p_bg_id;
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;