APPS.BEN_ORG_DELETE dependencies on BEN_COMP_LVL_RT_F

Line 638: is select 1 from BEN_COMP_LVL_RT_F

634: is select 1 from BEN_CMBN_AGE_LOS_RT_F
635: where business_group_id = p_bg_id;
636:
637: cursor c160(p_bg_id NUMBER)
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

Line 3551: -- Testing for values in BEN_COMP_LVL_RT_F

3547: --
3548: close c159;
3549:
3550: --
3551: -- Testing for values in BEN_COMP_LVL_RT_F
3552: --
3553: open c160(p_bg_id);
3554: --
3555: fetch c160 into l_temp;

Line 3559: fnd_message.set_token('TABLE_NAME','BEN_COMP_LVL_RT_F');

3555: fetch c160 into l_temp;
3556: if c160%found then
3557: close c160;
3558: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3559: fnd_message.set_token('TABLE_NAME','BEN_COMP_LVL_RT_F');
3560: fnd_message.raise_error;
3561: end if;
3562: --
3563: close c160;

Line 6051: delete from BEN_COMP_LVL_RT_F

6047:
6048: delete from BEN_CMBN_AGE_LOS_RT_F
6049: where business_group_id = p_bg_id;
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;