Inside WITH clause for Banner job and title

bannerjobtitle.sql

    select /*+ materialize */ nbrjobs_pidm as pidm,NBRJOBS_DESC as job_title,f_get_finance_desc ('FTVORGN', '1', NBRJOBS_ORGN_CODE_TS, 35) dept  from 
    (select nbrjobs_pidm,NBRJOBS_DESC,nbrjobs_posn,NBRJOBS_ORGN_CODE_TS,NBRJOBS_EFFECTIVE_DATE,rank() over
    (partition by nbrjobs_posn order by NBRJOBS_EFFECTIVE_DATE desc) efd_rank
    from nbrjobs
    inner join NBRBJOB on nbrjobs_pidm=nbrbjob_pidm and NBRBJOB_CONTRACT_TYPE = 'P' and NBRBJOB_POSN=nbrjobs_posn
    
    )
    where efd_rank = 1;