APPS.EAM_ASSET_NUM_IMPORT_PUB dependencies on MTL_OBJECT_GENEALOGY

Line 282: (select * from mtl_object_genealogy

278:
279: begin
280: select 'Y' into l_hr_exists from dual
281: where exists
282: (select * from mtl_object_genealogy
283: where object_id = l_gen_object_id);
284: exception when no_data_found then
285: l_hr_exists := 'N';
286: end;

Line 299: FROM mtl_object_genealogy mog, mtl_serial_numbers msn

295: SELECT mog.start_date_active start_date_active,
296: mog.end_date_active
297: end_date_active, msn.serial_number
298: parent_serial_number
299: FROM mtl_object_genealogy mog, mtl_serial_numbers msn
300: WHERE mog.object_id = l_gen_object_id
301: and msn.gen_object_id = mog.parent_object_id
302: and mog.genealogy_type = 5;
303: