APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_FL_TM_PT_TM_PRTE_F

Line 106: is select 1 from BEN_ELIG_FL_TM_PT_TM_PRTE_F

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
107: where business_group_id = p_bg_id;
108:
109: cursor c27(p_bg_id NUMBER)
110: is select 1 from BEN_ELIG_HRLY_SLRD_PRTE_F

Line 1556: -- Testing for values in BEN_ELIG_FL_TM_PT_TM_PRTE_F

1552: --
1553: close c25;
1554:
1555: --
1556: -- Testing for values in BEN_ELIG_FL_TM_PT_TM_PRTE_F
1557: --
1558: open c26(p_bg_id);
1559: --
1560: fetch c26 into l_temp;

Line 1564: fnd_message.set_token('TABLE_NAME','BEN_ELIG_FL_TM_PT_TM_PRTE_F');

1560: fetch c26 into l_temp;
1561: if c26%found then
1562: close c26;
1563: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1564: fnd_message.set_token('TABLE_NAME','BEN_ELIG_FL_TM_PT_TM_PRTE_F');
1565: fnd_message.raise_error;
1566: end if;
1567: --
1568: close c26;

Line 5652: delete from BEN_ELIG_FL_TM_PT_TM_PRTE_F

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;
5654:
5655: delete from BEN_ELIG_HRLY_SLRD_PRTE_F
5656: where business_group_id = p_bg_id;