APPS.BEN_ORG_DELETE dependencies on BEN_DED_SCHED_PY_FREQ

Line 1110: is select 1 from BEN_DED_SCHED_PY_FREQ

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
1111: where business_group_id = p_bg_id;
1112:
1113: cursor c279(p_bg_id NUMBER)
1114: is select 1 from BEN_ACTY_RT_DED_SCHED_F

Line 5321: -- Testing for values in BEN_DED_SCHED_PY_FREQ

5317: --
5318: close c277;
5319:
5320: --
5321: -- Testing for values in BEN_DED_SCHED_PY_FREQ
5322: --
5323: open c278(p_bg_id);
5324: --
5325: fetch c278 into l_temp;

Line 5329: fnd_message.set_token('TABLE_NAME','BEN_DED_SCHED_PY_FREQ');

5325: fetch c278 into l_temp;
5326: if c278%found then
5327: close c278;
5328: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
5329: fnd_message.set_token('TABLE_NAME','BEN_DED_SCHED_PY_FREQ');
5330: fnd_message.raise_error;
5331: end if;
5332: --
5333: close c278;

Line 6405: delete from BEN_DED_SCHED_PY_FREQ

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;
6407:
6408: delete from BEN_ACTY_RT_DED_SCHED_F
6409: where business_group_id = p_bg_id;