APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_PSTL_CD_R_RNG_CVG_F

Line 386: is select 1 from BEN_ELIG_PSTL_CD_R_RNG_CVG_F

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
387: where business_group_id = p_bg_id;
388:
389: cursor c97(p_bg_id NUMBER)
390: is select 1 from BEN_PTD_LMT_F

Line 2606: -- Testing for values in BEN_ELIG_PSTL_CD_R_RNG_CVG_F

2602: --
2603: close c95;
2604:
2605: --
2606: -- Testing for values in BEN_ELIG_PSTL_CD_R_RNG_CVG_F
2607: --
2608: open c96(p_bg_id);
2609: --
2610: fetch c96 into l_temp;

Line 2614: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PSTL_CD_R_RNG_CVG_F');

2610: fetch c96 into l_temp;
2611: if c96%found then
2612: close c96;
2613: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2614: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PSTL_CD_R_RNG_CVG_F');
2615: fnd_message.raise_error;
2616: end if;
2617: --
2618: close c96;

Line 5862: delete from BEN_ELIG_PSTL_CD_R_RNG_CVG_F

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;
5864:
5865: delete from BEN_PTD_LMT_F
5866: where business_group_id = p_bg_id;