APPS.BEN_ORG_DELETE dependencies on BEN_EXT_CRIT_VAL

Line 254: is select 1 from BEN_EXT_CRIT_VAL

250: is select 1 from BEN_ELIG_SVC_AREA_PRTE_F
251: where business_group_id = p_bg_id;
252:
253: cursor c63(p_bg_id NUMBER)
254: is select 1 from BEN_EXT_CRIT_VAL
255: where business_group_id = p_bg_id;
256:
257: cursor c64(p_bg_id NUMBER)
258: is select 1 from BEN_EXT_DATA_ELMT

Line 2111: -- Testing for values in BEN_EXT_CRIT_VAL

2107: --
2108: close c62;
2109:
2110: --
2111: -- Testing for values in BEN_EXT_CRIT_VAL
2112: --
2113: open c63(p_bg_id);
2114: --
2115: fetch c63 into l_temp;

Line 2119: fnd_message.set_token('TABLE_NAME','BEN_EXT_CRIT_VAL');

2115: fetch c63 into l_temp;
2116: if c63%found then
2117: close c63;
2118: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2119: fnd_message.set_token('TABLE_NAME','BEN_EXT_CRIT_VAL');
2120: fnd_message.raise_error;
2121: end if;
2122: --
2123: close c63;

Line 5763: delete from BEN_EXT_CRIT_VAL

5759:
5760: delete from BEN_ELIG_SVC_AREA_PRTE_F
5761: where business_group_id = p_bg_id;
5762:
5763: delete from BEN_EXT_CRIT_VAL
5764: where business_group_id = p_bg_id;
5765:
5766: delete from BEN_EXT_DATA_ELMT
5767: where business_group_id = p_bg_id;