APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_MRTL_STAT_CVG_F

Line 374: is select 1 from BEN_ELIG_MRTL_STAT_CVG_F

370: is select 1 from BEN_ELIG_MLTRY_STAT_CVG_F
371: where business_group_id = p_bg_id;
372:
373: cursor c93(p_bg_id NUMBER)
374: is select 1 from BEN_ELIG_MRTL_STAT_CVG_F
375: where business_group_id = p_bg_id;
376:
377: cursor c94(p_bg_id NUMBER)
378: is select 1 from BEN_ELIG_STDNT_STAT_CVG_F

Line 2561: -- Testing for values in BEN_ELIG_MRTL_STAT_CVG_F

2557: --
2558: close c92;
2559:
2560: --
2561: -- Testing for values in BEN_ELIG_MRTL_STAT_CVG_F
2562: --
2563: open c93(p_bg_id);
2564: --
2565: fetch c93 into l_temp;

Line 2569: fnd_message.set_token('TABLE_NAME','BEN_ELIG_MRTL_STAT_CVG_F');

2565: fetch c93 into l_temp;
2566: if c93%found then
2567: close c93;
2568: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2569: fnd_message.set_token('TABLE_NAME','BEN_ELIG_MRTL_STAT_CVG_F');
2570: fnd_message.raise_error;
2571: end if;
2572: --
2573: close c93;

Line 5853: delete from BEN_ELIG_MRTL_STAT_CVG_F

5849:
5850: delete from BEN_ELIG_MLTRY_STAT_CVG_F
5851: where business_group_id = p_bg_id;
5852:
5853: delete from BEN_ELIG_MRTL_STAT_CVG_F
5854: where business_group_id = p_bg_id;
5855:
5856: delete from BEN_ELIG_STDNT_STAT_CVG_F
5857: where business_group_id = p_bg_id;