APPS.BEN_ORG_DELETE dependencies on BEN_LER_CHG_PLIP_ENRT_F

Line 934: is select 1 from BEN_LER_CHG_PLIP_ENRT_F

930: is select 1 from BEN_LER_CHG_OIPL_ENRT_RL_F
931: where business_group_id = p_bg_id;
932:
933: cursor c234(p_bg_id NUMBER)
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

Line 4661: -- Testing for values in BEN_LER_CHG_PLIP_ENRT_F

4657: --
4658: close c233;
4659:
4660: --
4661: -- Testing for values in BEN_LER_CHG_PLIP_ENRT_F
4662: --
4663: open c234(p_bg_id);
4664: --
4665: fetch c234 into l_temp;

Line 4669: fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_PLIP_ENRT_F');

4665: fetch c234 into l_temp;
4666: if c234%found then
4667: close c234;
4668: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4669: fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_PLIP_ENRT_F');
4670: fnd_message.raise_error;
4671: end if;
4672: --
4673: close c234;

Line 6273: delete from BEN_LER_CHG_PLIP_ENRT_F

6269:
6270: delete from BEN_LER_CHG_OIPL_ENRT_RL_F
6271: where business_group_id = p_bg_id;
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;