APPS.BEN_ORG_DELETE dependencies on BEN_DPNT_CVRD_ANTHR_PL_CVG_F

Line 490: is select 1 from BEN_DPNT_CVRD_ANTHR_PL_CVG_F

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
491: where business_group_id = p_bg_id;
492:
493: cursor c124(p_bg_id NUMBER)
494: is select 1 from BEN_ELIG_DPNT_CVRD_OTHR_PL_F

Line 2996: -- Testing for values in BEN_DPNT_CVRD_ANTHR_PL_CVG_F

2992: --
2993: close c121;
2994:
2995: --
2996: -- Testing for values in BEN_DPNT_CVRD_ANTHR_PL_CVG_F
2997: --
2998: open c122(p_bg_id);
2999: --
3000: fetch c122 into l_temp;

Line 3004: fnd_message.set_token('TABLE_NAME','BEN_DPNT_CVRD_ANTHR_PL_CVG_F');

3000: fetch c122 into l_temp;
3001: if c122%found then
3002: close c122;
3003: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3004: fnd_message.set_token('TABLE_NAME','BEN_DPNT_CVRD_ANTHR_PL_CVG_F');
3005: fnd_message.raise_error;
3006: end if;
3007: --
3008: close c122;

Line 5940: delete from BEN_DPNT_CVRD_ANTHR_PL_CVG_F

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;
5942:
5943: delete from BEN_ELIG_DPNT_CVRD_OTHR_PL_F
5944: where business_group_id = p_bg_id;