APPS.BEN_ORG_DELETE dependencies on BEN_PSTL_ZIP_RNG_F

Line 162: is select 1 from BEN_PSTL_ZIP_RNG_F

158: is select 1 from BEN_POP_UP_MESSAGES
159: where business_group_id = p_bg_id;
160:
161: cursor c40(p_bg_id NUMBER)
162: is select 1 from BEN_PSTL_ZIP_RNG_F
163: where business_group_id = p_bg_id;
164:
165: cursor c41(p_bg_id NUMBER)
166: is select 1 from BEN_VSTG_SCHED_F

Line 1766: -- Testing for values in BEN_PSTL_ZIP_RNG_F

1762: --
1763: close c39;
1764:
1765: --
1766: -- Testing for values in BEN_PSTL_ZIP_RNG_F
1767: --
1768: open c40(p_bg_id);
1769: --
1770: fetch c40 into l_temp;

Line 1774: fnd_message.set_token('TABLE_NAME','BEN_PSTL_ZIP_RNG_F');

1770: fetch c40 into l_temp;
1771: if c40%found then
1772: close c40;
1773: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1774: fnd_message.set_token('TABLE_NAME','BEN_PSTL_ZIP_RNG_F');
1775: fnd_message.raise_error;
1776: end if;
1777: --
1778: close c40;

Line 5694: delete from BEN_PSTL_ZIP_RNG_F

5690:
5691: delete from BEN_POP_UP_MESSAGES
5692: where business_group_id = p_bg_id;
5693:
5694: delete from BEN_PSTL_ZIP_RNG_F
5695: where business_group_id = p_bg_id;
5696:
5697: delete from BEN_VSTG_SCHED_F
5698: where business_group_id = p_bg_id;