APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_MLTRY_STAT_CVG_F

Line 370: is select 1 from BEN_ELIG_MLTRY_STAT_CVG_F

366: is select 1 from BEN_ELIG_HRS_WKD_PRTE_F
367: where business_group_id = p_bg_id;
368:
369: cursor c92(p_bg_id NUMBER)
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

Line 2546: -- Testing for values in BEN_ELIG_MLTRY_STAT_CVG_F

2542: --
2543: close c91;
2544:
2545: --
2546: -- Testing for values in BEN_ELIG_MLTRY_STAT_CVG_F
2547: --
2548: open c92(p_bg_id);
2549: --
2550: fetch c92 into l_temp;

Line 2554: fnd_message.set_token('TABLE_NAME','BEN_ELIG_MLTRY_STAT_CVG_F');

2550: fetch c92 into l_temp;
2551: if c92%found then
2552: close c92;
2553: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2554: fnd_message.set_token('TABLE_NAME','BEN_ELIG_MLTRY_STAT_CVG_F');
2555: fnd_message.raise_error;
2556: end if;
2557: --
2558: close c92;

Line 5850: delete from BEN_ELIG_MLTRY_STAT_CVG_F

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