APPS.BEN_ORG_DELETE dependencies on BEN_CM_DLVRY_MED_TYP

Line 246: is select 1 from BEN_CM_DLVRY_MED_TYP

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
247: where business_group_id = p_bg_id;
248:
249: cursor c62(p_bg_id NUMBER)
250: is select 1 from BEN_ELIG_SVC_AREA_PRTE_F

Line 2081: -- Testing for values in BEN_CM_DLVRY_MED_TYP

2077: --
2078: close c60;
2079:
2080: --
2081: -- Testing for values in BEN_CM_DLVRY_MED_TYP
2082: --
2083: open c61(p_bg_id);
2084: --
2085: fetch c61 into l_temp;

Line 2089: fnd_message.set_token('TABLE_NAME','BEN_CM_DLVRY_MED_TYP');

2085: fetch c61 into l_temp;
2086: if c61%found then
2087: close c61;
2088: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2089: fnd_message.set_token('TABLE_NAME','BEN_CM_DLVRY_MED_TYP');
2090: fnd_message.raise_error;
2091: end if;
2092: --
2093: close c61;

Line 5757: delete from BEN_CM_DLVRY_MED_TYP

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;
5759:
5760: delete from BEN_ELIG_SVC_AREA_PRTE_F
5761: where business_group_id = p_bg_id;