APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_NO_OTHR_CVG_PRTE_F

Line 58: is select 1 from BEN_ELIG_NO_OTHR_CVG_PRTE_F

54: is select 1 from BEN_ELIG_LVG_RSN_PRTE_F
55: where business_group_id = p_bg_id;
56:
57: cursor c14(p_bg_id NUMBER)
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

Line 1376: -- Testing for values in BEN_ELIG_NO_OTHR_CVG_PRTE_F

1372: --
1373: close c13;
1374:
1375: --
1376: -- Testing for values in BEN_ELIG_NO_OTHR_CVG_PRTE_F
1377: --
1378: open c14(p_bg_id);
1379: --
1380: fetch c14 into l_temp;

Line 1384: fnd_message.set_token('TABLE_NAME','BEN_ELIG_NO_OTHR_CVG_PRTE_F');

1380: fetch c14 into l_temp;
1381: if c14%found then
1382: close c14;
1383: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1384: fnd_message.set_token('TABLE_NAME','BEN_ELIG_NO_OTHR_CVG_PRTE_F');
1385: fnd_message.raise_error;
1386: end if;
1387: --
1388: close c14;

Line 5616: delete from BEN_ELIG_NO_OTHR_CVG_PRTE_F

5612:
5613: delete from BEN_ELIG_LVG_RSN_PRTE_F
5614: where business_group_id = p_bg_id;
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;