APPS.EAM_ASSET_NUMBER_PVT dependencies on MTL_OBJECT_GENEALOGY

Line 1904: (select object_id from mtl_object_genealogy

1900: end;
1901:
1902: begin
1903: insert into EAM_ASSET_RESULTS_GTT (gen_object_id)
1904: (select object_id from mtl_object_genealogy
1905: where genealogy_type = 5
1906: and (sysdate between NVL(start_date_active,sysdate-1) and NVL(end_date_active,sysdate+1))
1907: start with parent_object_id = asset.gen_object_id
1908: connect by parent_object_id = prior object_id