APPS.BEN_ORG_DELETE dependencies on BEN_CBR_QUALD_BNF

Line 6: is select 1 from BEN_CBR_QUALD_BNF

2: /* $Header: bebgdchk.pkb 120.0 2005/05/28 00:41:10 appldev noship $ */
3: procedure perform_ri_check(p_bg_id in number) is
4:
5: cursor c1(p_bg_id NUMBER)
6: is select 1 from BEN_CBR_QUALD_BNF
7: where business_group_id = p_bg_id;
8:
9: --cursor c2(p_bg_id NUMBER)
10: --is select 1 from BEN_HLTH_CVG_SLCTD_RT_F

Line 1181: -- Testing for values in BEN_CBR_QUALD_BNF

1177:
1178: l_temp VARCHAR2(2);
1179: BEGIN
1180: --
1181: -- Testing for values in BEN_CBR_QUALD_BNF
1182: --
1183: open c1(p_bg_id);
1184: --
1185: fetch c1 into l_temp;

Line 1189: fnd_message.set_token('TABLE_NAME','BEN_CBR_QUALD_BNF');

1185: fetch c1 into l_temp;
1186: if c1%found then
1187: close c1;
1188: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1189: fnd_message.set_token('TABLE_NAME','BEN_CBR_QUALD_BNF');
1190: fnd_message.raise_error;
1191: end if;
1192: --
1193: close c1;

Line 5577: delete from BEN_CBR_QUALD_BNF

5573: end perform_ri_check;
5574:
5575: procedure delete_below_bg(p_bg_id NUMBER) is
5576: BEGIN
5577: delete from BEN_CBR_QUALD_BNF
5578: where business_group_id = p_bg_id;
5579:
5580: --delete from BEN_HLTH_CVG_SLCTD_RT_F
5581: --where business_group_id = p_bg_id;