APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_PY_BSS_PRTE_F

Line 1154: is select 1 from BEN_ELIG_PY_BSS_PRTE_F

1150: is select 1 from BEN_LOA_RSN_RT_F
1151: where business_group_id = p_bg_id;
1152:
1153: cursor c289(p_bg_id NUMBER)
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

Line 5486: -- Testing for values in BEN_ELIG_PY_BSS_PRTE_F

5482: --
5483: close c288;
5484:
5485: --
5486: -- Testing for values in BEN_ELIG_PY_BSS_PRTE_F
5487: --
5488: open c289(p_bg_id);
5489: --
5490: fetch c289 into l_temp;

Line 5494: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PY_BSS_PRTE_F');

5490: fetch c289 into l_temp;
5491: if c289%found then
5492: close c289;
5493: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5494: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PY_BSS_PRTE_F');
5495: fnd_message.raise_error;
5496: end if;
5497: --
5498: close c289;

Line 6438: delete from BEN_ELIG_PY_BSS_PRTE_F

6434:
6435: delete from BEN_LOA_RSN_RT_F
6436: where business_group_id = p_bg_id;
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;