APPS.BEN_ORG_DELETE dependencies on BEN_BRGNG_UNIT_RT_F

Line 630: is select 1 from BEN_BRGNG_UNIT_RT_F

626: is select 1 from BEN_BNFT_RSTRN_CTFN_F
627: where business_group_id = p_bg_id;
628:
629: cursor c158(p_bg_id NUMBER)
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

Line 3521: -- Testing for values in BEN_BRGNG_UNIT_RT_F

3517: --
3518: close c157;
3519:
3520: --
3521: -- Testing for values in BEN_BRGNG_UNIT_RT_F
3522: --
3523: open c158(p_bg_id);
3524: --
3525: fetch c158 into l_temp;

Line 3529: fnd_message.set_token('TABLE_NAME','BEN_BRGNG_UNIT_RT_F');

3525: fetch c158 into l_temp;
3526: if c158%found then
3527: close c158;
3528: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3529: fnd_message.set_token('TABLE_NAME','BEN_BRGNG_UNIT_RT_F');
3530: fnd_message.raise_error;
3531: end if;
3532: --
3533: close c158;

Line 6045: delete from BEN_BRGNG_UNIT_RT_F

6041:
6042: delete from BEN_BNFT_RSTRN_CTFN_F
6043: where business_group_id = p_bg_id;
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;