APPS.BEN_ORG_DELETE dependencies on BEN_COMP_LVL_ACTY_RT_F

Line 1090: is select 1 from BEN_COMP_LVL_ACTY_RT_F

1086: is select 1 from BEN_BNFT_PRVDD_LDGR_F
1087: where business_group_id = p_bg_id;
1088:
1089: cursor c273(p_bg_id NUMBER)
1090: is select 1 from BEN_COMP_LVL_ACTY_RT_F
1091: where business_group_id = p_bg_id;
1092:
1093: cursor c274(p_bg_id NUMBER)
1094: is select 1 from BEN_MTCHG_RT_F

Line 5246: -- Testing for values in BEN_COMP_LVL_ACTY_RT_F

5242: --
5243: close c272;
5244:
5245: --
5246: -- Testing for values in BEN_COMP_LVL_ACTY_RT_F
5247: --
5248: open c273(p_bg_id);
5249: --
5250: fetch c273 into l_temp;

Line 5254: fnd_message.set_token('TABLE_NAME','BEN_COMP_LVL_ACTY_RT_F');

5250: fetch c273 into l_temp;
5251: if c273%found then
5252: close c273;
5253: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5254: fnd_message.set_token('TABLE_NAME','BEN_COMP_LVL_ACTY_RT_F');
5255: fnd_message.raise_error;
5256: end if;
5257: --
5258: close c273;

Line 6390: delete from BEN_COMP_LVL_ACTY_RT_F

6386:
6387: delete from BEN_BNFT_PRVDD_LDGR_F
6388: where business_group_id = p_bg_id;
6389:
6390: delete from BEN_COMP_LVL_ACTY_RT_F
6391: where business_group_id = p_bg_id;
6392:
6393: delete from BEN_MTCHG_RT_F
6394: where business_group_id = p_bg_id;