APPS.BEN_ORG_DELETE dependencies on BEN_PERD_TO_PROC

Line 1118: is select 1 from BEN_PERD_TO_PROC

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
1119: where business_group_id = p_bg_id;
1120:
1121: cursor c281(p_bg_id NUMBER)
1122: is select 1 from BEN_PYMT_SCHED_PY_FREQ

Line 5351: -- Testing for values in BEN_PERD_TO_PROC

5347: --
5348: close c279;
5349:
5350: --
5351: -- Testing for values in BEN_PERD_TO_PROC
5352: --
5353: open c280(p_bg_id);
5354: --
5355: fetch c280 into l_temp;

Line 5359: fnd_message.set_token('TABLE_NAME','BEN_PERD_TO_PROC');

5355: fetch c280 into l_temp;
5356: if c280%found then
5357: close c280;
5358: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5359: fnd_message.set_token('TABLE_NAME','BEN_PERD_TO_PROC');
5360: fnd_message.raise_error;
5361: end if;
5362: --
5363: close c280;

Line 6411: delete from BEN_PERD_TO_PROC

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;
6413:
6414: delete from BEN_PYMT_SCHED_PY_FREQ
6415: where business_group_id = p_bg_id;