APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_HRLY_SLRD_PRTE_F

Line 110: is select 1 from BEN_ELIG_HRLY_SLRD_PRTE_F

106: is select 1 from BEN_ELIG_FL_TM_PT_TM_PRTE_F
107: where business_group_id = p_bg_id;
108:
109: cursor c27(p_bg_id NUMBER)
110: is select 1 from BEN_ELIG_HRLY_SLRD_PRTE_F
111: where business_group_id = p_bg_id;
112:
113: cursor c28(p_bg_id NUMBER)
114: is select 1 from BEN_ELIG_LBR_MMBR_PRTE_F

Line 1571: -- Testing for values in BEN_ELIG_HRLY_SLRD_PRTE_F

1567: --
1568: close c26;
1569:
1570: --
1571: -- Testing for values in BEN_ELIG_HRLY_SLRD_PRTE_F
1572: --
1573: open c27(p_bg_id);
1574: --
1575: fetch c27 into l_temp;

Line 1579: fnd_message.set_token('TABLE_NAME','BEN_ELIG_HRLY_SLRD_PRTE_F');

1575: fetch c27 into l_temp;
1576: if c27%found then
1577: close c27;
1578: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1579: fnd_message.set_token('TABLE_NAME','BEN_ELIG_HRLY_SLRD_PRTE_F');
1580: fnd_message.raise_error;
1581: end if;
1582: --
1583: close c27;

Line 5655: delete from BEN_ELIG_HRLY_SLRD_PRTE_F

5651:
5652: delete from BEN_ELIG_FL_TM_PT_TM_PRTE_F
5653: where business_group_id = p_bg_id;
5654:
5655: delete from BEN_ELIG_HRLY_SLRD_PRTE_F
5656: where business_group_id = p_bg_id;
5657:
5658: delete from BEN_ELIG_LBR_MMBR_PRTE_F
5659: where business_group_id = p_bg_id;