29: SELECT apr.appraisal_id,
30: apr.fiscal_year,
31: cur.currency_code
32: FROM jl_co_fa_appraisals apr,
33: fnd_currencies_active_v cur
34: WHERE apr.appraisal_id = nvl (p_appraisal_id, apr.appraisal_id)
35: AND apr.currency_code = cur.currency_code(+)
36: AND appraisal_status NOT IN ('V','P')
37: FOR UPDATE OF appraisal_status;