APPS.BEN_ORG_DELETE dependencies on BEN_CMBN_AGE_LOS_RT_F

Line 634: is select 1 from BEN_CMBN_AGE_LOS_RT_F

630: is select 1 from BEN_BRGNG_UNIT_RT_F
631: where business_group_id = p_bg_id;
632:
633: cursor c159(p_bg_id NUMBER)
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

Line 3536: -- Testing for values in BEN_CMBN_AGE_LOS_RT_F

3532: --
3533: close c158;
3534:
3535: --
3536: -- Testing for values in BEN_CMBN_AGE_LOS_RT_F
3537: --
3538: open c159(p_bg_id);
3539: --
3540: fetch c159 into l_temp;

Line 3544: fnd_message.set_token('TABLE_NAME','BEN_CMBN_AGE_LOS_RT_F');

3540: fetch c159 into l_temp;
3541: if c159%found then
3542: close c159;
3543: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3544: fnd_message.set_token('TABLE_NAME','BEN_CMBN_AGE_LOS_RT_F');
3545: fnd_message.raise_error;
3546: end if;
3547: --
3548: close c159;

Line 6048: delete from BEN_CMBN_AGE_LOS_RT_F

6044:
6045: delete from BEN_BRGNG_UNIT_RT_F
6046: where business_group_id = p_bg_id;
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;