APPS.BEN_ORG_DELETE dependencies on BEN_LER_CHG_PL_NIP_RL_F

Line 946: is select 1 from BEN_LER_CHG_PL_NIP_RL_F

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
947: where business_group_id = p_bg_id;
948:
949: cursor c238(p_bg_id NUMBER)
950: is select 1 from BEN_PER_CM_F

Line 4706: -- Testing for values in BEN_LER_CHG_PL_NIP_RL_F

4702: --
4703: close c236;
4704:
4705: --
4706: -- Testing for values in BEN_LER_CHG_PL_NIP_RL_F
4707: --
4708: open c237(p_bg_id);
4709: --
4710: fetch c237 into l_temp;

Line 4714: fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_PL_NIP_RL_F');

4710: fetch c237 into l_temp;
4711: if c237%found then
4712: close c237;
4713: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4714: fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_PL_NIP_RL_F');
4715: fnd_message.raise_error;
4716: end if;
4717: --
4718: close c237;

Line 6282: delete from BEN_LER_CHG_PL_NIP_RL_F

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;
6284:
6285: delete from BEN_PER_CM_F
6286: where business_group_id = p_bg_id;