streams : capture parent column based on child for delete
I am using oracle 12.1.0.2.
We have streams process that captures organizations (org_pk) whose records changed for DML (I/U/D) for a subset of tables For one of the tables, I need to capture org_pk based on status_code column of its child table. I am able to simply SELECT this value when lcr.GET_COMMAND_TYPE() = 'INSERT' and 'UPDATE'. However, for 'DELETE', I am not able to select child's status_code as the record is already deleted when parent is deleted.
Please suggest how can I handle capturing a column in parent for DELETE based on status_code column of child table.