APPS.BEN_ORG_DELETE dependencies on BEN_ACTY_BASE_RT_F

Line 1062: is select 1 from BEN_ACTY_BASE_RT_F

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
1063: where business_group_id = p_bg_id;
1064:
1065: cursor c267(p_bg_id NUMBER)
1066: is select 1 from BEN_ACTY_RT_PTD_LMT_F

Line 5141: -- Testing for values in BEN_ACTY_BASE_RT_F

5137: --
5138: close c265;
5139:
5140: --
5141: -- Testing for values in BEN_ACTY_BASE_RT_F
5142: --
5143: open c266(p_bg_id);
5144: --
5145: fetch c266 into l_temp;

Line 5149: fnd_message.set_token('TABLE_NAME','BEN_ACTY_BASE_RT_F');

5145: fetch c266 into l_temp;
5146: if c266%found then
5147: close c266;
5148: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5149: fnd_message.set_token('TABLE_NAME','BEN_ACTY_BASE_RT_F');
5150: fnd_message.raise_error;
5151: end if;
5152: --
5153: close c266;

Line 6369: delete from BEN_ACTY_BASE_RT_F

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;
6371:
6372: delete from BEN_ACTY_RT_PTD_LMT_F
6373: where business_group_id = p_bg_id;