APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_PSTL_CD_R_RNG_PRTE_F

Line 206: is select 1 from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F

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
207: where business_group_id = p_bg_id;
208:
209: cursor c52(p_bg_id NUMBER)
210: is select 1 from BEN_ELIG_WK_LOC_PRTE_F

Line 1931: -- Testing for values in BEN_ELIG_PSTL_CD_R_RNG_PRTE_F

1927: --
1928: close c50;
1929:
1930: --
1931: -- Testing for values in BEN_ELIG_PSTL_CD_R_RNG_PRTE_F
1932: --
1933: open c51(p_bg_id);
1934: --
1935: fetch c51 into l_temp;

Line 1939: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PSTL_CD_R_RNG_PRTE_F');

1935: fetch c51 into l_temp;
1936: if c51%found then
1937: close c51;
1938: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1939: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PSTL_CD_R_RNG_PRTE_F');
1940: fnd_message.raise_error;
1941: end if;
1942: --
1943: close c51;

Line 5727: delete from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F

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;
5729:
5730: delete from BEN_ELIG_WK_LOC_PRTE_F
5731: where business_group_id = p_bg_id;