APPS.BEN_ORG_DELETE dependencies on BEN_ENRT_ENRLD_ANTHR_PL_F

Line 502: is select 1 from BEN_ENRT_ENRLD_ANTHR_PL_F

498: is select 1 from BEN_ELIG_ENRLD_ANTHR_PL_F
499: where business_group_id = p_bg_id;
500:
501: cursor c126(p_bg_id NUMBER)
502: is select 1 from BEN_ENRT_ENRLD_ANTHR_PL_F
503: where business_group_id = p_bg_id;
504:
505: cursor c127(p_bg_id NUMBER)
506: is select 1 from BEN_OIPLIP_F

Line 3041: -- Testing for values in BEN_ENRT_ENRLD_ANTHR_PL_F

3037: --
3038: close c125;
3039:
3040: --
3041: -- Testing for values in BEN_ENRT_ENRLD_ANTHR_PL_F
3042: --
3043: open c126(p_bg_id);
3044: --
3045: fetch c126 into l_temp;

Line 3049: fnd_message.set_token('TABLE_NAME','BEN_ENRT_ENRLD_ANTHR_PL_F');

3045: fetch c126 into l_temp;
3046: if c126%found then
3047: close c126;
3048: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3049: fnd_message.set_token('TABLE_NAME','BEN_ENRT_ENRLD_ANTHR_PL_F');
3050: fnd_message.raise_error;
3051: end if;
3052: --
3053: close c126;

Line 5949: delete from BEN_ENRT_ENRLD_ANTHR_PL_F

5945:
5946: delete from BEN_ELIG_ENRLD_ANTHR_PL_F
5947: where business_group_id = p_bg_id;
5948:
5949: delete from BEN_ENRT_ENRLD_ANTHR_PL_F
5950: where business_group_id = p_bg_id;
5951:
5952: delete from BEN_OIPLIP_F
5953: where business_group_id = p_bg_id;