APPS.BEN_ORG_DELETE dependencies on BEN_ACTY_RT_DED_SCHED_F

Line 1114: is select 1 from BEN_ACTY_RT_DED_SCHED_F

1110: is select 1 from BEN_DED_SCHED_PY_FREQ
1111: where business_group_id = p_bg_id;
1112:
1113: cursor c279(p_bg_id NUMBER)
1114: is select 1 from BEN_ACTY_RT_DED_SCHED_F
1115: where business_group_id = p_bg_id;
1116:
1117: cursor c280(p_bg_id NUMBER)
1118: is select 1 from BEN_PERD_TO_PROC

Line 5336: -- Testing for values in BEN_ACTY_RT_DED_SCHED_F

5332: --
5333: close c278;
5334:
5335: --
5336: -- Testing for values in BEN_ACTY_RT_DED_SCHED_F
5337: --
5338: open c279(p_bg_id);
5339: --
5340: fetch c279 into l_temp;

Line 5344: fnd_message.set_token('TABLE_NAME','BEN_ACTY_RT_DED_SCHED_F');

5340: fetch c279 into l_temp;
5341: if c279%found then
5342: close c279;
5343: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5344: fnd_message.set_token('TABLE_NAME','BEN_ACTY_RT_DED_SCHED_F');
5345: fnd_message.raise_error;
5346: end if;
5347: --
5348: close c279;

Line 6408: delete from BEN_ACTY_RT_DED_SCHED_F

6404:
6405: delete from BEN_DED_SCHED_PY_FREQ
6406: where business_group_id = p_bg_id;
6407:
6408: delete from BEN_ACTY_RT_DED_SCHED_F
6409: where business_group_id = p_bg_id;
6410:
6411: delete from BEN_PERD_TO_PROC
6412: where business_group_id = p_bg_id;