APPS.BEN_ORG_DELETE dependencies on BEN_CRT_ORDR_CVRD_PER

Line 718: is select 1 from BEN_CRT_ORDR_CVRD_PER

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
719: where business_group_id = p_bg_id;
720:
721: cursor c181(p_bg_id NUMBER)
722: is select 1 from BEN_FL_TM_PT_TM_RT_F

Line 3851: -- Testing for values in BEN_CRT_ORDR_CVRD_PER

3847: --
3848: close c179;
3849:
3850: --
3851: -- Testing for values in BEN_CRT_ORDR_CVRD_PER
3852: --
3853: open c180(p_bg_id);
3854: --
3855: fetch c180 into l_temp;

Line 3859: fnd_message.set_token('TABLE_NAME','BEN_CRT_ORDR_CVRD_PER');

3855: fetch c180 into l_temp;
3856: if c180%found then
3857: close c180;
3858: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3859: fnd_message.set_token('TABLE_NAME','BEN_CRT_ORDR_CVRD_PER');
3860: fnd_message.raise_error;
3861: end if;
3862: --
3863: close c180;

Line 6111: delete from BEN_CRT_ORDR_CVRD_PER

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;
6113:
6114: delete from BEN_FL_TM_PT_TM_RT_F
6115: where business_group_id = p_bg_id;