APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_LVG_RSN_PRTE_F

Line 54: is select 1 from BEN_ELIG_LVG_RSN_PRTE_F

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
55: where business_group_id = p_bg_id;
56:
57: cursor c14(p_bg_id NUMBER)
58: is select 1 from BEN_ELIG_NO_OTHR_CVG_PRTE_F

Line 1361: -- Testing for values in BEN_ELIG_LVG_RSN_PRTE_F

1357: --
1358: close c12;
1359:
1360: --
1361: -- Testing for values in BEN_ELIG_LVG_RSN_PRTE_F
1362: --
1363: open c13(p_bg_id);
1364: --
1365: fetch c13 into l_temp;

Line 1369: fnd_message.set_token('TABLE_NAME','BEN_ELIG_LVG_RSN_PRTE_F');

1365: fetch c13 into l_temp;
1366: if c13%found then
1367: close c13;
1368: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1369: fnd_message.set_token('TABLE_NAME','BEN_ELIG_LVG_RSN_PRTE_F');
1370: fnd_message.raise_error;
1371: end if;
1372: --
1373: close c13;

Line 5613: delete from BEN_ELIG_LVG_RSN_PRTE_F

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;
5615:
5616: delete from BEN_ELIG_NO_OTHR_CVG_PRTE_F
5617: where business_group_id = p_bg_id;