223:
224: --added for fix to bug 3543834:
225: CURSOR CON3 IS
226: select nvl(max(actual_end_date),sysdate-20000)
227: from eam_op_completion_txns eoct,wip_operation_networks won
228: where eoct.wip_entity_id = p_eam_op_comp_rec.wip_entity_id
229: and eoct.operation_seq_num=won.prior_operation
230: and won.wip_entity_id=eoct.wip_entity_id
231: and won.next_operation=p_eam_op_comp_rec.operation_seq_num
230: and won.wip_entity_id=eoct.wip_entity_id
231: and won.next_operation=p_eam_op_comp_rec.operation_seq_num
232: and transaction_type=1
233: and transaction_id = (select max(transaction_id)
234: from eam_op_completion_txns
235: where wip_entity_id = p_eam_op_comp_rec.wip_entity_id
236: and operation_seq_num = eoct.operation_seq_num
237: );
238: