APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_LBR_MMBR_PRTE_F

Line 114: is select 1 from BEN_ELIG_LBR_MMBR_PRTE_F

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
115: where business_group_id = p_bg_id;
116:
117: cursor c29(p_bg_id NUMBER)
118: is select 1 from BEN_ELIG_PER_TYP_PRTE_F

Line 1586: -- Testing for values in BEN_ELIG_LBR_MMBR_PRTE_F

1582: --
1583: close c27;
1584:
1585: --
1586: -- Testing for values in BEN_ELIG_LBR_MMBR_PRTE_F
1587: --
1588: open c28(p_bg_id);
1589: --
1590: fetch c28 into l_temp;

Line 1594: fnd_message.set_token('TABLE_NAME','BEN_ELIG_LBR_MMBR_PRTE_F');

1590: fetch c28 into l_temp;
1591: if c28%found then
1592: close c28;
1593: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1594: fnd_message.set_token('TABLE_NAME','BEN_ELIG_LBR_MMBR_PRTE_F');
1595: fnd_message.raise_error;
1596: end if;
1597: --
1598: close c28;

Line 5658: delete from BEN_ELIG_LBR_MMBR_PRTE_F

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;
5660:
5661: delete from BEN_ELIG_PER_TYP_PRTE_F
5662: where business_group_id = p_bg_id;