APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_PYRL_PRTE_F

Line 122: is select 1 from BEN_ELIG_PYRL_PRTE_F

118: is select 1 from BEN_ELIG_PER_TYP_PRTE_F
119: where business_group_id = p_bg_id;
120:
121: cursor c30(p_bg_id NUMBER)
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

Line 1616: -- Testing for values in BEN_ELIG_PYRL_PRTE_F

1612: --
1613: close c29;
1614:
1615: --
1616: -- Testing for values in BEN_ELIG_PYRL_PRTE_F
1617: --
1618: open c30(p_bg_id);
1619: --
1620: fetch c30 into l_temp;

Line 1624: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PYRL_PRTE_F');

1620: fetch c30 into l_temp;
1621: if c30%found then
1622: close c30;
1623: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1624: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PYRL_PRTE_F');
1625: fnd_message.raise_error;
1626: end if;
1627: --
1628: close c30;

Line 5664: delete from BEN_ELIG_PYRL_PRTE_F

5660:
5661: delete from BEN_ELIG_PER_TYP_PRTE_F
5662: where business_group_id = p_bg_id;
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;