APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_BRGNG_UNIT_PRTE_F

Line 102: is select 1 from BEN_ELIG_BRGNG_UNIT_PRTE_F

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
103: where business_group_id = p_bg_id;
104:
105: cursor c26(p_bg_id NUMBER)
106: is select 1 from BEN_ELIG_FL_TM_PT_TM_PRTE_F

Line 1541: -- Testing for values in BEN_ELIG_BRGNG_UNIT_PRTE_F

1537: --
1538: close c24;
1539:
1540: --
1541: -- Testing for values in BEN_ELIG_BRGNG_UNIT_PRTE_F
1542: --
1543: open c25(p_bg_id);
1544: --
1545: fetch c25 into l_temp;

Line 1549: fnd_message.set_token('TABLE_NAME','BEN_ELIG_BRGNG_UNIT_PRTE_F');

1545: fetch c25 into l_temp;
1546: if c25%found then
1547: close c25;
1548: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1549: fnd_message.set_token('TABLE_NAME','BEN_ELIG_BRGNG_UNIT_PRTE_F');
1550: fnd_message.raise_error;
1551: end if;
1552: --
1553: close c25;

Line 5649: delete from BEN_ELIG_BRGNG_UNIT_PRTE_F

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;
5651:
5652: delete from BEN_ELIG_FL_TM_PT_TM_PRTE_F
5653: where business_group_id = p_bg_id;