APPS.BEN_ORG_DELETE dependencies on BEN_ELIGY_PRFL_RL_F

Line 186: is select 1 from BEN_ELIGY_PRFL_RL_F

182: is select 1 from BEN_CNTNU_PRTN_CTFN_TYP_F
183: where business_group_id = p_bg_id;
184:
185: cursor c46(p_bg_id NUMBER)
186: is select 1 from BEN_ELIGY_PRFL_RL_F
187: where business_group_id = p_bg_id;
188:
189: cursor c47(p_bg_id NUMBER)
190: is select 1 from BEN_ELIG_AGE_PRTE_F

Line 1856: -- Testing for values in BEN_ELIGY_PRFL_RL_F

1852: --
1853: close c45;
1854:
1855: --
1856: -- Testing for values in BEN_ELIGY_PRFL_RL_F
1857: --
1858: open c46(p_bg_id);
1859: --
1860: fetch c46 into l_temp;

Line 1864: fnd_message.set_token('TABLE_NAME','BEN_ELIGY_PRFL_RL_F');

1860: fetch c46 into l_temp;
1861: if c46%found then
1862: close c46;
1863: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1864: fnd_message.set_token('TABLE_NAME','BEN_ELIGY_PRFL_RL_F');
1865: fnd_message.raise_error;
1866: end if;
1867: --
1868: close c46;

Line 5712: delete from BEN_ELIGY_PRFL_RL_F

5708:
5709: delete from BEN_CNTNU_PRTN_CTFN_TYP_F
5710: where business_group_id = p_bg_id;
5711:
5712: delete from BEN_ELIGY_PRFL_RL_F
5713: where business_group_id = p_bg_id;
5714:
5715: delete from BEN_ELIG_AGE_PRTE_F
5716: where business_group_id = p_bg_id;