APPS.BEN_ORG_DELETE dependencies on BEN_PYMT_SCHED_PY_FREQ

Line 1122: is select 1 from BEN_PYMT_SCHED_PY_FREQ

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
1123: where business_group_id = p_bg_id;
1124:
1125: cursor c282(p_bg_id NUMBER)
1126: is select 1 from BEN_PRTT_ASSOCD_INSTN_F

Line 5366: -- Testing for values in BEN_PYMT_SCHED_PY_FREQ

5362: --
5363: close c280;
5364:
5365: --
5366: -- Testing for values in BEN_PYMT_SCHED_PY_FREQ
5367: --
5368: open c281(p_bg_id);
5369: --
5370: fetch c281 into l_temp;

Line 5374: fnd_message.set_token('TABLE_NAME','BEN_PYMT_SCHED_PY_FREQ');

5370: fetch c281 into l_temp;
5371: if c281%found then
5372: close c281;
5373: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5374: fnd_message.set_token('TABLE_NAME','BEN_PYMT_SCHED_PY_FREQ');
5375: fnd_message.raise_error;
5376: end if;
5377: --
5378: close c281;

Line 6414: delete from BEN_PYMT_SCHED_PY_FREQ

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;
6416:
6417: delete from BEN_PRTT_ASSOCD_INSTN_F
6418: where business_group_id = p_bg_id;