APPS.BEN_ORG_DELETE dependencies on BEN_ACTL_PREM_F

Line 714: is select 1 from BEN_ACTL_PREM_F

710: is select 1 from BEN_WK_LOC_RT_F
711: where business_group_id = p_bg_id;
712:
713: cursor c179(p_bg_id NUMBER)
714: is select 1 from BEN_ACTL_PREM_F
715: where business_group_id = p_bg_id;
716:
717: cursor c180(p_bg_id NUMBER)
718: is select 1 from BEN_CRT_ORDR_CVRD_PER

Line 3836: -- Testing for values in BEN_ACTL_PREM_F

3832: --
3833: close c178;
3834:
3835: --
3836: -- Testing for values in BEN_ACTL_PREM_F
3837: --
3838: open c179(p_bg_id);
3839: --
3840: fetch c179 into l_temp;

Line 3844: fnd_message.set_token('TABLE_NAME','BEN_ACTL_PREM_F');

3840: fetch c179 into l_temp;
3841: if c179%found then
3842: close c179;
3843: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3844: fnd_message.set_token('TABLE_NAME','BEN_ACTL_PREM_F');
3845: fnd_message.raise_error;
3846: end if;
3847: --
3848: close c179;

Line 6108: delete from BEN_ACTL_PREM_F

6104:
6105: delete from BEN_WK_LOC_RT_F
6106: where business_group_id = p_bg_id;
6107:
6108: delete from BEN_ACTL_PREM_F
6109: where business_group_id = p_bg_id;
6110:
6111: delete from BEN_CRT_ORDR_CVRD_PER
6112: where business_group_id = p_bg_id;

Line 6495: delete from BEN_ACTL_PREM_F

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;
6497:
6498: delete from BEN_PL_BNF_F
6499: where organization_id = p_org_id;