APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F

Line 770: is select 1 from BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F

766: is select 1 from BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F
767: where business_group_id = p_bg_id;
768:
769: cursor c193(p_bg_id NUMBER)
770: is select 1 from BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F
771: where business_group_id = p_bg_id;
772:
773: cursor c194(p_bg_id NUMBER)
774: is select 1 from BEN_ELIG_PER_F

Line 4046: -- Testing for values in BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F

4042: --
4043: close c192;
4044:
4045: --
4046: -- Testing for values in BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F
4047: --
4048: open c193(p_bg_id);
4049: --
4050: fetch c193 into l_temp;

Line 4054: fnd_message.set_token('TABLE_NAME','BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F');

4050: fetch c193 into l_temp;
4051: if c193%found then
4052: close c193;
4053: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4054: fnd_message.set_token('TABLE_NAME','BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F');
4055: fnd_message.raise_error;
4056: end if;
4057: --
4058: close c193;

Line 6150: delete from BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F

6146:
6147: delete from BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F
6148: where business_group_id = p_bg_id;
6149:
6150: delete from BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F
6151: where business_group_id = p_bg_id;
6152:
6153: delete from BEN_ELIG_PER_F
6154: where business_group_id = p_bg_id;