APPS.BEN_ORG_DELETE dependencies on BEN_VRBL_RT_RL_F

Line 1106: is select 1 from BEN_VRBL_RT_RL_F

1102: is select 1 from BEN_PRTL_MO_RT_PRTN_VAL_F
1103: where business_group_id = p_bg_id;
1104:
1105: cursor c277(p_bg_id NUMBER)
1106: is select 1 from BEN_VRBL_RT_RL_F
1107: where business_group_id = p_bg_id;
1108:
1109: cursor c278(p_bg_id NUMBER)
1110: is select 1 from BEN_DED_SCHED_PY_FREQ

Line 5306: -- Testing for values in BEN_VRBL_RT_RL_F

5302: --
5303: close c276;
5304:
5305: --
5306: -- Testing for values in BEN_VRBL_RT_RL_F
5307: --
5308: open c277(p_bg_id);
5309: --
5310: fetch c277 into l_temp;

Line 5314: fnd_message.set_token('TABLE_NAME','BEN_VRBL_RT_RL_F');

5310: fetch c277 into l_temp;
5311: if c277%found then
5312: close c277;
5313: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5314: fnd_message.set_token('TABLE_NAME','BEN_VRBL_RT_RL_F');
5315: fnd_message.raise_error;
5316: end if;
5317: --
5318: close c277;

Line 6402: delete from BEN_VRBL_RT_RL_F

6398:
6399: delete from BEN_PRTL_MO_RT_PRTN_VAL_F
6400: where business_group_id = p_bg_id;
6401:
6402: delete from BEN_VRBL_RT_RL_F
6403: where business_group_id = p_bg_id;
6404:
6405: delete from BEN_DED_SCHED_PY_FREQ
6406: where business_group_id = p_bg_id;