APPS.BEN_ORG_DELETE dependencies on BEN_POP_UP_MESSAGES

Line 158: is select 1 from BEN_POP_UP_MESSAGES

154: is select 1 from BEN_PL_TYP_F
155: where business_group_id = p_bg_id;
156:
157: cursor c39(p_bg_id NUMBER)
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

Line 1751: -- Testing for values in BEN_POP_UP_MESSAGES

1747: --
1748: close c38;
1749:
1750: --
1751: -- Testing for values in BEN_POP_UP_MESSAGES
1752: --
1753: open c39(p_bg_id);
1754: --
1755: fetch c39 into l_temp;

Line 1759: fnd_message.set_token('TABLE_NAME','BEN_POP_UP_MESSAGES');

1755: fetch c39 into l_temp;
1756: if c39%found then
1757: close c39;
1758: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1759: fnd_message.set_token('TABLE_NAME','BEN_POP_UP_MESSAGES');
1760: fnd_message.raise_error;
1761: end if;
1762: --
1763: close c39;

Line 5691: delete from BEN_POP_UP_MESSAGES

5687:
5688: delete from BEN_PL_TYP_F
5689: where business_group_id = p_bg_id;
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;