APPS.BEN_ORG_DELETE dependencies on BEN_ACTY_VRBL_RT_F

Line 1074: is select 1 from BEN_ACTY_VRBL_RT_F

1070: is select 1 from BEN_ACTY_RT_PYMT_SCHED_F
1071: where business_group_id = p_bg_id;
1072:
1073: cursor c269(p_bg_id NUMBER)
1074: is select 1 from BEN_ACTY_VRBL_RT_F
1075: where business_group_id = p_bg_id;
1076:
1077: cursor c270(p_bg_id NUMBER)
1078: is select 1 from BEN_APLCN_TO_BNFT_POOL_F

Line 5186: -- Testing for values in BEN_ACTY_VRBL_RT_F

5182: --
5183: close c268;
5184:
5185: --
5186: -- Testing for values in BEN_ACTY_VRBL_RT_F
5187: --
5188: open c269(p_bg_id);
5189: --
5190: fetch c269 into l_temp;

Line 5194: fnd_message.set_token('TABLE_NAME','BEN_ACTY_VRBL_RT_F');

5190: fetch c269 into l_temp;
5191: if c269%found then
5192: close c269;
5193: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5194: fnd_message.set_token('TABLE_NAME','BEN_ACTY_VRBL_RT_F');
5195: fnd_message.raise_error;
5196: end if;
5197: --
5198: close c269;

Line 6378: delete from BEN_ACTY_VRBL_RT_F

6374:
6375: delete from BEN_ACTY_RT_PYMT_SCHED_F
6376: where business_group_id = p_bg_id;
6377:
6378: delete from BEN_ACTY_VRBL_RT_F
6379: where business_group_id = p_bg_id;
6380:
6381: delete from BEN_APLCN_TO_BNFT_POOL_F
6382: where business_group_id = p_bg_id;