APPS.BEN_ORG_DELETE dependencies on BEN_SVC_AREA_RT_F

Line 686: is select 1 from BEN_SVC_AREA_RT_F

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
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

Line 3731: -- Testing for values in BEN_SVC_AREA_RT_F

3727: --
3728: close c171;
3729:
3730: --
3731: -- Testing for values in BEN_SVC_AREA_RT_F
3732: --
3733: open c172(p_bg_id);
3734: --
3735: fetch c172 into l_temp;

Line 3739: fnd_message.set_token('TABLE_NAME','BEN_SVC_AREA_RT_F');

3735: fetch c172 into l_temp;
3736: if c172%found then
3737: close c172;
3738: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3739: fnd_message.set_token('TABLE_NAME','BEN_SVC_AREA_RT_F');
3740: fnd_message.raise_error;
3741: end if;
3742: --
3743: close c172;

Line 6087: delete from BEN_SVC_AREA_RT_F

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;
6089:
6090: delete from BEN_TBCO_USE_RT_F
6091: where business_group_id = p_bg_id;