29: wor.UOM_CODE,
30: l_hrUom,
31: NULL,
32: NULL ))
33: FROM wip_operation_resources_v wor
34: WHERE wor.wip_entity_id = p_wip_entity_id
35: AND wor.UOM_CODE in (SELECT UOM_CODE
36: FROM mtl_units_of_measure
37: WHERE UOM_CLASS = l_uomclass)
75: l_hrUOM,
76: NULL,
77: NULL ))
78: INTO l_scheduled_hours
79: FROM wip_operation_resources_v wor
80: WHERE wor.wip_entity_id = p_wip_entity_id
81: AND wor.UOM_CODE in (SELECT UOM_CODE
82: FROM mtl_units_of_measure
83: WHERE UOM_CLASS = l_uomclass);