[Home] [Help]
1604: CURSOR c_rev(p_change_id NUMBER)
1605: IS
1606: SELECT revision_id
1607: , revision
1608: FROM ENG_CHANGE_ORDER_REVISIONS
1609: WHERE start_date <= SYSDATE
1610: AND (end_date >= TRUNC(SYSDATE) OR end_date IS NULL)
1611: AND change_id = p_change_id
1612: ORDER BY revision ;