APPS.BEN_ORG_DELETE dependencies on BEN_EE_STAT_RT_F

Line 1054: is select 1 from BEN_EE_STAT_RT_F

1050: is select 1 from BEN_ELIG_EE_STAT_PRTE_F
1051: where business_group_id = p_bg_id;
1052:
1053: cursor c264(p_bg_id NUMBER)
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

Line 5111: -- Testing for values in BEN_EE_STAT_RT_F

5107: --
5108: close c263;
5109:
5110: --
5111: -- Testing for values in BEN_EE_STAT_RT_F
5112: --
5113: open c264(p_bg_id);
5114: --
5115: fetch c264 into l_temp;

Line 5119: fnd_message.set_token('TABLE_NAME','BEN_EE_STAT_RT_F');

5115: fetch c264 into l_temp;
5116: if c264%found then
5117: close c264;
5118: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5119: fnd_message.set_token('TABLE_NAME','BEN_EE_STAT_RT_F');
5120: fnd_message.raise_error;
5121: end if;
5122: --
5123: close c264;

Line 6363: delete from BEN_EE_STAT_RT_F

6359:
6360: delete from BEN_ELIG_EE_STAT_PRTE_F
6361: where business_group_id = p_bg_id;
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;