APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_PER_WV_PL_TYP_F

Line 882: is select 1 from BEN_ELIG_PER_WV_PL_TYP_F

878: is select 1 from BEN_ELIG_PER_OPT_F
879: where business_group_id = p_bg_id;
880:
881: cursor c221(p_bg_id NUMBER)
882: is select 1 from BEN_ELIG_PER_WV_PL_TYP_F
883: where business_group_id = p_bg_id;
884:
885: cursor c222(p_bg_id NUMBER)
886: is select 1 from BEN_PL_GD_R_SVC_CTFN_F

Line 4466: -- Testing for values in BEN_ELIG_PER_WV_PL_TYP_F

4462: --
4463: close c220;
4464:
4465: --
4466: -- Testing for values in BEN_ELIG_PER_WV_PL_TYP_F
4467: --
4468: open c221(p_bg_id);
4469: --
4470: fetch c221 into l_temp;

Line 4474: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PER_WV_PL_TYP_F');

4470: fetch c221 into l_temp;
4471: if c221%found then
4472: close c221;
4473: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4474: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PER_WV_PL_TYP_F');
4475: fnd_message.raise_error;
4476: end if;
4477: --
4478: close c221;

Line 6234: delete from BEN_ELIG_PER_WV_PL_TYP_F

6230:
6231: delete from BEN_ELIG_PER_OPT_F
6232: where business_group_id = p_bg_id;
6233:
6234: delete from BEN_ELIG_PER_WV_PL_TYP_F
6235: where business_group_id = p_bg_id;
6236:
6237: delete from BEN_PL_GD_R_SVC_CTFN_F
6238: where business_group_id = p_bg_id;