APPS.BEN_ORG_DELETE dependencies on BEN_PL_F

Line 482: is select 1 from BEN_PL_F

478: is select 1 from BEN_PLIP_F
479: where business_group_id = p_bg_id;
480:
481: cursor c120(p_bg_id NUMBER)
482: is select 1 from BEN_PL_F
483: where business_group_id = p_bg_id;
484:
485: cursor c121(p_bg_id NUMBER)
486: is select 1 from BEN_PTIP_F

Line 2966: -- Testing for values in BEN_PL_F

2962: --
2963: close c119;
2964:
2965: --
2966: -- Testing for values in BEN_PL_F
2967: --
2968: open c120(p_bg_id);
2969: --
2970: fetch c120 into l_temp;

Line 2974: fnd_message.set_token('TABLE_NAME','BEN_PL_F');

2970: fetch c120 into l_temp;
2971: if c120%found then
2972: close c120;
2973: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2974: fnd_message.set_token('TABLE_NAME','BEN_PL_F');
2975: fnd_message.raise_error;
2976: end if;
2977: --
2978: close c120;

Line 5934: delete from BEN_PL_F

5930:
5931: delete from BEN_PLIP_F
5932: where business_group_id = p_bg_id;
5933:
5934: delete from BEN_PL_F
5935: where business_group_id = p_bg_id;
5936:
5937: delete from BEN_PTIP_F
5938: where business_group_id = p_bg_id;