APPS.BEN_ORG_DELETE dependencies on BEN_PER_TYP_RT_F

Line 666: is select 1 from BEN_PER_TYP_RT_F

662: is select 1 from BEN_PCT_FL_TM_RT_F
663: where business_group_id = p_bg_id;
664:
665: cursor c167(p_bg_id NUMBER)
666: is select 1 from BEN_PER_TYP_RT_F
667: where business_group_id = p_bg_id;
668:
669: cursor c168(p_bg_id NUMBER)
670: is select 1 from BEN_PPL_GRP_RT_F

Line 3656: -- Testing for values in BEN_PER_TYP_RT_F

3652: --
3653: close c166;
3654:
3655: --
3656: -- Testing for values in BEN_PER_TYP_RT_F
3657: --
3658: open c167(p_bg_id);
3659: --
3660: fetch c167 into l_temp;

Line 3664: fnd_message.set_token('TABLE_NAME','BEN_PER_TYP_RT_F');

3660: fetch c167 into l_temp;
3661: if c167%found then
3662: close c167;
3663: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3664: fnd_message.set_token('TABLE_NAME','BEN_PER_TYP_RT_F');
3665: fnd_message.raise_error;
3666: end if;
3667: --
3668: close c167;

Line 6072: delete from BEN_PER_TYP_RT_F

6068:
6069: delete from BEN_PCT_FL_TM_RT_F
6070: where business_group_id = p_bg_id;
6071:
6072: delete from BEN_PER_TYP_RT_F
6073: where business_group_id = p_bg_id;
6074:
6075: delete from BEN_PPL_GRP_RT_F
6076: where business_group_id = p_bg_id;