APPS.BEN_ORG_DELETE dependencies on BEN_LER_CHG_OIPL_ENRT_RL_F

Line 930: is select 1 from BEN_LER_CHG_OIPL_ENRT_RL_F

926: is select 1 from BEN_LER_CHG_DPNT_CVG_CTFN_F
927: where business_group_id = p_bg_id;
928:
929: cursor c233(p_bg_id NUMBER)
930: is select 1 from BEN_LER_CHG_OIPL_ENRT_RL_F
931: where business_group_id = p_bg_id;
932:
933: cursor c234(p_bg_id NUMBER)
934: is select 1 from BEN_LER_CHG_PLIP_ENRT_F

Line 4646: -- Testing for values in BEN_LER_CHG_OIPL_ENRT_RL_F

4642: --
4643: close c232;
4644:
4645: --
4646: -- Testing for values in BEN_LER_CHG_OIPL_ENRT_RL_F
4647: --
4648: open c233(p_bg_id);
4649: --
4650: fetch c233 into l_temp;

Line 4654: fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_OIPL_ENRT_RL_F');

4650: fetch c233 into l_temp;
4651: if c233%found then
4652: close c233;
4653: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4654: fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_OIPL_ENRT_RL_F');
4655: fnd_message.raise_error;
4656: end if;
4657: --
4658: close c233;

Line 6270: delete from BEN_LER_CHG_OIPL_ENRT_RL_F

6266:
6267: delete from BEN_LER_CHG_DPNT_CVG_CTFN_F
6268: where business_group_id = p_bg_id;
6269:
6270: delete from BEN_LER_CHG_OIPL_ENRT_RL_F
6271: where business_group_id = p_bg_id;
6272:
6273: delete from BEN_LER_CHG_PLIP_ENRT_F
6274: where business_group_id = p_bg_id;