APPS.BEN_ORG_DELETE dependencies on BEN_PL_R_OIPL_PREM_BY_MO_F

Line 834: is select 1 from BEN_PL_R_OIPL_PREM_BY_MO_F

830: is select 1 from BEN_PL_BNF_F
831: where business_group_id = p_bg_id;
832:
833: cursor c209(p_bg_id NUMBER)
834: is select 1 from BEN_PL_R_OIPL_PREM_BY_MO_F
835: where business_group_id = p_bg_id;
836:
837: cursor c210(p_bg_id NUMBER)
838: is select 1 from BEN_PRTT_PREM_F

Line 4286: -- Testing for values in BEN_PL_R_OIPL_PREM_BY_MO_F

4282: --
4283: close c208;
4284:
4285: --
4286: -- Testing for values in BEN_PL_R_OIPL_PREM_BY_MO_F
4287: --
4288: open c209(p_bg_id);
4289: --
4290: fetch c209 into l_temp;

Line 4294: fnd_message.set_token('TABLE_NAME','BEN_PL_R_OIPL_PREM_BY_MO_F');

4290: fetch c209 into l_temp;
4291: if c209%found then
4292: close c209;
4293: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4294: fnd_message.set_token('TABLE_NAME','BEN_PL_R_OIPL_PREM_BY_MO_F');
4295: fnd_message.raise_error;
4296: end if;
4297: --
4298: close c209;

Line 6198: delete from BEN_PL_R_OIPL_PREM_BY_MO_F

6194:
6195: delete from BEN_PL_BNF_F
6196: where business_group_id = p_bg_id;
6197:
6198: delete from BEN_PL_R_OIPL_PREM_BY_MO_F
6199: where business_group_id = p_bg_id;
6200:
6201: delete from BEN_PRTT_PREM_F
6202: where business_group_id = p_bg_id;