APPS.BEN_ORG_DELETE dependencies on BEN_HRLY_SLRD_RT_F

Line 734: is select 1 from BEN_HRLY_SLRD_RT_F

730: is select 1 from BEN_GRADE_RT_F
731: where business_group_id = p_bg_id;
732:
733: cursor c184(p_bg_id NUMBER)
734: is select 1 from BEN_HRLY_SLRD_RT_F
735: where business_group_id = p_bg_id;
736:
737: cursor c185(p_bg_id NUMBER)
738: is select 1 from BEN_HRS_WKD_IN_PERD_RT_F

Line 3911: -- Testing for values in BEN_HRLY_SLRD_RT_F

3907: --
3908: close c183;
3909:
3910: --
3911: -- Testing for values in BEN_HRLY_SLRD_RT_F
3912: --
3913: open c184(p_bg_id);
3914: --
3915: fetch c184 into l_temp;

Line 3919: fnd_message.set_token('TABLE_NAME','BEN_HRLY_SLRD_RT_F');

3915: fetch c184 into l_temp;
3916: if c184%found then
3917: close c184;
3918: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3919: fnd_message.set_token('TABLE_NAME','BEN_HRLY_SLRD_RT_F');
3920: fnd_message.raise_error;
3921: end if;
3922: --
3923: close c184;

Line 6123: delete from BEN_HRLY_SLRD_RT_F

6119:
6120: delete from BEN_GRADE_RT_F
6121: where business_group_id = p_bg_id;
6122:
6123: delete from BEN_HRLY_SLRD_RT_F
6124: where business_group_id = p_bg_id;
6125:
6126: delete from BEN_HRS_WKD_IN_PERD_RT_F
6127: where business_group_id = p_bg_id;