APPS.BEN_ORG_DELETE dependencies on BEN_PL_REGN_F

Line 562: is select 1 from BEN_PL_REGN_F

558: is select 1 from BEN_PL_GD_OR_SVC_F
559: where business_group_id = p_bg_id;
560:
561: cursor c141(p_bg_id NUMBER)
562: is select 1 from BEN_PL_REGN_F
563: where business_group_id = p_bg_id;
564:
565: cursor c142(p_bg_id NUMBER)
566: is select 1 from BEN_PL_REGY_BOD_F

Line 3266: -- Testing for values in BEN_PL_REGN_F

3262: --
3263: close c140;
3264:
3265: --
3266: -- Testing for values in BEN_PL_REGN_F
3267: --
3268: open c141(p_bg_id);
3269: --
3270: fetch c141 into l_temp;

Line 3274: fnd_message.set_token('TABLE_NAME','BEN_PL_REGN_F');

3270: fetch c141 into l_temp;
3271: if c141%found then
3272: close c141;
3273: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3274: fnd_message.set_token('TABLE_NAME','BEN_PL_REGN_F');
3275: fnd_message.raise_error;
3276: end if;
3277: --
3278: close c141;

Line 5994: delete from BEN_PL_REGN_F

5990:
5991: delete from BEN_PL_GD_OR_SVC_F
5992: where business_group_id = p_bg_id;
5993:
5994: delete from BEN_PL_REGN_F
5995: where business_group_id = p_bg_id;
5996:
5997: delete from BEN_PL_REGY_BOD_F
5998: where business_group_id = p_bg_id;