APPS.BEN_ORG_DELETE dependencies on BEN_LER_BNFT_RSTRN_CTFN_F

Line 754: is select 1 from BEN_LER_BNFT_RSTRN_CTFN_F

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
755: where business_group_id = p_bg_id;
756:
757: cursor c190(p_bg_id NUMBER)
758: is select 1 from BEN_APLD_DPNT_CVG_ELIG_PRFL_F

Line 3986: -- Testing for values in BEN_LER_BNFT_RSTRN_CTFN_F

3982: --
3983: close c188;
3984:
3985: --
3986: -- Testing for values in BEN_LER_BNFT_RSTRN_CTFN_F
3987: --
3988: open c189(p_bg_id);
3989: --
3990: fetch c189 into l_temp;

Line 3994: fnd_message.set_token('TABLE_NAME','BEN_LER_BNFT_RSTRN_CTFN_F');

3990: fetch c189 into l_temp;
3991: if c189%found then
3992: close c189;
3993: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3994: fnd_message.set_token('TABLE_NAME','BEN_LER_BNFT_RSTRN_CTFN_F');
3995: fnd_message.raise_error;
3996: end if;
3997: --
3998: close c189;

Line 6138: delete from BEN_LER_BNFT_RSTRN_CTFN_F

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;
6140:
6141: delete from BEN_APLD_DPNT_CVG_ELIG_PRFL_F
6142: where business_group_id = p_bg_id;