APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_SCHEDD_HRS_PRTE_F

Line 126: is select 1 from BEN_ELIG_SCHEDD_HRS_PRTE_F

122: is select 1 from BEN_ELIG_PYRL_PRTE_F
123: where business_group_id = p_bg_id;
124:
125: cursor c31(p_bg_id NUMBER)
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

Line 1631: -- Testing for values in BEN_ELIG_SCHEDD_HRS_PRTE_F

1627: --
1628: close c30;
1629:
1630: --
1631: -- Testing for values in BEN_ELIG_SCHEDD_HRS_PRTE_F
1632: --
1633: open c31(p_bg_id);
1634: --
1635: fetch c31 into l_temp;

Line 1639: fnd_message.set_token('TABLE_NAME','BEN_ELIG_SCHEDD_HRS_PRTE_F');

1635: fetch c31 into l_temp;
1636: if c31%found then
1637: close c31;
1638: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1639: fnd_message.set_token('TABLE_NAME','BEN_ELIG_SCHEDD_HRS_PRTE_F');
1640: fnd_message.raise_error;
1641: end if;
1642: --
1643: close c31;

Line 5667: delete from BEN_ELIG_SCHEDD_HRS_PRTE_F

5663:
5664: delete from BEN_ELIG_PYRL_PRTE_F
5665: where business_group_id = p_bg_id;
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;