select * from emp where job=v('P1_Job')

SELECT A.order_id,A.b_cod,A.c_cod,Converttounicode(B.NAME) NAME,A.order_type,
    Converttounicode(o.ord_name) ord_name,A.order_numb,A.date_created,A.date_begin,
A.date_end,Converttounicode(A.commentary) commentary,A.percent_summ,
    B.dep_code,Converttounicode(B.dep_name) dep_name,B.title_code,Converttounicode (B.title) title
    FROM cadres.orders@testbase A,cadres.V_EMPLOYEES_DEPARTMENTS@testbase b,cadres.order_types@testbase o
      WHERE A.client_cod=b.cod(+)
      AND A.order_type=o.ord_code
and a.client_cod =v('P2_C_COD')
and a.bank_cod=v('P2_B_CODE')
and a.order_type=v('P2_ORDER_TYPE')