APPS.BEN_ORG_DELETE dependencies on BEN_PRTT_RT_VAL

Line 1130: is select 1 from BEN_PRTT_RT_VAL

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
1131: where business_group_id = p_bg_id;
1132:
1133: cursor c284(p_bg_id NUMBER)
1134: is select 1 from BEN_PRTT_VSTG_F

Line 5396: -- Testing for values in BEN_PRTT_RT_VAL

5392: --
5393: close c282;
5394:
5395: --
5396: -- Testing for values in BEN_PRTT_RT_VAL
5397: --
5398: open c283(p_bg_id);
5399: --
5400: fetch c283 into l_temp;

Line 5404: fnd_message.set_token('TABLE_NAME','BEN_PRTT_RT_VAL');

5400: fetch c283 into l_temp;
5401: if c283%found then
5402: close c283;
5403: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5404: fnd_message.set_token('TABLE_NAME','BEN_PRTT_RT_VAL');
5405: fnd_message.raise_error;
5406: end if;
5407: --
5408: close c283;

Line 6420: delete from BEN_PRTT_RT_VAL

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;
6422:
6423: delete from BEN_PRTT_VSTG_F
6424: where business_group_id = p_bg_id;