APPS.EAM_OP_COMP_VALIDATE_PVT dependencies on EAM_OP_COMPLETION_TXNS

Line 218: from eam_op_completion_txns eoct,wip_operation_networks won

214:
215: --added for fix to bug 3543834:
216: CURSOR CON3 IS
217: select nvl(max(actual_end_date),sysdate-20000)
218: from eam_op_completion_txns eoct,wip_operation_networks won
219: where eoct.wip_entity_id = p_eam_op_comp_rec.wip_entity_id
220: and eoct.operation_seq_num=won.prior_operation
221: and won.wip_entity_id=eoct.wip_entity_id
222: and won.next_operation=p_eam_op_comp_rec.operation_seq_num

Line 225: from eam_op_completion_txns

221: and won.wip_entity_id=eoct.wip_entity_id
222: and won.next_operation=p_eam_op_comp_rec.operation_seq_num
223: and transaction_type=1
224: and transaction_id = (select max(transaction_id)
225: from eam_op_completion_txns
226: where wip_entity_id = p_eam_op_comp_rec.wip_entity_id
227: and operation_seq_num = eoct.operation_seq_num
228: );
229: