APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_PER_F

Line 774: is select 1 from BEN_ELIG_PER_F

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
775: where business_group_id = p_bg_id;
776:
777: cursor c195(p_bg_id NUMBER)
778: is select 1 from BEN_ENRT_ENRLD_ANTHR_OIPL_F

Line 4061: -- Testing for values in BEN_ELIG_PER_F

4057: --
4058: close c193;
4059:
4060: --
4061: -- Testing for values in BEN_ELIG_PER_F
4062: --
4063: open c194(p_bg_id);
4064: --
4065: fetch c194 into l_temp;

Line 4069: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PER_F');

4065: fetch c194 into l_temp;
4066: if c194%found then
4067: close c194;
4068: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4069: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PER_F');
4070: fnd_message.raise_error;
4071: end if;
4072: --
4073: close c194;

Line 6153: delete from BEN_ELIG_PER_F

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;
6155:
6156: delete from BEN_ENRT_ENRLD_ANTHR_OIPL_F
6157: where business_group_id = p_bg_id;