APPS.BEN_ORG_DELETE dependencies on BEN_ELIGY_PRFL_F

Line 50: is select 1 from BEN_ELIGY_PRFL_F

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
51: where business_group_id = p_bg_id;
52:
53: cursor c13(p_bg_id NUMBER)
54: is select 1 from BEN_ELIG_LVG_RSN_PRTE_F

Line 1346: -- Testing for values in BEN_ELIGY_PRFL_F

1342: --
1343: close c11;
1344:
1345: --
1346: -- Testing for values in BEN_ELIGY_PRFL_F
1347: --
1348: open c12(p_bg_id);
1349: --
1350: fetch c12 into l_temp;

Line 1354: fnd_message.set_token('TABLE_NAME','BEN_ELIGY_PRFL_F');

1350: fetch c12 into l_temp;
1351: if c12%found then
1352: close c12;
1353: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1354: fnd_message.set_token('TABLE_NAME','BEN_ELIGY_PRFL_F');
1355: fnd_message.raise_error;
1356: end if;
1357: --
1358: close c12;

Line 5610: delete from BEN_ELIGY_PRFL_F

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;
5612:
5613: delete from BEN_ELIG_LVG_RSN_PRTE_F
5614: where business_group_id = p_bg_id;