APPS.EAM_ASSET_NUMBER_PVT dependencies on MTL_OBJECT_GENEALOGY

Line 1877: (select object_id from mtl_object_genealogy

1873: end;
1874:
1875: begin
1876: insert into EAM_ASSET_RESULTS_GTT (gen_object_id)
1877: (select object_id from mtl_object_genealogy
1878: where genealogy_type = 5
1879: and (sysdate between NVL(start_date_active,sysdate-1) and NVL(end_date_active,sysdate+1))
1880: start with parent_object_id = asset.gen_object_id
1881: connect by parent_object_id = prior object_id