APPS.BEN_ORG_DELETE dependencies on BEN_VSTG_LOS_RQMT

Line 270: is select 1 from BEN_VSTG_LOS_RQMT

266: is select 1 from BEN_SVC_AREA_F
267: where business_group_id = p_bg_id;
268:
269: cursor c67(p_bg_id NUMBER)
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

Line 2171: -- Testing for values in BEN_VSTG_LOS_RQMT

2167: --
2168: close c66;
2169:
2170: --
2171: -- Testing for values in BEN_VSTG_LOS_RQMT
2172: --
2173: open c67(p_bg_id);
2174: --
2175: fetch c67 into l_temp;

Line 2179: fnd_message.set_token('TABLE_NAME','BEN_VSTG_LOS_RQMT');

2175: fetch c67 into l_temp;
2176: if c67%found then
2177: close c67;
2178: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2179: fnd_message.set_token('TABLE_NAME','BEN_VSTG_LOS_RQMT');
2180: fnd_message.raise_error;
2181: end if;
2182: --
2183: close c67;

Line 5775: delete from BEN_VSTG_LOS_RQMT

5771:
5772: delete from BEN_SVC_AREA_F
5773: where business_group_id = p_bg_id;
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;