APPS.BEN_ORG_DELETE dependencies on BEN_TBCO_USE_RT_F

Line 690: is select 1 from BEN_TBCO_USE_RT_F

686: is select 1 from BEN_SVC_AREA_RT_F
687: where business_group_id = p_bg_id;
688:
689: cursor c173(p_bg_id NUMBER)
690: is select 1 from BEN_TBCO_USE_RT_F
691: where business_group_id = p_bg_id;
692:
693: cursor c174(p_bg_id NUMBER)
694: is select 1 from BEN_TTL_CVG_VOL_RT_F

Line 3746: -- Testing for values in BEN_TBCO_USE_RT_F

3742: --
3743: close c172;
3744:
3745: --
3746: -- Testing for values in BEN_TBCO_USE_RT_F
3747: --
3748: open c173(p_bg_id);
3749: --
3750: fetch c173 into l_temp;

Line 3754: fnd_message.set_token('TABLE_NAME','BEN_TBCO_USE_RT_F');

3750: fetch c173 into l_temp;
3751: if c173%found then
3752: close c173;
3753: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3754: fnd_message.set_token('TABLE_NAME','BEN_TBCO_USE_RT_F');
3755: fnd_message.raise_error;
3756: end if;
3757: --
3758: close c173;

Line 6090: delete from BEN_TBCO_USE_RT_F

6086:
6087: delete from BEN_SVC_AREA_RT_F
6088: where business_group_id = p_bg_id;
6089:
6090: delete from BEN_TBCO_USE_RT_F
6091: where business_group_id = p_bg_id;
6092:
6093: delete from BEN_TTL_CVG_VOL_RT_F
6094: where business_group_id = p_bg_id;