APPS.BEN_ORG_DELETE dependencies on BEN_VSTG_AGE_RQMT

Line 234: is select 1 from BEN_VSTG_AGE_RQMT

230: is select 1 from BEN_PER_PIN_F
231: where business_group_id = p_bg_id;
232:
233: cursor c58(p_bg_id NUMBER)
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

Line 2036: -- Testing for values in BEN_VSTG_AGE_RQMT

2032: --
2033: close c57;
2034:
2035: --
2036: -- Testing for values in BEN_VSTG_AGE_RQMT
2037: --
2038: open c58(p_bg_id);
2039: --
2040: fetch c58 into l_temp;

Line 2044: fnd_message.set_token('TABLE_NAME','BEN_VSTG_AGE_RQMT');

2040: fetch c58 into l_temp;
2041: if c58%found then
2042: close c58;
2043: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2044: fnd_message.set_token('TABLE_NAME','BEN_VSTG_AGE_RQMT');
2045: fnd_message.raise_error;
2046: end if;
2047: --
2048: close c58;

Line 5748: delete from BEN_VSTG_AGE_RQMT

5744:
5745: delete from BEN_PER_PIN_F
5746: where business_group_id = p_bg_id;
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;