DBA Data[Home] [Help]

APPS.ZPB_BUSAREA_MAINT dependencies on ZPB_MEASURE_SCOPE_EXEMPT_USERS

Line 1523: delete from ZPB_MEASURE_SCOPE_EXEMPT_USERS

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

Line 1524: where USER_ID in (select A.USER_ID from ZPB_MEASURE_SCOPE_EXEMPT_USERS A, ZPB_USERS B

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;