APPS.BEN_ORG_DELETE dependencies on BEN_EXT_CRIT_CMBN

Line 278: is select 1 from BEN_EXT_CRIT_CMBN

274: is select 1 from BEN_ELIG_CMBN_AGE_LOS_PRTE_F
275: where business_group_id = p_bg_id;
276:
277: cursor c69(p_bg_id NUMBER)
278: is select 1 from BEN_EXT_CRIT_CMBN
279: where business_group_id = p_bg_id;
280:
281: cursor c70(p_bg_id NUMBER)
282: is select 1 from BEN_EXT_DATA_ELMT_DECD

Line 2201: -- Testing for values in BEN_EXT_CRIT_CMBN

2197: --
2198: close c68;
2199:
2200: --
2201: -- Testing for values in BEN_EXT_CRIT_CMBN
2202: --
2203: open c69(p_bg_id);
2204: --
2205: fetch c69 into l_temp;

Line 2209: fnd_message.set_token('TABLE_NAME','BEN_EXT_CRIT_CMBN');

2205: fetch c69 into l_temp;
2206: if c69%found then
2207: close c69;
2208: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2209: fnd_message.set_token('TABLE_NAME','BEN_EXT_CRIT_CMBN');
2210: fnd_message.raise_error;
2211: end if;
2212: --
2213: close c69;

Line 5781: delete from BEN_EXT_CRIT_CMBN

5777:
5778: delete from BEN_ELIG_CMBN_AGE_LOS_PRTE_F
5779: where business_group_id = p_bg_id;
5780:
5781: delete from BEN_EXT_CRIT_CMBN
5782: where business_group_id = p_bg_id;
5783:
5784: delete from BEN_EXT_DATA_ELMT_DECD
5785: where business_group_id = p_bg_id;