APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_LGL_ENTY_PRTE_F

Line 302: is select 1 from BEN_ELIG_LGL_ENTY_PRTE_F

298: is select 1 from BEN_COMP_LVL_FCTR
299: where business_group_id = p_bg_id;
300:
301: cursor c75(p_bg_id NUMBER)
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

Line 2291: -- Testing for values in BEN_ELIG_LGL_ENTY_PRTE_F

2287: --
2288: close c74;
2289:
2290: --
2291: -- Testing for values in BEN_ELIG_LGL_ENTY_PRTE_F
2292: --
2293: open c75(p_bg_id);
2294: --
2295: fetch c75 into l_temp;

Line 2299: fnd_message.set_token('TABLE_NAME','BEN_ELIG_LGL_ENTY_PRTE_F');

2295: fetch c75 into l_temp;
2296: if c75%found then
2297: close c75;
2298: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2299: fnd_message.set_token('TABLE_NAME','BEN_ELIG_LGL_ENTY_PRTE_F');
2300: fnd_message.raise_error;
2301: end if;
2302: --
2303: close c75;

Line 5799: delete from BEN_ELIG_LGL_ENTY_PRTE_F

5795:
5796: delete from BEN_COMP_LVL_FCTR
5797: where business_group_id = p_bg_id;
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;

Line 6462: delete from BEN_ELIG_LGL_ENTY_PRTE_F

6458: BEGIN
6459: delete from BEN_ORG_UNIT_PRDCT_F
6460: where organization_id = p_org_id;
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;