APPS.BEN_ORG_DELETE dependencies on BEN_PL_GD_OR_SVC_F

Line 558: is select 1 from BEN_PL_GD_OR_SVC_F

554: is select 1 from BEN_PL_DPNT_CVG_CTFN_F
555: where business_group_id = p_bg_id;
556:
557: cursor c140(p_bg_id NUMBER)
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

Line 3251: -- Testing for values in BEN_PL_GD_OR_SVC_F

3247: --
3248: close c139;
3249:
3250: --
3251: -- Testing for values in BEN_PL_GD_OR_SVC_F
3252: --
3253: open c140(p_bg_id);
3254: --
3255: fetch c140 into l_temp;

Line 3259: fnd_message.set_token('TABLE_NAME','BEN_PL_GD_OR_SVC_F');

3255: fetch c140 into l_temp;
3256: if c140%found then
3257: close c140;
3258: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3259: fnd_message.set_token('TABLE_NAME','BEN_PL_GD_OR_SVC_F');
3260: fnd_message.raise_error;
3261: end if;
3262: --
3263: close c140;

Line 5991: delete from BEN_PL_GD_OR_SVC_F

5987:
5988: delete from BEN_PL_DPNT_CVG_CTFN_F
5989: where business_group_id = p_bg_id;
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;