APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_DSBLD_STAT_CVG_F

Line 362: is select 1 from BEN_ELIG_DSBLD_STAT_CVG_F

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
363: where business_group_id = p_bg_id;
364:
365: cursor c91(p_bg_id NUMBER)
366: is select 1 from BEN_ELIG_HRS_WKD_PRTE_F

Line 2516: -- Testing for values in BEN_ELIG_DSBLD_STAT_CVG_F

2512: --
2513: close c89;
2514:
2515: --
2516: -- Testing for values in BEN_ELIG_DSBLD_STAT_CVG_F
2517: --
2518: open c90(p_bg_id);
2519: --
2520: fetch c90 into l_temp;

Line 2524: fnd_message.set_token('TABLE_NAME','BEN_ELIG_DSBLD_STAT_CVG_F');

2520: fetch c90 into l_temp;
2521: if c90%found then
2522: close c90;
2523: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2524: fnd_message.set_token('TABLE_NAME','BEN_ELIG_DSBLD_STAT_CVG_F');
2525: fnd_message.raise_error;
2526: end if;
2527: --
2528: close c90;

Line 5844: delete from BEN_ELIG_DSBLD_STAT_CVG_F

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;
5846:
5847: delete from BEN_ELIG_HRS_WKD_PRTE_F
5848: where business_group_id = p_bg_id;