APPS.BEN_ORG_DELETE dependencies on BEN_HRS_WKD_IN_PERD_RT_F

Line 738: is select 1 from BEN_HRS_WKD_IN_PERD_RT_F

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
739: where business_group_id = p_bg_id;
740:
741: cursor c186(p_bg_id NUMBER)
742: is select 1 from BEN_LBR_MMBR_RT_F

Line 3926: -- Testing for values in BEN_HRS_WKD_IN_PERD_RT_F

3922: --
3923: close c184;
3924:
3925: --
3926: -- Testing for values in BEN_HRS_WKD_IN_PERD_RT_F
3927: --
3928: open c185(p_bg_id);
3929: --
3930: fetch c185 into l_temp;

Line 3934: fnd_message.set_token('TABLE_NAME','BEN_HRS_WKD_IN_PERD_RT_F');

3930: fetch c185 into l_temp;
3931: if c185%found then
3932: close c185;
3933: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3934: fnd_message.set_token('TABLE_NAME','BEN_HRS_WKD_IN_PERD_RT_F');
3935: fnd_message.raise_error;
3936: end if;
3937: --
3938: close c185;

Line 6126: delete from BEN_HRS_WKD_IN_PERD_RT_F

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;
6128:
6129: delete from BEN_LBR_MMBR_RT_F
6130: where business_group_id = p_bg_id;