APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_WK_LOC_PRTE_F

Line 210: is select 1 from BEN_ELIG_WK_LOC_PRTE_F

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
211: where business_group_id = p_bg_id;
212:
213: cursor c53(p_bg_id NUMBER)
214: is select 1 from BEN_EXT_CRIT_TYP

Line 1946: -- Testing for values in BEN_ELIG_WK_LOC_PRTE_F

1942: --
1943: close c51;
1944:
1945: --
1946: -- Testing for values in BEN_ELIG_WK_LOC_PRTE_F
1947: --
1948: open c52(p_bg_id);
1949: --
1950: fetch c52 into l_temp;

Line 1954: fnd_message.set_token('TABLE_NAME','BEN_ELIG_WK_LOC_PRTE_F');

1950: fetch c52 into l_temp;
1951: if c52%found then
1952: close c52;
1953: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1954: fnd_message.set_token('TABLE_NAME','BEN_ELIG_WK_LOC_PRTE_F');
1955: fnd_message.raise_error;
1956: end if;
1957: --
1958: close c52;

Line 5730: delete from BEN_ELIG_WK_LOC_PRTE_F

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;
5732:
5733: delete from BEN_EXT_CRIT_TYP
5734: where business_group_id = p_bg_id;