APPS.BEN_ORG_DELETE dependencies on BEN_ENRT_PREM

Line 842: is select 1 from BEN_ENRT_PREM

838: is select 1 from BEN_PRTT_PREM_F
839: where business_group_id = p_bg_id;
840:
841: cursor c211(p_bg_id NUMBER)
842: is select 1 from BEN_ENRT_PREM
843: where business_group_id = p_bg_id;
844:
845: cursor c212(p_bg_id NUMBER)
846: is select 1 from BEN_PRTN_ELIGY_RL_F

Line 4316: -- Testing for values in BEN_ENRT_PREM

4312: --
4313: close c210;
4314:
4315: --
4316: -- Testing for values in BEN_ENRT_PREM
4317: --
4318: open c211(p_bg_id);
4319: --
4320: fetch c211 into l_temp;

Line 4324: fnd_message.set_token('TABLE_NAME','BEN_ENRT_PREM');

4320: fetch c211 into l_temp;
4321: if c211%found then
4322: close c211;
4323: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4324: fnd_message.set_token('TABLE_NAME','BEN_ENRT_PREM');
4325: fnd_message.raise_error;
4326: end if;
4327: --
4328: close c211;

Line 6204: delete from BEN_ENRT_PREM

6200:
6201: delete from BEN_PRTT_PREM_F
6202: where business_group_id = p_bg_id;
6203:
6204: delete from BEN_ENRT_PREM
6205: where business_group_id = p_bg_id;
6206:
6207: delete from BEN_PRTN_ELIGY_RL_F
6208: where business_group_id = p_bg_id;