[Home] [Help]
339: and object_type = 'PROCESS'
340: and deletion_date is not null
341: and deletion_approval_date is null;
342:
343: update amw_objective_associations
344: set approval_date = APPROV_TXN_DATE
345: where pk1 = p_process_id
346: and object_type in ('PROCESS', 'CONTROL')
347: and approval_date is null;
345: where pk1 = p_process_id
346: and object_type in ('PROCESS', 'CONTROL')
347: and approval_date is null;
348:
349: update amw_objective_associations
350: set deletion_approval_date = APPROV_TXN_DATE
351: where pk1 = p_process_id
352: and object_type in ('PROCESS', 'CONTROL')
353: and deletion_date is not null