APPS.BEN_ORG_DELETE dependencies on BEN_LER_ENRT_CTFN_F

Line 938: is select 1 from BEN_LER_ENRT_CTFN_F

934: is select 1 from BEN_LER_CHG_PLIP_ENRT_F
935: where business_group_id = p_bg_id;
936:
937: cursor c235(p_bg_id NUMBER)
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

Line 4676: -- Testing for values in BEN_LER_ENRT_CTFN_F

4672: --
4673: close c234;
4674:
4675: --
4676: -- Testing for values in BEN_LER_ENRT_CTFN_F
4677: --
4678: open c235(p_bg_id);
4679: --
4680: fetch c235 into l_temp;

Line 4684: fnd_message.set_token('TABLE_NAME','BEN_LER_ENRT_CTFN_F');

4680: fetch c235 into l_temp;
4681: if c235%found then
4682: close c235;
4683: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4684: fnd_message.set_token('TABLE_NAME','BEN_LER_ENRT_CTFN_F');
4685: fnd_message.raise_error;
4686: end if;
4687: --
4688: close c235;

Line 6276: delete from BEN_LER_ENRT_CTFN_F

6272:
6273: delete from BEN_LER_CHG_PLIP_ENRT_F
6274: where business_group_id = p_bg_id;
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;