APPS.BEN_ORG_DELETE dependencies on BEN_ACTY_RT_PTD_LMT_F

Line 1066: is select 1 from BEN_ACTY_RT_PTD_LMT_F

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
1067: where business_group_id = p_bg_id;
1068:
1069: cursor c268(p_bg_id NUMBER)
1070: is select 1 from BEN_ACTY_RT_PYMT_SCHED_F

Line 5156: -- Testing for values in BEN_ACTY_RT_PTD_LMT_F

5152: --
5153: close c266;
5154:
5155: --
5156: -- Testing for values in BEN_ACTY_RT_PTD_LMT_F
5157: --
5158: open c267(p_bg_id);
5159: --
5160: fetch c267 into l_temp;

Line 5164: fnd_message.set_token('TABLE_NAME','BEN_ACTY_RT_PTD_LMT_F');

5160: fetch c267 into l_temp;
5161: if c267%found then
5162: close c267;
5163: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5164: fnd_message.set_token('TABLE_NAME','BEN_ACTY_RT_PTD_LMT_F');
5165: fnd_message.raise_error;
5166: end if;
5167: --
5168: close c267;

Line 6372: delete from BEN_ACTY_RT_PTD_LMT_F

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;
6374:
6375: delete from BEN_ACTY_RT_PYMT_SCHED_F
6376: where business_group_id = p_bg_id;