998: Begin
999:
1000: select br.resource_type, wip_ws_time_entry.is_time_uom(br.unit_of_measure)
1001: into l_resource_type, l_is_time_uom
1002: from bom_resources br
1003: where br.organization_id = p_organization_id
1004: and br.resource_id = p_resource_id;
1005:
1006: if( l_is_time_uom = 'Y') then
1139: l_instance_name varchar2(255);
1140:
1141: cursor resource_type_cursor is
1142: select resource_type
1143: from bom_resources br
1144: where resource_id = p_resource_id;
1145:
1146: cursor emp_id_cursor is
1147: select person_id