APPS.BEN_ORG_DELETE dependencies on BEN_PIN

Line 150: is select 1 from BEN_PIN

146: is select 1 from BEN_EXT_RCD
147: where business_group_id = p_bg_id;
148:
149: cursor c37(p_bg_id NUMBER)
150: is select 1 from BEN_PIN
151: where business_group_id = p_bg_id;
152:
153: cursor c38(p_bg_id NUMBER)
154: is select 1 from BEN_PL_TYP_F

Line 1721: -- Testing for values in BEN_PIN

1717: --
1718: close c36;
1719:
1720: --
1721: -- Testing for values in BEN_PIN
1722: --
1723: open c37(p_bg_id);
1724: --
1725: fetch c37 into l_temp;

Line 1729: fnd_message.set_token('TABLE_NAME','BEN_PIN');

1725: fetch c37 into l_temp;
1726: if c37%found then
1727: close c37;
1728: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1729: fnd_message.set_token('TABLE_NAME','BEN_PIN');
1730: fnd_message.raise_error;
1731: end if;
1732: --
1733: close c37;

Line 5685: delete from BEN_PIN

5681:
5682: delete from BEN_EXT_RCD
5683: where business_group_id = p_bg_id;
5684:
5685: delete from BEN_PIN
5686: where business_group_id = p_bg_id;
5687:
5688: delete from BEN_PL_TYP_F
5689: where business_group_id = p_bg_id;