APPS.BEN_ORG_DELETE dependencies on BEN_ORG_UNIT_RT_F

Line 658: is select 1 from BEN_ORG_UNIT_RT_F

654: is select 1 from BEN_LOS_RT_F
655: where business_group_id = p_bg_id;
656:
657: cursor c165(p_bg_id NUMBER)
658: is select 1 from BEN_ORG_UNIT_RT_F
659: where business_group_id = p_bg_id;
660:
661: cursor c166(p_bg_id NUMBER)
662: is select 1 from BEN_PCT_FL_TM_RT_F

Line 3626: -- Testing for values in BEN_ORG_UNIT_RT_F

3622: --
3623: close c164;
3624:
3625: --
3626: -- Testing for values in BEN_ORG_UNIT_RT_F
3627: --
3628: open c165(p_bg_id);
3629: --
3630: fetch c165 into l_temp;

Line 3634: fnd_message.set_token('TABLE_NAME','BEN_ORG_UNIT_RT_F');

3630: fetch c165 into l_temp;
3631: if c165%found then
3632: close c165;
3633: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3634: fnd_message.set_token('TABLE_NAME','BEN_ORG_UNIT_RT_F');
3635: fnd_message.raise_error;
3636: end if;
3637: --
3638: close c165;

Line 6066: delete from BEN_ORG_UNIT_RT_F

6062:
6063: delete from BEN_LOS_RT_F
6064: where business_group_id = p_bg_id;
6065:
6066: delete from BEN_ORG_UNIT_RT_F
6067: where business_group_id = p_bg_id;
6068:
6069: delete from BEN_PCT_FL_TM_RT_F
6070: where business_group_id = p_bg_id;

Line 6492: delete from BEN_ORG_UNIT_RT_F

6488:
6489: delete from BEN_LGL_ENTY_RT_F
6490: where organization_id = p_org_id;
6491:
6492: delete from BEN_ORG_UNIT_RT_F
6493: where organization_id = p_org_id;
6494:
6495: delete from BEN_ACTL_PREM_F
6496: where organization_id = p_org_id;