557: --
558: CURSOR csr_find_lowest_phase
559: IS
560: SELECT to_number(substr(lok.lookup_code,2)) action_num 561: FROM hr_lookups lok 562: WHERE lok.lookup_type = 'EFC_PROGRESS_STATUS'
563: AND substr(lok.lookup_code,1,1) = 'C'
564: ORDER BY lok.lookup_code;
565: --