APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_LOA_RSN_PRTE_F

Line 1146: is select 1 from BEN_ELIG_LOA_RSN_PRTE_F

1142: is select 1 from BEN_PRTT_REIMBMT_RECON
1143: where business_group_id = p_bg_id;
1144:
1145: cursor c287(p_bg_id NUMBER)
1146: is select 1 from BEN_ELIG_LOA_RSN_PRTE_F
1147: where business_group_id = p_bg_id;
1148:
1149: cursor c288(p_bg_id NUMBER)
1150: is select 1 from BEN_LOA_RSN_RT_F

Line 5456: -- Testing for values in BEN_ELIG_LOA_RSN_PRTE_F

5452: --
5453: close c286;
5454:
5455: --
5456: -- Testing for values in BEN_ELIG_LOA_RSN_PRTE_F
5457: --
5458: open c287(p_bg_id);
5459: --
5460: fetch c287 into l_temp;

Line 5464: fnd_message.set_token('TABLE_NAME','BEN_ELIG_LOA_RSN_PRTE_F');

5460: fetch c287 into l_temp;
5461: if c287%found then
5462: close c287;
5463: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5464: fnd_message.set_token('TABLE_NAME','BEN_ELIG_LOA_RSN_PRTE_F');
5465: fnd_message.raise_error;
5466: end if;
5467: --
5468: close c287;

Line 6432: delete from BEN_ELIG_LOA_RSN_PRTE_F

6428:
6429: delete from BEN_PRTT_REIMBMT_RECON
6430: where business_group_id = p_bg_id;
6431:
6432: delete from BEN_ELIG_LOA_RSN_PRTE_F
6433: where business_group_id = p_bg_id;
6434:
6435: delete from BEN_LOA_RSN_RT_F
6436: where business_group_id = p_bg_id;