APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_HRS_WKD_PRTE_F

Line 366: is select 1 from BEN_ELIG_HRS_WKD_PRTE_F

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
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

Line 2531: -- Testing for values in BEN_ELIG_HRS_WKD_PRTE_F

2527: --
2528: close c90;
2529:
2530: --
2531: -- Testing for values in BEN_ELIG_HRS_WKD_PRTE_F
2532: --
2533: open c91(p_bg_id);
2534: --
2535: fetch c91 into l_temp;

Line 2539: fnd_message.set_token('TABLE_NAME','BEN_ELIG_HRS_WKD_PRTE_F');

2535: fetch c91 into l_temp;
2536: if c91%found then
2537: close c91;
2538: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2539: fnd_message.set_token('TABLE_NAME','BEN_ELIG_HRS_WKD_PRTE_F');
2540: fnd_message.raise_error;
2541: end if;
2542: --
2543: close c91;

Line 5847: delete from BEN_ELIG_HRS_WKD_PRTE_F

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;
5849:
5850: delete from BEN_ELIG_MLTRY_STAT_CVG_F
5851: where business_group_id = p_bg_id;