APPS.BEN_ORG_DELETE dependencies on BEN_FL_TM_PT_TM_RT_F

Line 722: is select 1 from BEN_FL_TM_PT_TM_RT_F

718: is select 1 from BEN_CRT_ORDR_CVRD_PER
719: where business_group_id = p_bg_id;
720:
721: cursor c181(p_bg_id NUMBER)
722: is select 1 from BEN_FL_TM_PT_TM_RT_F
723: where business_group_id = p_bg_id;
724:
725: cursor c182(p_bg_id NUMBER)
726: is select 1 from BEN_GNDR_RT_F

Line 3866: -- Testing for values in BEN_FL_TM_PT_TM_RT_F

3862: --
3863: close c180;
3864:
3865: --
3866: -- Testing for values in BEN_FL_TM_PT_TM_RT_F
3867: --
3868: open c181(p_bg_id);
3869: --
3870: fetch c181 into l_temp;

Line 3874: fnd_message.set_token('TABLE_NAME','BEN_FL_TM_PT_TM_RT_F');

3870: fetch c181 into l_temp;
3871: if c181%found then
3872: close c181;
3873: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3874: fnd_message.set_token('TABLE_NAME','BEN_FL_TM_PT_TM_RT_F');
3875: fnd_message.raise_error;
3876: end if;
3877: --
3878: close c181;

Line 6114: delete from BEN_FL_TM_PT_TM_RT_F

6110:
6111: delete from BEN_CRT_ORDR_CVRD_PER
6112: where business_group_id = p_bg_id;
6113:
6114: delete from BEN_FL_TM_PT_TM_RT_F
6115: where business_group_id = p_bg_id;
6116:
6117: delete from BEN_GNDR_RT_F
6118: where business_group_id = p_bg_id;