APPS.BEN_ORG_DELETE dependencies on BEN_CSR_ACTIVITIES

Line 98: is select 1 from BEN_CSR_ACTIVITIES

94: is select 1 from BEN_COMP_ASSET
95: where business_group_id = p_bg_id;
96:
97: cursor c24(p_bg_id NUMBER)
98: is select 1 from BEN_CSR_ACTIVITIES
99: where business_group_id = p_bg_id;
100:
101: cursor c25(p_bg_id NUMBER)
102: is select 1 from BEN_ELIG_BRGNG_UNIT_PRTE_F

Line 1526: -- Testing for values in BEN_CSR_ACTIVITIES

1522: --
1523: close c23;
1524:
1525: --
1526: -- Testing for values in BEN_CSR_ACTIVITIES
1527: --
1528: open c24(p_bg_id);
1529: --
1530: fetch c24 into l_temp;

Line 1534: fnd_message.set_token('TABLE_NAME','BEN_CSR_ACTIVITIES');

1530: fetch c24 into l_temp;
1531: if c24%found then
1532: close c24;
1533: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1534: fnd_message.set_token('TABLE_NAME','BEN_CSR_ACTIVITIES');
1535: fnd_message.raise_error;
1536: end if;
1537: --
1538: close c24;

Line 5646: delete from BEN_CSR_ACTIVITIES

5642:
5643: delete from BEN_COMP_ASSET
5644: where business_group_id = p_bg_id;
5645:
5646: delete from BEN_CSR_ACTIVITIES
5647: where business_group_id = p_bg_id;
5648:
5649: delete from BEN_ELIG_BRGNG_UNIT_PRTE_F
5650: where business_group_id = p_bg_id;