APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_PCT_FL_TM_PRTE_F

Line 202: is select 1 from BEN_ELIG_PCT_FL_TM_PRTE_F

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
203: where business_group_id = p_bg_id;
204:
205: cursor c51(p_bg_id NUMBER)
206: is select 1 from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F

Line 1916: -- Testing for values in BEN_ELIG_PCT_FL_TM_PRTE_F

1912: --
1913: close c49;
1914:
1915: --
1916: -- Testing for values in BEN_ELIG_PCT_FL_TM_PRTE_F
1917: --
1918: open c50(p_bg_id);
1919: --
1920: fetch c50 into l_temp;

Line 1924: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PCT_FL_TM_PRTE_F');

1920: fetch c50 into l_temp;
1921: if c50%found then
1922: close c50;
1923: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1924: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PCT_FL_TM_PRTE_F');
1925: fnd_message.raise_error;
1926: end if;
1927: --
1928: close c50;

Line 5724: delete from BEN_ELIG_PCT_FL_TM_PRTE_F

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;
5726:
5727: delete from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F
5728: where business_group_id = p_bg_id;