APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_OPTD_MDCR_PRTE_F

Line 62: is select 1 from BEN_ELIG_OPTD_MDCR_PRTE_F

58: is select 1 from BEN_ELIG_NO_OTHR_CVG_PRTE_F
59: where business_group_id = p_bg_id;
60:
61: cursor c15(p_bg_id NUMBER)
62: is select 1 from BEN_ELIG_OPTD_MDCR_PRTE_F
63: where business_group_id = p_bg_id;
64:
65: cursor c16(p_bg_id NUMBER)
66: is select 1 from BEN_ACTN_TYP

Line 1391: -- Testing for values in BEN_ELIG_OPTD_MDCR_PRTE_F

1387: --
1388: close c14;
1389:
1390: --
1391: -- Testing for values in BEN_ELIG_OPTD_MDCR_PRTE_F
1392: --
1393: open c15(p_bg_id);
1394: --
1395: fetch c15 into l_temp;

Line 1399: fnd_message.set_token('TABLE_NAME','BEN_ELIG_OPTD_MDCR_PRTE_F');

1395: fetch c15 into l_temp;
1396: if c15%found then
1397: close c15;
1398: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1399: fnd_message.set_token('TABLE_NAME','BEN_ELIG_OPTD_MDCR_PRTE_F');
1400: fnd_message.raise_error;
1401: end if;
1402: --
1403: close c15;

Line 5619: delete from BEN_ELIG_OPTD_MDCR_PRTE_F

5615:
5616: delete from BEN_ELIG_NO_OTHR_CVG_PRTE_F
5617: where business_group_id = p_bg_id;
5618:
5619: delete from BEN_ELIG_OPTD_MDCR_PRTE_F
5620: where business_group_id = p_bg_id;
5621:
5622: delete from BEN_ACTN_TYP
5623: where business_group_id = p_bg_id;