APPS.BEN_ORG_DELETE dependencies on BEN_LER_CHG_OIPL_ENRT_F

Line 786: is select 1 from BEN_LER_CHG_OIPL_ENRT_F

782: is select 1 from BEN_LER_CHG_DPNT_CVG_F
783: where business_group_id = p_bg_id;
784:
785: cursor c197(p_bg_id NUMBER)
786: is select 1 from BEN_LER_CHG_OIPL_ENRT_F
787: where business_group_id = p_bg_id;
788:
789: cursor c198(p_bg_id NUMBER)
790: is select 1 from BEN_LER_CHG_PL_NIP_ENRT_F

Line 4106: -- Testing for values in BEN_LER_CHG_OIPL_ENRT_F

4102: --
4103: close c196;
4104:
4105: --
4106: -- Testing for values in BEN_LER_CHG_OIPL_ENRT_F
4107: --
4108: open c197(p_bg_id);
4109: --
4110: fetch c197 into l_temp;

Line 4114: fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_OIPL_ENRT_F');

4110: fetch c197 into l_temp;
4111: if c197%found then
4112: close c197;
4113: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4114: fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_OIPL_ENRT_F');
4115: fnd_message.raise_error;
4116: end if;
4117: --
4118: close c197;

Line 6162: delete from BEN_LER_CHG_OIPL_ENRT_F

6158:
6159: delete from BEN_LER_CHG_DPNT_CVG_F
6160: where business_group_id = p_bg_id;
6161:
6162: delete from BEN_LER_CHG_OIPL_ENRT_F
6163: where business_group_id = p_bg_id;
6164:
6165: delete from BEN_LER_CHG_PL_NIP_ENRT_F
6166: where business_group_id = p_bg_id;