APPS.BEN_ORG_DELETE dependencies on BEN_LER_CHG_PLIP_ENRT_RL_F

Line 942: is select 1 from BEN_LER_CHG_PLIP_ENRT_RL_F

938: is select 1 from BEN_LER_ENRT_CTFN_F
939: where business_group_id = p_bg_id;
940:
941: cursor c236(p_bg_id NUMBER)
942: is select 1 from BEN_LER_CHG_PLIP_ENRT_RL_F
943: where business_group_id = p_bg_id;
944:
945: cursor c237(p_bg_id NUMBER)
946: is select 1 from BEN_LER_CHG_PL_NIP_RL_F

Line 4691: -- Testing for values in BEN_LER_CHG_PLIP_ENRT_RL_F

4687: --
4688: close c235;
4689:
4690: --
4691: -- Testing for values in BEN_LER_CHG_PLIP_ENRT_RL_F
4692: --
4693: open c236(p_bg_id);
4694: --
4695: fetch c236 into l_temp;

Line 4699: fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_PLIP_ENRT_RL_F');

4695: fetch c236 into l_temp;
4696: if c236%found then
4697: close c236;
4698: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4699: fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_PLIP_ENRT_RL_F');
4700: fnd_message.raise_error;
4701: end if;
4702: --
4703: close c236;

Line 6279: delete from BEN_LER_CHG_PLIP_ENRT_RL_F

6275:
6276: delete from BEN_LER_ENRT_CTFN_F
6277: where business_group_id = p_bg_id;
6278:
6279: delete from BEN_LER_CHG_PLIP_ENRT_RL_F
6280: where business_group_id = p_bg_id;
6281:
6282: delete from BEN_LER_CHG_PL_NIP_RL_F
6283: where business_group_id = p_bg_id;