APPS.BEN_ORG_DELETE dependencies on BEN_CMBN_AGE_LOS_FCTR

Line 174: is select 1 from BEN_CMBN_AGE_LOS_FCTR

170: is select 1 from BEN_YR_PERD
171: where business_group_id = p_bg_id;
172:
173: cursor c43(p_bg_id NUMBER)
174: is select 1 from BEN_CMBN_AGE_LOS_FCTR
175: where business_group_id = p_bg_id;
176:
177: cursor c44(p_bg_id NUMBER)
178: is select 1 from BEN_CM_DLVRY_MTHD_TYP

Line 1811: -- Testing for values in BEN_CMBN_AGE_LOS_FCTR

1807: --
1808: close c42;
1809:
1810: --
1811: -- Testing for values in BEN_CMBN_AGE_LOS_FCTR
1812: --
1813: open c43(p_bg_id);
1814: --
1815: fetch c43 into l_temp;

Line 1819: fnd_message.set_token('TABLE_NAME','BEN_CMBN_AGE_LOS_FCTR');

1815: fetch c43 into l_temp;
1816: if c43%found then
1817: close c43;
1818: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1819: fnd_message.set_token('TABLE_NAME','BEN_CMBN_AGE_LOS_FCTR');
1820: fnd_message.raise_error;
1821: end if;
1822: --
1823: close c43;

Line 5703: delete from BEN_CMBN_AGE_LOS_FCTR

5699:
5700: delete from BEN_YR_PERD
5701: where business_group_id = p_bg_id;
5702:
5703: delete from BEN_CMBN_AGE_LOS_FCTR
5704: where business_group_id = p_bg_id;
5705:
5706: delete from BEN_CM_DLVRY_MTHD_TYP
5707: where business_group_id = p_bg_id;