APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_COMP_LVL_PRTE_F

Line 358: is select 1 from BEN_ELIG_COMP_LVL_PRTE_F

354: is select 1 from BEN_DSGNTR_ENRLD_CVG_F
355: where business_group_id = p_bg_id;
356:
357: cursor c89(p_bg_id NUMBER)
358: is select 1 from BEN_ELIG_COMP_LVL_PRTE_F
359: where business_group_id = p_bg_id;
360:
361: cursor c90(p_bg_id NUMBER)
362: is select 1 from BEN_ELIG_DSBLD_STAT_CVG_F

Line 2501: -- Testing for values in BEN_ELIG_COMP_LVL_PRTE_F

2497: --
2498: close c88;
2499:
2500: --
2501: -- Testing for values in BEN_ELIG_COMP_LVL_PRTE_F
2502: --
2503: open c89(p_bg_id);
2504: --
2505: fetch c89 into l_temp;

Line 2509: fnd_message.set_token('TABLE_NAME','BEN_ELIG_COMP_LVL_PRTE_F');

2505: fetch c89 into l_temp;
2506: if c89%found then
2507: close c89;
2508: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2509: fnd_message.set_token('TABLE_NAME','BEN_ELIG_COMP_LVL_PRTE_F');
2510: fnd_message.raise_error;
2511: end if;
2512: --
2513: close c89;

Line 5841: delete from BEN_ELIG_COMP_LVL_PRTE_F

5837:
5838: delete from BEN_DSGNTR_ENRLD_CVG_F
5839: where business_group_id = p_bg_id;
5840:
5841: delete from BEN_ELIG_COMP_LVL_PRTE_F
5842: where business_group_id = p_bg_id;
5843:
5844: delete from BEN_ELIG_DSBLD_STAT_CVG_F
5845: where business_group_id = p_bg_id;