APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_CMBN_AGE_LOS_PRTE_F

Line 274: is select 1 from BEN_ELIG_CMBN_AGE_LOS_PRTE_F

270: is select 1 from BEN_VSTG_LOS_RQMT
271: where business_group_id = p_bg_id;
272:
273: cursor c68(p_bg_id NUMBER)
274: is select 1 from BEN_ELIG_CMBN_AGE_LOS_PRTE_F
275: where business_group_id = p_bg_id;
276:
277: cursor c69(p_bg_id NUMBER)
278: is select 1 from BEN_EXT_CRIT_CMBN

Line 2186: -- Testing for values in BEN_ELIG_CMBN_AGE_LOS_PRTE_F

2182: --
2183: close c67;
2184:
2185: --
2186: -- Testing for values in BEN_ELIG_CMBN_AGE_LOS_PRTE_F
2187: --
2188: open c68(p_bg_id);
2189: --
2190: fetch c68 into l_temp;

Line 2194: fnd_message.set_token('TABLE_NAME','BEN_ELIG_CMBN_AGE_LOS_PRTE_F');

2190: fetch c68 into l_temp;
2191: if c68%found then
2192: close c68;
2193: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2194: fnd_message.set_token('TABLE_NAME','BEN_ELIG_CMBN_AGE_LOS_PRTE_F');
2195: fnd_message.raise_error;
2196: end if;
2197: --
2198: close c68;

Line 5778: delete from BEN_ELIG_CMBN_AGE_LOS_PRTE_F

5774:
5775: delete from BEN_VSTG_LOS_RQMT
5776: where business_group_id = p_bg_id;
5777:
5778: delete from BEN_ELIG_CMBN_AGE_LOS_PRTE_F
5779: where business_group_id = p_bg_id;
5780:
5781: delete from BEN_EXT_CRIT_CMBN
5782: where business_group_id = p_bg_id;