APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_ASNT_SET_PRTE_F

Line 1058: is select 1 from BEN_ELIG_ASNT_SET_PRTE_F

1054: is select 1 from BEN_EE_STAT_RT_F
1055: where business_group_id = p_bg_id;
1056:
1057: cursor c265(p_bg_id NUMBER)
1058: is select 1 from BEN_ELIG_ASNT_SET_PRTE_F
1059: where business_group_id = p_bg_id;
1060:
1061: cursor c266(p_bg_id NUMBER)
1062: is select 1 from BEN_ACTY_BASE_RT_F

Line 5126: -- Testing for values in BEN_ELIG_ASNT_SET_PRTE_F

5122: --
5123: close c264;
5124:
5125: --
5126: -- Testing for values in BEN_ELIG_ASNT_SET_PRTE_F
5127: --
5128: open c265(p_bg_id);
5129: --
5130: fetch c265 into l_temp;

Line 5134: fnd_message.set_token('TABLE_NAME','BEN_ELIG_ASNT_SET_PRTE_F');

5130: fetch c265 into l_temp;
5131: if c265%found then
5132: close c265;
5133: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5134: fnd_message.set_token('TABLE_NAME','BEN_ELIG_ASNT_SET_PRTE_F');
5135: fnd_message.raise_error;
5136: end if;
5137: --
5138: close c265;

Line 6366: delete from BEN_ELIG_ASNT_SET_PRTE_F

6362:
6363: delete from BEN_EE_STAT_RT_F
6364: where business_group_id = p_bg_id;
6365:
6366: delete from BEN_ELIG_ASNT_SET_PRTE_F
6367: where business_group_id = p_bg_id;
6368:
6369: delete from BEN_ACTY_BASE_RT_F
6370: where business_group_id = p_bg_id;