APPS.BEN_ORG_DELETE dependencies on BEN_COMP_ASSET

Line 94: is select 1 from BEN_COMP_ASSET

90: is select 1 from BEN_CNTNG_PRTN_ELIG_PRFL_F
91: where business_group_id = p_bg_id;
92:
93: cursor c23(p_bg_id NUMBER)
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

Line 1511: -- Testing for values in BEN_COMP_ASSET

1507: --
1508: close c22;
1509:
1510: --
1511: -- Testing for values in BEN_COMP_ASSET
1512: --
1513: open c23(p_bg_id);
1514: --
1515: fetch c23 into l_temp;

Line 1519: fnd_message.set_token('TABLE_NAME','BEN_COMP_ASSET');

1515: fetch c23 into l_temp;
1516: if c23%found then
1517: close c23;
1518: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1519: fnd_message.set_token('TABLE_NAME','BEN_COMP_ASSET');
1520: fnd_message.raise_error;
1521: end if;
1522: --
1523: close c23;

Line 5643: delete from BEN_COMP_ASSET

5639:
5640: delete from BEN_CNTNG_PRTN_ELIG_PRFL_F
5641: where business_group_id = p_bg_id;
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;