APPS.EAM_WO_COMP_VALIDATE_PVT dependencies on EAM_OP_COMPLETION_TXNS

Line 359: from eam_op_completion_txns eoct

355:
356: /* Fix for Bug 2100416 */
357: select nvl(max(actual_end_date), sysdate - 200000)
358: into l_max_compl_op_date
359: from eam_op_completion_txns eoct
360: where wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
361: --fix for 3543834.added where clause so that the last completion date will be fetched if the operation is complete
362: and transaction_type=1
363: and transaction_id = (select max(transaction_id)

Line 364: from eam_op_completion_txns

360: where wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
361: --fix for 3543834.added where clause so that the last completion date will be fetched if the operation is complete
362: and transaction_type=1
363: and transaction_id = (select max(transaction_id)
364: from eam_op_completion_txns
365: where wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
366: and operation_seq_num = eoct.operation_seq_num
367: );
368: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Allowing for completed operations'); END IF;

Line 372: from eam_op_completion_txns eoct

368: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Allowing for completed operations'); END IF;
369: /* Fix for bug no:2730242 */
370: select nvl(min(actual_start_date), sysdate + 200000)
371: into l_min_compl_op_date
372: from eam_op_completion_txns eoct
373: where wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
374: --fix for 3543834.added where clause so that the last completion date will be fetched if the operation is complete
375: and transaction_type=1
376: and transaction_id = (select max(transaction_id)

Line 377: from eam_op_completion_txns

373: where wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
374: --fix for 3543834.added where clause so that the last completion date will be fetched if the operation is complete
375: and transaction_type=1
376: and transaction_id = (select max(transaction_id)
377: from eam_op_completion_txns
378: where wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
379: and operation_seq_num = eoct.operation_seq_num
380: );
381: