APPS.BEN_ORG_DELETE dependencies on BEN_ACTY_RT_PYMT_SCHED_F

Line 1070: is select 1 from BEN_ACTY_RT_PYMT_SCHED_F

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
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

Line 5171: -- Testing for values in BEN_ACTY_RT_PYMT_SCHED_F

5167: --
5168: close c267;
5169:
5170: --
5171: -- Testing for values in BEN_ACTY_RT_PYMT_SCHED_F
5172: --
5173: open c268(p_bg_id);
5174: --
5175: fetch c268 into l_temp;

Line 5179: fnd_message.set_token('TABLE_NAME','BEN_ACTY_RT_PYMT_SCHED_F');

5175: fetch c268 into l_temp;
5176: if c268%found then
5177: close c268;
5178: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5179: fnd_message.set_token('TABLE_NAME','BEN_ACTY_RT_PYMT_SCHED_F');
5180: fnd_message.raise_error;
5181: end if;
5182: --
5183: close c268;

Line 6375: delete from BEN_ACTY_RT_PYMT_SCHED_F

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;
6377:
6378: delete from BEN_ACTY_VRBL_RT_F
6379: where business_group_id = p_bg_id;