APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_ORG_UNIT_PRTE_F

Line 306: is select 1 from BEN_ELIG_ORG_UNIT_PRTE_F

302: is select 1 from BEN_ELIG_LGL_ENTY_PRTE_F
303: where business_group_id = p_bg_id;
304:
305: cursor c76(p_bg_id NUMBER)
306: is select 1 from BEN_ELIG_ORG_UNIT_PRTE_F
307: where business_group_id = p_bg_id;
308:
309: cursor c77(p_bg_id NUMBER)
310: is select 1 from BEN_EXT_RSLT_ERR

Line 2306: -- Testing for values in BEN_ELIG_ORG_UNIT_PRTE_F

2302: --
2303: close c75;
2304:
2305: --
2306: -- Testing for values in BEN_ELIG_ORG_UNIT_PRTE_F
2307: --
2308: open c76(p_bg_id);
2309: --
2310: fetch c76 into l_temp;

Line 2314: fnd_message.set_token('TABLE_NAME','BEN_ELIG_ORG_UNIT_PRTE_F');

2310: fetch c76 into l_temp;
2311: if c76%found then
2312: close c76;
2313: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2314: fnd_message.set_token('TABLE_NAME','BEN_ELIG_ORG_UNIT_PRTE_F');
2315: fnd_message.raise_error;
2316: end if;
2317: --
2318: close c76;

Line 5802: delete from BEN_ELIG_ORG_UNIT_PRTE_F

5798:
5799: delete from BEN_ELIG_LGL_ENTY_PRTE_F
5800: where business_group_id = p_bg_id;
5801:
5802: delete from BEN_ELIG_ORG_UNIT_PRTE_F
5803: where business_group_id = p_bg_id;
5804:
5805: delete from BEN_EXT_RSLT_ERR
5806: where business_group_id = p_bg_id;

Line 6465: delete from BEN_ELIG_ORG_UNIT_PRTE_F

6461:
6462: delete from BEN_ELIG_LGL_ENTY_PRTE_F
6463: where organization_id = p_org_id;
6464:
6465: delete from BEN_ELIG_ORG_UNIT_PRTE_F
6466: where organization_id = p_org_id;
6467:
6468: delete from BEN_REGN_F
6469: where organization_id = p_org_id;