APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_AGE_PRTE_F

Line 190: is select 1 from BEN_ELIG_AGE_PRTE_F

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
191: where business_group_id = p_bg_id;
192:
193: cursor c48(p_bg_id NUMBER)
194: is select 1 from BEN_ELIG_BENFTS_GRP_PRTE_F

Line 1871: -- Testing for values in BEN_ELIG_AGE_PRTE_F

1867: --
1868: close c46;
1869:
1870: --
1871: -- Testing for values in BEN_ELIG_AGE_PRTE_F
1872: --
1873: open c47(p_bg_id);
1874: --
1875: fetch c47 into l_temp;

Line 1879: fnd_message.set_token('TABLE_NAME','BEN_ELIG_AGE_PRTE_F');

1875: fetch c47 into l_temp;
1876: if c47%found then
1877: close c47;
1878: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1879: fnd_message.set_token('TABLE_NAME','BEN_ELIG_AGE_PRTE_F');
1880: fnd_message.raise_error;
1881: end if;
1882: --
1883: close c47;

Line 5715: delete from BEN_ELIG_AGE_PRTE_F

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;
5717:
5718: delete from BEN_ELIG_BENFTS_GRP_PRTE_F
5719: where business_group_id = p_bg_id;