APPS.BEN_ORG_DELETE dependencies on BEN_VSTG_FOR_ACTY_RT_F

Line 238: is select 1 from BEN_VSTG_FOR_ACTY_RT_F

234: is select 1 from BEN_VSTG_AGE_RQMT
235: where business_group_id = p_bg_id;
236:
237: cursor c59(p_bg_id NUMBER)
238: is select 1 from BEN_VSTG_FOR_ACTY_RT_F
239: where business_group_id = p_bg_id;
240:
241: cursor c60(p_bg_id NUMBER)
242: is select 1 from BEN_WTHN_YR_PERD

Line 2051: -- Testing for values in BEN_VSTG_FOR_ACTY_RT_F

2047: --
2048: close c58;
2049:
2050: --
2051: -- Testing for values in BEN_VSTG_FOR_ACTY_RT_F
2052: --
2053: open c59(p_bg_id);
2054: --
2055: fetch c59 into l_temp;

Line 2059: fnd_message.set_token('TABLE_NAME','BEN_VSTG_FOR_ACTY_RT_F');

2055: fetch c59 into l_temp;
2056: if c59%found then
2057: close c59;
2058: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2059: fnd_message.set_token('TABLE_NAME','BEN_VSTG_FOR_ACTY_RT_F');
2060: fnd_message.raise_error;
2061: end if;
2062: --
2063: close c59;

Line 5751: delete from BEN_VSTG_FOR_ACTY_RT_F

5747:
5748: delete from BEN_VSTG_AGE_RQMT
5749: where business_group_id = p_bg_id;
5750:
5751: delete from BEN_VSTG_FOR_ACTY_RT_F
5752: where business_group_id = p_bg_id;
5753:
5754: delete from BEN_WTHN_YR_PERD
5755: where business_group_id = p_bg_id;