1519:
1520: delete from ZPB_BUSAREA_COMMENTS
1521: where BUSINESS_AREA_ID = p_business_area_id;
1522:
1523: delete from ZPB_MEASURE_SCOPE_EXEMPT_USERS
1524: where USER_ID in (select A.USER_ID from ZPB_MEASURE_SCOPE_EXEMPT_USERS A, ZPB_USERS B
1525: where B.BUSINESS_AREA_ID = p_business_area_id AND A.USER_ID = B.USER_ID);
1526:
1527: delete from ZPB_USERS
1520: delete from ZPB_BUSAREA_COMMENTS
1521: where BUSINESS_AREA_ID = p_business_area_id;
1522:
1523: delete from ZPB_MEASURE_SCOPE_EXEMPT_USERS
1524: where USER_ID in (select A.USER_ID from ZPB_MEASURE_SCOPE_EXEMPT_USERS A, ZPB_USERS B
1525: where B.BUSINESS_AREA_ID = p_business_area_id AND A.USER_ID = B.USER_ID);
1526:
1527: delete from ZPB_USERS
1528: where BUSINESS_AREA_ID = p_business_area_id;