APPS.BEN_ORG_DELETE dependencies on BEN_GNDR_RT_F

Line 726: is select 1 from BEN_GNDR_RT_F

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
727: where business_group_id = p_bg_id;
728:
729: cursor c183(p_bg_id NUMBER)
730: is select 1 from BEN_GRADE_RT_F

Line 3881: -- Testing for values in BEN_GNDR_RT_F

3877: --
3878: close c181;
3879:
3880: --
3881: -- Testing for values in BEN_GNDR_RT_F
3882: --
3883: open c182(p_bg_id);
3884: --
3885: fetch c182 into l_temp;

Line 3889: fnd_message.set_token('TABLE_NAME','BEN_GNDR_RT_F');

3885: fetch c182 into l_temp;
3886: if c182%found then
3887: close c182;
3888: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3889: fnd_message.set_token('TABLE_NAME','BEN_GNDR_RT_F');
3890: fnd_message.raise_error;
3891: end if;
3892: --
3893: close c182;

Line 6117: delete from BEN_GNDR_RT_F

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;
6119:
6120: delete from BEN_GRADE_RT_F
6121: where business_group_id = p_bg_id;