APPS.BEN_ORG_DELETE dependencies on BEN_EXT_CHG_EVT_LOG

Line 130: is select 1 from BEN_EXT_CHG_EVT_LOG

126: is select 1 from BEN_ELIG_SCHEDD_HRS_PRTE_F
127: where business_group_id = p_bg_id;
128:
129: cursor c32(p_bg_id NUMBER)
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

Line 1646: -- Testing for values in BEN_EXT_CHG_EVT_LOG

1642: --
1643: close c31;
1644:
1645: --
1646: -- Testing for values in BEN_EXT_CHG_EVT_LOG
1647: --
1648: open c32(p_bg_id);
1649: --
1650: fetch c32 into l_temp;

Line 1654: fnd_message.set_token('TABLE_NAME','BEN_EXT_CHG_EVT_LOG');

1650: fetch c32 into l_temp;
1651: if c32%found then
1652: close c32;
1653: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1654: fnd_message.set_token('TABLE_NAME','BEN_EXT_CHG_EVT_LOG');
1655: fnd_message.raise_error;
1656: end if;
1657: --
1658: close c32;

Line 5670: delete from BEN_EXT_CHG_EVT_LOG

5666:
5667: delete from BEN_ELIG_SCHEDD_HRS_PRTE_F
5668: where business_group_id = p_bg_id;
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;