APPS.BEN_ORG_DELETE dependencies on BEN_EXT_CRIT_PRFL

Line 134: is select 1 from BEN_EXT_CRIT_PRFL

130: is select 1 from BEN_EXT_CHG_EVT_LOG
131: where business_group_id = p_bg_id;
132:
133: cursor c33(p_bg_id NUMBER)
134: is select 1 from BEN_EXT_CRIT_PRFL
135: where business_group_id = p_bg_id;
136:
137: cursor c34(p_bg_id NUMBER)
138: is select 1 from BEN_EXT_FILE

Line 1661: -- Testing for values in BEN_EXT_CRIT_PRFL

1657: --
1658: close c32;
1659:
1660: --
1661: -- Testing for values in BEN_EXT_CRIT_PRFL
1662: --
1663: open c33(p_bg_id);
1664: --
1665: fetch c33 into l_temp;

Line 1669: fnd_message.set_token('TABLE_NAME','BEN_EXT_CRIT_PRFL');

1665: fetch c33 into l_temp;
1666: if c33%found then
1667: close c33;
1668: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1669: fnd_message.set_token('TABLE_NAME','BEN_EXT_CRIT_PRFL');
1670: fnd_message.raise_error;
1671: end if;
1672: --
1673: close c33;

Line 5673: delete from BEN_EXT_CRIT_PRFL

5669:
5670: delete from BEN_EXT_CHG_EVT_LOG
5671: where business_group_id = p_bg_id;
5672:
5673: delete from BEN_EXT_CRIT_PRFL
5674: where business_group_id = p_bg_id;
5675:
5676: delete from BEN_EXT_FILE
5677: where business_group_id = p_bg_id;