SELECT * FROM user_objects WHERE object_type='PACKAGE' AND status = 'INVALID'

OBJECT_NAME | SUBOBJECT_NAME | OBJECT_ID | DATA_OBJECT_ID | OBJECT_TYPE | CREATED | LAST_DDL_TIME | TIMESTAMP | STATUS | TEMPORARY | GENERATED | SECONDARY
EPMFTVALIDATORPK | null | 11323 | null | PACKAGE | 2006-10-27 00:59:10.0 | 2006-10-28 03:43:48.0 | 2006-10-28:03:43:42 | INVALID | N | N | N
EPMSUPPORTINGDATAPK | null | 11298 | null | PACKAGE | 2006-10-27 00:59:03.0 | 2006-10-28 03:43:48.0 | 2006-10-28:03:43:48 | INVALID | N | N | N
EPM_FAMILY_TABLE_UTILS | null | 11341 | null | PACKAGE | 2006-10-27 00:59:15.0 | 2006-10-28 04:05:06.0 | 2006-10-28:04:05:06 | INVALID | N | N | N