APPS.BEN_ORG_DELETE dependencies on BEN_DSGN_RQMT_RLSHP_TYP

Line 642: is select 1 from BEN_DSGN_RQMT_RLSHP_TYP

638: is select 1 from BEN_COMP_LVL_RT_F
639: where business_group_id = p_bg_id;
640:
641: cursor c161(p_bg_id NUMBER)
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

Line 3566: -- Testing for values in BEN_DSGN_RQMT_RLSHP_TYP

3562: --
3563: close c160;
3564:
3565: --
3566: -- Testing for values in BEN_DSGN_RQMT_RLSHP_TYP
3567: --
3568: open c161(p_bg_id);
3569: --
3570: fetch c161 into l_temp;

Line 3574: fnd_message.set_token('TABLE_NAME','BEN_DSGN_RQMT_RLSHP_TYP');

3570: fetch c161 into l_temp;
3571: if c161%found then
3572: close c161;
3573: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3574: fnd_message.set_token('TABLE_NAME','BEN_DSGN_RQMT_RLSHP_TYP');
3575: fnd_message.raise_error;
3576: end if;
3577: --
3578: close c161;

Line 6054: delete from BEN_DSGN_RQMT_RLSHP_TYP

6050:
6051: delete from BEN_COMP_LVL_RT_F
6052: where business_group_id = p_bg_id;
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;