APPS.EAM_OP_COMP_VALIDATE_PVT dependencies on WIP_OPERATION_NETWORKS

Line 189: from wip_operation_networks won

185: l_shutdown_type VARCHAR2(30);
186:
187: CURSOR CON IS
188: select count(won.prior_operation)
189: from wip_operation_networks won
190: where
191: won.wip_entity_id = p_eam_op_comp_rec.wip_entity_id and
192: won.next_operation = p_eam_op_comp_rec.operation_seq_num and
193: exists (

Line 203: from wip_operation_networks won

199: );
200:
201: CURSOR CON1 IS
202: select count(won.next_operation)
203: from wip_operation_networks won
204: where
205: won.wip_entity_id = p_eam_op_comp_rec.wip_entity_id and
206: won.prior_operation = p_eam_op_comp_rec.operation_seq_num and
207: exists (

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