APPS.EAM_WORKORDER_UTIL_PKG dependencies on EAM_WO_WORKFLOWS

Line 1904: and ewod.wip_entity_id = (select wip_entity_id from EAM_WO_WORKFLOWS where wf_item_key=p_item_key);

1900: from eam_work_order_details ewod, wip_discrete_jobs wdj
1901: where wdj.status_type not in (3,4,5,12)
1902: and ewod.pending_flag = 'Y'
1903: and ewod.wip_entity_id = wdj.wip_entity_id
1904: and ewod.wip_entity_id = (select wip_entity_id from EAM_WO_WORKFLOWS where wf_item_key=p_item_key);
1905:
1906: EXCEPTION
1907: WHEN OTHERS THEN
1908: l_temp :=0;