APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_AGE_CVG_F

Line 382: is select 1 from BEN_ELIG_AGE_CVG_F

378: is select 1 from BEN_ELIG_STDNT_STAT_CVG_F
379: where business_group_id = p_bg_id;
380:
381: cursor c95(p_bg_id NUMBER)
382: is select 1 from BEN_ELIG_AGE_CVG_F
383: where business_group_id = p_bg_id;
384:
385: cursor c96(p_bg_id NUMBER)
386: is select 1 from BEN_ELIG_PSTL_CD_R_RNG_CVG_F

Line 2591: -- Testing for values in BEN_ELIG_AGE_CVG_F

2587: --
2588: close c94;
2589:
2590: --
2591: -- Testing for values in BEN_ELIG_AGE_CVG_F
2592: --
2593: open c95(p_bg_id);
2594: --
2595: fetch c95 into l_temp;

Line 2599: fnd_message.set_token('TABLE_NAME','BEN_ELIG_AGE_CVG_F');

2595: fetch c95 into l_temp;
2596: if c95%found then
2597: close c95;
2598: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2599: fnd_message.set_token('TABLE_NAME','BEN_ELIG_AGE_CVG_F');
2600: fnd_message.raise_error;
2601: end if;
2602: --
2603: close c95;

Line 5859: delete from BEN_ELIG_AGE_CVG_F

5855:
5856: delete from BEN_ELIG_STDNT_STAT_CVG_F
5857: where business_group_id = p_bg_id;
5858:
5859: delete from BEN_ELIG_AGE_CVG_F
5860: where business_group_id = p_bg_id;
5861:
5862: delete from BEN_ELIG_PSTL_CD_R_RNG_CVG_F
5863: where business_group_id = p_bg_id;