APPS.BEN_ORG_DELETE dependencies on BEN_PRTT_ASSOCD_INSTN_F

Line 1126: is select 1 from BEN_PRTT_ASSOCD_INSTN_F

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
1127: where business_group_id = p_bg_id;
1128:
1129: cursor c283(p_bg_id NUMBER)
1130: is select 1 from BEN_PRTT_RT_VAL

Line 5381: -- Testing for values in BEN_PRTT_ASSOCD_INSTN_F

5377: --
5378: close c281;
5379:
5380: --
5381: -- Testing for values in BEN_PRTT_ASSOCD_INSTN_F
5382: --
5383: open c282(p_bg_id);
5384: --
5385: fetch c282 into l_temp;

Line 5389: fnd_message.set_token('TABLE_NAME','BEN_PRTT_ASSOCD_INSTN_F');

5385: fetch c282 into l_temp;
5386: if c282%found then
5387: close c282;
5388: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5389: fnd_message.set_token('TABLE_NAME','BEN_PRTT_ASSOCD_INSTN_F');
5390: fnd_message.raise_error;
5391: end if;
5392: --
5393: close c282;

Line 6417: delete from BEN_PRTT_ASSOCD_INSTN_F

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;
6419:
6420: delete from BEN_PRTT_RT_VAL
6421: where business_group_id = p_bg_id;