APPS.BEN_ORG_DELETE dependencies on BEN_PY_BSS_RT_F

Line 1158: is select 1 from BEN_PY_BSS_RT_F

1154: is select 1 from BEN_ELIG_PY_BSS_PRTE_F
1155: where business_group_id = p_bg_id;
1156:
1157: cursor c290(p_bg_id NUMBER)
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

Line 5501: -- Testing for values in BEN_PY_BSS_RT_F

5497: --
5498: close c289;
5499:
5500: --
5501: -- Testing for values in BEN_PY_BSS_RT_F
5502: --
5503: open c290(p_bg_id);
5504: --
5505: fetch c290 into l_temp;

Line 5509: fnd_message.set_token('TABLE_NAME','BEN_PY_BSS_RT_F');

5505: fetch c290 into l_temp;
5506: if c290%found then
5507: close c290;
5508: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5509: fnd_message.set_token('TABLE_NAME','BEN_PY_BSS_RT_F');
5510: fnd_message.raise_error;
5511: end if;
5512: --
5513: close c290;

Line 6441: delete from BEN_PY_BSS_RT_F

6437:
6438: delete from BEN_ELIG_PY_BSS_PRTE_F
6439: where business_group_id = p_bg_id;
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;