APPS.EAM_OPERATIONS_JSP dependencies on EAM_OP_COMPLETION_TXNS

Line 267: from eam_op_completion_txns

263:
264: IF p_transaction_type = 2 THEN
265: select actual_start_date ,actual_end_date ,actual_duration
266: into l_act_st_date ,l_act_end_date,l_act_duration
267: from eam_op_completion_txns
268: where
269: wip_entity_id = p_wip_entity_id and
270: operation_seq_num = p_operation_seq_num and
271: transaction_type = 1 and

Line 273: from eam_op_completion_txns

269: wip_entity_id = p_wip_entity_id and
270: operation_seq_num = p_operation_seq_num and
271: transaction_type = 1 and
272: last_update_date = (select max(last_update_date)
273: from eam_op_completion_txns
274: where wip_entity_id = p_wip_entity_id and
275: operation_seq_num = p_operation_seq_num and
276: transaction_type = 1);
277:

Line 753: from eam_op_completion_txns

749: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
750:
751:
752: select max(transaction_id) into l_transaction_id
753: from eam_op_completion_txns
754: where wip_entity_id = p_wip_entity_id
755: and operation_seq_num = p_old_op_seq_num;
756:
757: update eam_op_completion_txns

Line 757: update eam_op_completion_txns

753: from eam_op_completion_txns
754: where wip_entity_id = p_wip_entity_id
755: and operation_seq_num = p_old_op_seq_num;
756:
757: update eam_op_completion_txns
758: set handover_operation_seq_num = p_new_op_seq_num
759: where wip_entity_id = p_wip_entity_id
760: and operation_seq_num = p_old_op_seq_num
761: and transaction_id = l_transaction_id;