APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_PER_TYP_PRTE_F

Line 118: is select 1 from BEN_ELIG_PER_TYP_PRTE_F

114: is select 1 from BEN_ELIG_LBR_MMBR_PRTE_F
115: where business_group_id = p_bg_id;
116:
117: cursor c29(p_bg_id NUMBER)
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

Line 1601: -- Testing for values in BEN_ELIG_PER_TYP_PRTE_F

1597: --
1598: close c28;
1599:
1600: --
1601: -- Testing for values in BEN_ELIG_PER_TYP_PRTE_F
1602: --
1603: open c29(p_bg_id);
1604: --
1605: fetch c29 into l_temp;

Line 1609: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PER_TYP_PRTE_F');

1605: fetch c29 into l_temp;
1606: if c29%found then
1607: close c29;
1608: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1609: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PER_TYP_PRTE_F');
1610: fnd_message.raise_error;
1611: end if;
1612: --
1613: close c29;

Line 5661: delete from BEN_ELIG_PER_TYP_PRTE_F

5657:
5658: delete from BEN_ELIG_LBR_MMBR_PRTE_F
5659: where business_group_id = p_bg_id;
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;