APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_ENRLD_ANTHR_OIPL_F

Line 1162: is select 1 from BEN_ELIG_ENRLD_ANTHR_OIPL_F

1158: is select 1 from BEN_PY_BSS_RT_F
1159: where business_group_id = p_bg_id;
1160:
1161: cursor c291(p_bg_id NUMBER)
1162: is select 1 from BEN_ELIG_ENRLD_ANTHR_OIPL_F
1163: where business_group_id = p_bg_id;
1164:
1165: cursor c292(p_bg_id NUMBER)
1166: is select 1 from BEN_PL_PCP

Line 5516: -- Testing for values in BEN_ELIG_ENRLD_ANTHR_OIPL_F

5512: --
5513: close c290;
5514:
5515: --
5516: -- Testing for values in BEN_ELIG_ENRLD_ANTHR_OIPL_F
5517: --
5518: open c291(p_bg_id);
5519: --
5520: fetch c291 into l_temp;

Line 5524: fnd_message.set_token('TABLE_NAME','BEN_ELIG_ENRLD_ANTHR_OIPL_F');

5520: fetch c291 into l_temp;
5521: if c291%found then
5522: close c291;
5523: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5524: fnd_message.set_token('TABLE_NAME','BEN_ELIG_ENRLD_ANTHR_OIPL_F');
5525: fnd_message.raise_error;
5526: end if;
5527: --
5528: close c291;

Line 6444: delete from BEN_ELIG_ENRLD_ANTHR_OIPL_F

6440:
6441: delete from BEN_PY_BSS_RT_F
6442: where business_group_id = p_bg_id;
6443:
6444: delete from BEN_ELIG_ENRLD_ANTHR_OIPL_F
6445: where business_group_id = p_bg_id;
6446:
6447: delete from BEN_PL_PCP
6448: where business_group_id = p_bg_id;