APPS.BEN_ORG_DELETE dependencies on BEN_PTIP_F

Line 486: is select 1 from BEN_PTIP_F

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
487: where business_group_id = p_bg_id;
488:
489: cursor c122(p_bg_id NUMBER)
490: is select 1 from BEN_DPNT_CVRD_ANTHR_PL_CVG_F

Line 2981: -- Testing for values in BEN_PTIP_F

2977: --
2978: close c120;
2979:
2980: --
2981: -- Testing for values in BEN_PTIP_F
2982: --
2983: open c121(p_bg_id);
2984: --
2985: fetch c121 into l_temp;

Line 2989: fnd_message.set_token('TABLE_NAME','BEN_PTIP_F');

2985: fetch c121 into l_temp;
2986: if c121%found then
2987: close c121;
2988: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2989: fnd_message.set_token('TABLE_NAME','BEN_PTIP_F');
2990: fnd_message.raise_error;
2991: end if;
2992: --
2993: close c121;

Line 5937: delete from BEN_PTIP_F

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;
5939:
5940: delete from BEN_DPNT_CVRD_ANTHR_PL_CVG_F
5941: where business_group_id = p_bg_id;