How to get request_id of previous request in a request set?

  FUNCTION get_prev_req_id(p_conc_program IN VARCHAR2) RETURN VARCHAR2
  IS
    l_parent_req_id         NUMBER;
    l_request_id            NUMBER;
  BEGIN
    SELECT parent_request_id
      INTO l_parent_req_id
      FROM fnd_concurrent_requests
     WHERE request_id = FND_PROFILE.VALUE('CONC_REQUEST_ID');
    FOR c IN (SELECT request_id,fcpt.user_concurrent_program_name
                FROM (SELECT     request_id, concurrent_program_id
                            FROM fnd_concurrent_requests aaa
                      START WITH request_id = l_parent_req_id
                      CONNECT BY PRIOR request_id = parent_request_id) cps, fnd_concurrent_programs_tl fcpt
               WHERE cps.concurrent_program_id = fcpt.concurrent_program_id
                 AND fcpt.user_concurrent_program_name LIKE p_conc_program
               ORDER BY request_id)
    LOOP
      l_request_id := c.request_id;
      EXIT;
    END LOOP;
    RETURN l_request_id ;
  END;