APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on MTL_OBJECT_GENEALOGY

Line 6210: FROM mtl_object_genealogy mog

6206: l_current_status NUMBER; -- added for 6176621
6207:
6208: CURSOR mog_cur(p_gen_object_id IN number) IS
6209: SELECT 'Y'
6210: FROM mtl_object_genealogy mog
6211: WHERE mog.parent_object_type = 2
6212: AND (mog.object_id = p_gen_object_id OR mog.parent_object_id = p_gen_object_id)
6213: AND mog.object_type = 2
6214: AND sysdate BETWEEN nvl(mog.start_date_active, sysdate-1)