APPS.BEN_ORG_DELETE dependencies on BEN_SCHEDD_HRS_RT_F

Line 682: is select 1 from BEN_SCHEDD_HRS_RT_F

678: is select 1 from BEN_PYRL_RT_F
679: where business_group_id = p_bg_id;
680:
681: cursor c171(p_bg_id NUMBER)
682: is select 1 from BEN_SCHEDD_HRS_RT_F
683: where business_group_id = p_bg_id;
684:
685: cursor c172(p_bg_id NUMBER)
686: is select 1 from BEN_SVC_AREA_RT_F

Line 3716: -- Testing for values in BEN_SCHEDD_HRS_RT_F

3712: --
3713: close c170;
3714:
3715: --
3716: -- Testing for values in BEN_SCHEDD_HRS_RT_F
3717: --
3718: open c171(p_bg_id);
3719: --
3720: fetch c171 into l_temp;

Line 3724: fnd_message.set_token('TABLE_NAME','BEN_SCHEDD_HRS_RT_F');

3720: fetch c171 into l_temp;
3721: if c171%found then
3722: close c171;
3723: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3724: fnd_message.set_token('TABLE_NAME','BEN_SCHEDD_HRS_RT_F');
3725: fnd_message.raise_error;
3726: end if;
3727: --
3728: close c171;

Line 6084: delete from BEN_SCHEDD_HRS_RT_F

6080:
6081: delete from BEN_PYRL_RT_F
6082: where business_group_id = p_bg_id;
6083:
6084: delete from BEN_SCHEDD_HRS_RT_F
6085: where business_group_id = p_bg_id;
6086:
6087: delete from BEN_SVC_AREA_RT_F
6088: where business_group_id = p_bg_id;