APPS.BEN_ORG_DELETE dependencies on BEN_WTHN_YR_PERD

Line 242: is select 1 from BEN_WTHN_YR_PERD

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
243: where business_group_id = p_bg_id;
244:
245: cursor c61(p_bg_id NUMBER)
246: is select 1 from BEN_CM_DLVRY_MED_TYP

Line 2066: -- Testing for values in BEN_WTHN_YR_PERD

2062: --
2063: close c59;
2064:
2065: --
2066: -- Testing for values in BEN_WTHN_YR_PERD
2067: --
2068: open c60(p_bg_id);
2069: --
2070: fetch c60 into l_temp;

Line 2074: fnd_message.set_token('TABLE_NAME','BEN_WTHN_YR_PERD');

2070: fetch c60 into l_temp;
2071: if c60%found then
2072: close c60;
2073: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2074: fnd_message.set_token('TABLE_NAME','BEN_WTHN_YR_PERD');
2075: fnd_message.raise_error;
2076: end if;
2077: --
2078: close c60;

Line 5754: delete from BEN_WTHN_YR_PERD

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;
5756:
5757: delete from BEN_CM_DLVRY_MED_TYP
5758: where business_group_id = p_bg_id;