APPS.EAM_ASSET_NUM_IMPORT_PUB dependencies on MTL_OBJECT_GENEALOGY

Line 276: (select * from mtl_object_genealogy

272:
273: begin
274: select 'Y' into l_hr_exists from dual
275: where exists
276: (select * from mtl_object_genealogy
277: where object_id = l_gen_object_id);
278: exception when no_data_found then
279: l_hr_exists := 'N';
280: end;

Line 293: FROM mtl_object_genealogy mog, mtl_serial_numbers msn

289: SELECT mog.start_date_active start_date_active,
290: mog.end_date_active
291: end_date_active, msn.serial_number
292: parent_serial_number
293: FROM mtl_object_genealogy mog, mtl_serial_numbers msn
294: WHERE mog.object_id = l_gen_object_id
295: and msn.gen_object_id = mog.parent_object_id
296: and mog.genealogy_type = 5;
297: