APPS.BEN_ORG_DELETE dependencies on BEN_LER_RQRS_ENRT_CTFN_F

Line 750: is select 1 from BEN_LER_RQRS_ENRT_CTFN_F

746: is select 1 from BEN_LER_BNFT_RSTRN_F
747: where business_group_id = p_bg_id;
748:
749: cursor c188(p_bg_id NUMBER)
750: is select 1 from BEN_LER_RQRS_ENRT_CTFN_F
751: where business_group_id = p_bg_id;
752:
753: cursor c189(p_bg_id NUMBER)
754: is select 1 from BEN_LER_BNFT_RSTRN_CTFN_F

Line 3971: -- Testing for values in BEN_LER_RQRS_ENRT_CTFN_F

3967: --
3968: close c187;
3969:
3970: --
3971: -- Testing for values in BEN_LER_RQRS_ENRT_CTFN_F
3972: --
3973: open c188(p_bg_id);
3974: --
3975: fetch c188 into l_temp;

Line 3979: fnd_message.set_token('TABLE_NAME','BEN_LER_RQRS_ENRT_CTFN_F');

3975: fetch c188 into l_temp;
3976: if c188%found then
3977: close c188;
3978: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3979: fnd_message.set_token('TABLE_NAME','BEN_LER_RQRS_ENRT_CTFN_F');
3980: fnd_message.raise_error;
3981: end if;
3982: --
3983: close c188;

Line 6135: delete from BEN_LER_RQRS_ENRT_CTFN_F

6131:
6132: delete from BEN_LER_BNFT_RSTRN_F
6133: where business_group_id = p_bg_id;
6134:
6135: delete from BEN_LER_RQRS_ENRT_CTFN_F
6136: where business_group_id = p_bg_id;
6137:
6138: delete from BEN_LER_BNFT_RSTRN_CTFN_F
6139: where business_group_id = p_bg_id;