APPS.BEN_ORG_DELETE dependencies on BEN_LOS_FCTR

Line 46: is select 1 from BEN_LOS_FCTR

42: is select 1 from BEN_GD_OR_SVC_TYP
43: where business_group_id = p_bg_id;
44:
45: cursor c11(p_bg_id NUMBER)
46: is select 1 from BEN_LOS_FCTR
47: where business_group_id = p_bg_id;
48:
49: cursor c12(p_bg_id NUMBER)
50: is select 1 from BEN_ELIGY_PRFL_F

Line 1331: -- Testing for values in BEN_LOS_FCTR

1327: --
1328: close c10;
1329:
1330: --
1331: -- Testing for values in BEN_LOS_FCTR
1332: --
1333: open c11(p_bg_id);
1334: --
1335: fetch c11 into l_temp;

Line 1339: fnd_message.set_token('TABLE_NAME','BEN_LOS_FCTR');

1335: fetch c11 into l_temp;
1336: if c11%found then
1337: close c11;
1338: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1339: fnd_message.set_token('TABLE_NAME','BEN_LOS_FCTR');
1340: fnd_message.raise_error;
1341: end if;
1342: --
1343: close c11;

Line 5607: delete from BEN_LOS_FCTR

5603:
5604: delete from BEN_GD_OR_SVC_TYP
5605: where business_group_id = p_bg_id;
5606:
5607: delete from BEN_LOS_FCTR
5608: where business_group_id = p_bg_id;
5609:
5610: delete from BEN_ELIGY_PRFL_F
5611: where business_group_id = p_bg_id;