APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_BENFTS_GRP_PRTE_F

Line 194: is select 1 from BEN_ELIG_BENFTS_GRP_PRTE_F

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
195: where business_group_id = p_bg_id;
196:
197: cursor c49(p_bg_id NUMBER)
198: is select 1 from BEN_ELIG_LOS_PRTE_F

Line 1886: -- Testing for values in BEN_ELIG_BENFTS_GRP_PRTE_F

1882: --
1883: close c47;
1884:
1885: --
1886: -- Testing for values in BEN_ELIG_BENFTS_GRP_PRTE_F
1887: --
1888: open c48(p_bg_id);
1889: --
1890: fetch c48 into l_temp;

Line 1894: fnd_message.set_token('TABLE_NAME','BEN_ELIG_BENFTS_GRP_PRTE_F');

1890: fetch c48 into l_temp;
1891: if c48%found then
1892: close c48;
1893: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1894: fnd_message.set_token('TABLE_NAME','BEN_ELIG_BENFTS_GRP_PRTE_F');
1895: fnd_message.raise_error;
1896: end if;
1897: --
1898: close c48;

Line 5718: delete from BEN_ELIG_BENFTS_GRP_PRTE_F

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;
5720:
5721: delete from BEN_ELIG_LOS_PRTE_F
5722: where business_group_id = p_bg_id;