APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_LOS_PRTE_F

Line 198: is select 1 from BEN_ELIG_LOS_PRTE_F

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
199: where business_group_id = p_bg_id;
200:
201: cursor c50(p_bg_id NUMBER)
202: is select 1 from BEN_ELIG_PCT_FL_TM_PRTE_F

Line 1901: -- Testing for values in BEN_ELIG_LOS_PRTE_F

1897: --
1898: close c48;
1899:
1900: --
1901: -- Testing for values in BEN_ELIG_LOS_PRTE_F
1902: --
1903: open c49(p_bg_id);
1904: --
1905: fetch c49 into l_temp;

Line 1909: fnd_message.set_token('TABLE_NAME','BEN_ELIG_LOS_PRTE_F');

1905: fetch c49 into l_temp;
1906: if c49%found then
1907: close c49;
1908: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1909: fnd_message.set_token('TABLE_NAME','BEN_ELIG_LOS_PRTE_F');
1910: fnd_message.raise_error;
1911: end if;
1912: --
1913: close c49;

Line 5721: delete from BEN_ELIG_LOS_PRTE_F

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;
5723:
5724: delete from BEN_ELIG_PCT_FL_TM_PRTE_F
5725: where business_group_id = p_bg_id;