APPS.BEN_ORG_DELETE dependencies on BEN_PL_TYP_F

Line 154: is select 1 from BEN_PL_TYP_F

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
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

Line 1736: -- Testing for values in BEN_PL_TYP_F

1732: --
1733: close c37;
1734:
1735: --
1736: -- Testing for values in BEN_PL_TYP_F
1737: --
1738: open c38(p_bg_id);
1739: --
1740: fetch c38 into l_temp;

Line 1744: fnd_message.set_token('TABLE_NAME','BEN_PL_TYP_F');

1740: fetch c38 into l_temp;
1741: if c38%found then
1742: close c38;
1743: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1744: fnd_message.set_token('TABLE_NAME','BEN_PL_TYP_F');
1745: fnd_message.raise_error;
1746: end if;
1747: --
1748: close c38;

Line 5688: delete from BEN_PL_TYP_F

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;
5690:
5691: delete from BEN_POP_UP_MESSAGES
5692: where business_group_id = p_bg_id;