562: is select 1 from BEN_PL_REGN_F
563: where business_group_id = p_bg_id;
564:
565: cursor c142(p_bg_id NUMBER)
566: is select 1 from BEN_PL_REGY_BOD_F
567: where business_group_id = p_bg_id;
568:
569: cursor c143(p_bg_id NUMBER)
570: is select 1 from BEN_POPL_ACTN_TYP_F
3277: --
3278: close c141;
3279:
3280: --
3281: -- Testing for values in BEN_PL_REGY_BOD_F
3282: --
3283: open c142(p_bg_id);
3284: --
3285: fetch c142 into l_temp;
3285: fetch c142 into l_temp;
3286: if c142%found then
3287: close c142;
3288: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3289: fnd_message.set_token('TABLE_NAME','BEN_PL_REGY_BOD_F');
3290: fnd_message.raise_error;
3291: end if;
3292: --
3293: close c142;
5993:
5994: delete from BEN_PL_REGN_F
5995: where business_group_id = p_bg_id;
5996:
5997: delete from BEN_PL_REGY_BOD_F
5998: where business_group_id = p_bg_id;
5999:
6000: delete from BEN_POPL_ACTN_TYP_F
6001: where business_group_id = p_bg_id;
6479:
6480: delete from BEN_LE_CLSN_N_RSTR
6481: where organization_id = p_org_id;
6482:
6483: delete from BEN_PL_REGY_BOD_F
6484: where organization_id = p_org_id;
6485:
6486: delete from BEN_POPL_ORG_F
6487: where organization_id = p_org_id;