APPS.BEN_ORG_DELETE dependencies on BEN_LER_CHG_PL_NIP_ENRT_F

Line 790: is select 1 from BEN_LER_CHG_PL_NIP_ENRT_F

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
791: where business_group_id = p_bg_id;
792:
793: cursor c199(p_bg_id NUMBER)
794: is select 1 from BEN_PIL_ELCTBL_CHC_POPL

Line 4121: -- Testing for values in BEN_LER_CHG_PL_NIP_ENRT_F

4117: --
4118: close c197;
4119:
4120: --
4121: -- Testing for values in BEN_LER_CHG_PL_NIP_ENRT_F
4122: --
4123: open c198(p_bg_id);
4124: --
4125: fetch c198 into l_temp;

Line 4129: fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_PL_NIP_ENRT_F');

4125: fetch c198 into l_temp;
4126: if c198%found then
4127: close c198;
4128: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4129: fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_PL_NIP_ENRT_F');
4130: fnd_message.raise_error;
4131: end if;
4132: --
4133: close c198;

Line 6165: delete from BEN_LER_CHG_PL_NIP_ENRT_F

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;
6167:
6168: delete from BEN_PIL_ELCTBL_CHC_POPL
6169: where business_group_id = p_bg_id;