ROS.60050(r    !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~jjKMGRhl Zp\bc(fpjpj@j0n8p8rtuvxz000000p0LB_JOB* Zp\cd(jpnpn@n0r8t8vxyzx~000000p04B_COMME* Zp\ef(jpnpn@n0r8t8vxyzx~000000p0pwB_DEPTNO      1   n   z                            z BpDTU(VpZpZ0Z0[@^8bdefg0h0i0j0k0l0mn0o0pqrstuvwxM_G_EMPNO_GRPFR  h0v BpDRS TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstM_G_EMPNO_HDRhp\v BpDNO(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstR_G_EMPNORhz# JpLTU(VpZpZ0Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_EMPNOiBaz# JpLTU(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_ENAMElz# JpLRS(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_JOB6o0zz# JpLRS(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_MGR Tr# JpLWX(^pbpb8b8d8f8hjklmnopqr0s0t0upvpv0vwxyz{|}~F_HIREDATE Tjuou# JpLRS(VpZpZ@Z8^8`8bdefghijkl0m0n0oppp0F_SAL TExLNNNGNNNGNNNGNN0EN# JpLST(Zp^p^@^8b8d8fhijklmnop0q0r0sptpv0vwxyz{|}~F_COMME{N# JpLUV(Zp^p^@^8b8d8fhijklmnop0q0r0sptpv0vwxyz{|}~F_DEPTNO~N}~ 000000ppppppp:DESFORMATdfltDestination Format (/ bpdlmnopqprrpspsstu vx0y0z0{0|0}0~ppppppp;DESNAMEDestination Name00/ bpdlmnopqprrpspzz{|}~000000pppppppp?p?pB0BC0p8r8tvwxx~000000p0lbpcghijIREDATE jTjrMGRhlZp[ab(fpjpj@j0n8p8rtuvxz000000p0B_JOBj*Zp[bc(fpjpj@j0n8p8rtuvxz000000p002B_COMMEj*Zp[de(fpjpj@j0n8p8rtuvxz000000p0psB_DEPTNOj         m   v                            ~BpCST(Zp^p^0^0_@b8fhijk0l0m0n0o0p0qr0s0tuvwxyz{|M_G_EMPNO_GRPFRp hvBpCQR TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstM_G_EMPNO_HDRphpnvBpCMN(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstR_G_EMPNORh~#JpKST(Zp^p^0^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_EMPNOind~#JpKST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_ENAMElTAz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_JOB6opz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_MGR Tr/~#JpKVW(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_HIREDATE juou#JpKQR(VpZpZ@Z8^8`8bdefghijkl0m0n0oppp0F_SAL TExLNNNGNNNGNNNGNN0NC~#JpKRS(VpZpZ@Z8^8`8bdefghijkl0m0n0opppr0rstuvwxyz{|F_COMME{N~#JpKTU(VpZpZ@Z8^8`8bdefghijkl0m0n0opppr0rstuvwxyz{|F_DEPTNO~N}~ 000000pppppppaDESFORMATdfltDestination Format/bpcklmnoppvvpwpwwxy z|0}0~0000pppppppbDESNAMEDestination Name/bpcklmnoppvvpwp~~000000pppppppcDESTYPEScreenPDestination Type/bpcijklmnprrpspsstuvw0x0y0z0{0|0}p~  ppppppiEMPNOhj!Empno`'on TEMPNO/bpcijklmnprrpspsstuvw0x0y0z0{0|0}p~( pppppplENAMEhm !Ename`'ENAME/bpcghijklprrpspsstuvw0x0y0z0{0|0}p~( ppppppoJOBhp !Job_'JOB * , .0 00r100g100b100 00r88g75b100208x * , .0  00r100g75b100x0r 88pj pU 2jk0l0m0n8p8rt v0x0yz{0|}~ppppppppqrrr*r*r*r*r*r**r+r..r2r::;r



GXJNPRM0B(F0JK@N@R@V@Z0^0_0`0a0b0cd0e0fgh0i0j0klmnoppppfr*r*r@@P@Report ParametersEnter values for the parameters0$00x !"black(00x " $&white%00x "#green)00x# $&'e darkgreenuv(00x " $&0gray96 = = =(00x " $&gray92zzz(00x " $&gray88(00x " $&gray84(((%00x !"# r0g0b0(00x "$%& r25g0b0@(00x "$%& r50g0b0(00x "$%& r75g0b0(00x "$%& r88g0b0(00x "$%& r100g0b0(00x!" $&r0g0b50*00x "$ &(0lr25g0b50@v*00x "$ &(FRr50g0b50*00x "$ &(r75g0b500V*00x "$ &(jr88g0b50t,00x $& (* r100g0b50(00x!" $&0Vr0g0b75*00x "$ &(rr25g0b75@*00x "$ &(r50g0b75pK*00x "$ &(jr75g0b750r*00x "$ &(NOr88g0b75,00x $& (* r100g0b75(00x!" $&0pr0g0b88*00x "$ &(r25g0b88@*00x "$ &(pKr50g0b88b*00x "$ &(0nr75g0b88x*00x "$ &(r88g0b88p,00x $& (*8^ r100g0b88(00x"# $&v r0g0b100,00x $& (*! r25g0b100@,00x $& (*j" r50g0b100,00x $& (*ED# r75g0b100,00x $& (*$ r88g0b100,00x $& (*0n% r100g0b100&00x  "$&gray*00x " $ &('darkgraypK&00x "$h(cyanrpp*00x" $ &(_C)darkcyan(00x " $&*gray80333333(00x " $&j+gray76=p=p=p(00x " $&TN,gray72GGG(00x " $&}-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@D)00x " $&'0r50g25b0@/)00x " $&'x1r75g25b0@p)00x " $&'p2r88g25b0@+00x $ &()3 r100g25b0@m*00x" $ &(4r0g25b50@p,00x $ & (*05 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*ti7 r75g25b50@,00x $ & (*pc8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(MP:r0g25b750@,00x $ & (* T; r25g25b75@@,00x $ & (*t< r50g25b75@,00x $ & (*p= r75g25b75@,00x $ & (*> r88g25b75@,00x $ & (*/? r100g25b75@*00x" $ &(p~@r0g25b885@,00x $ & (*A r25g25b88@@,00x $ & (*B r50g25b88@,00x $ & (*C r75g25b88@,00x $ & (* .D r88g25b88@100@ r.hh,pjROSATTRIBSclass attributest+hh)ROSLFDESCros lf descrip)hh'r.ROSOBJMAPros name->id R+hh)6ROSSTRINGStk2 uiStringsc*hh(ffROSSTRUCTSstruct types> *hh(ffROSTK2RESVtk2 reservediohhutSRW2_ANCHORu&h!"h#$=hSRW2_BODY_LOCATION > $h h!" bSRW2_BOILERPLATEhhtrSRW2_BUTTON!phh wSRW2_COLUMNn#hh !d>SRW2_DATA_MODEL <$h h!"SRW2_ELEMENThh0aSRW2_FIELD0i)h$%h&'SRW2_FORMAT_EXCEPTION&hhSRW2_FRAMEethhorSRW2_GROUPs#hh !SRW2_GROUP_NODE#c"hh SRW2_HYPERLINK"it$h h!"0SRW2_JAVA_APPLET$(h#$h%&SRW2_JAVA_PROPERTIES%hhSRW2_LAYOUT %h !h"# =SRW2_LAYOUT_GROUP  hhzSRW2_LINK0hhSRW2_LISTS hh $SRW2_MATRIX'h"#h$%SRW2_OGD_COLUMN_MAP$h h!"SRW2_OG_DOCUMENT#hh !0SRW2_PARAM_FORMhhSRW2_QUERY%%h !h"#SRW2_TEXT_SEGMENT$%hhTOOL_ACCESS hh00TOOL_COMMENT hhTOOL_LIBRARY hh "TOOL_MODULEghhTOOL_PLSQL &$pp"VG_COLORVG_COLOR+pp $&'()VG_COLORITEMID@+pp $&'()VG_COLORCELLID@-pp &()*+VG_COLORNAME_SET@ !/pp (*+,-VG_COLORNAME_LENGTH r/pp (*+,-VG_COLORCOLOR_NAMEx'pp "#$%VG_COLORRED j)pp "$%&'VG_COLORGREEN (NO)pp "$%&'VG_COLORBLUE *"x Empno!"x Ename x88Job xpKMgr%x# Hiredate75g x0Sal!xpComm#x!b8Deptno"x Empno"x Ename@ x $Job xMgr%x# Hiredate x10Sal!x0nComm0#x! Deptnoy*00x " $ &('darkgraypK&00x "$h(cyanrpp*00x" $ &(_C)darkcyan(00x " $&*gray80333333(00x " $&j+gray76=p=p=p(00x " $&TN,gray72GGG(00x " $&}-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@D)00x " $&'0r50g25b0@/)00x " $&'x1r75g25b0@p)00x " $&'p2r88g25b0@+00x $ &()3 r100g25b0@m*00x" $ &(4r0g25b50@p,00x $ & (*05 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*ti7 r75g25b50@,00x $ & (*pc8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(MP:r0g25b750@,00x $ & (* T; r25g25b75@@,00x $ & (*t< r50g25b75@,00x $ & (*p= r75g25b75@,00x $ & (*> r88g25b75@,00x $ & (*/? r100g25b75@*00x" $ &(p~@r0g25b885@,00x $ & (*A r25g25b88@@,00x $ & (*B r50g25b88@,00x $ & (*C r75g25b88@,00x $ & (* .D r88g25b88@100Pr 88 RIBSclass attributes+hh)&'ROSLFDESCros lf descripC)hh'VWROSOBJMAPros name->idqrs+hh)ROSSTRINGStk2 uiStrings*hh(ROSSTRUCTSstruct types*hh(ROSTK2RESVtk2 reserved&h!"h#$SRW2_BODY_LOCATION #hh !SRW2_DATA_MODEL hhSRW2_LAYOUT hhSRW2_LISTS #hh !SRW2_PARAM_FORMhhTOOL_ACCESS hhTOOL_LIBRARY hhTOOL_MODULEj$pp"0VG_COLORVG_COLOR+pp $&'()VG_COLORITEMID@+pp $&'()VG_COLORCELLID@-pp &()*+VG_COLORNAME_SET@ n@n/pp (*+,-VG_COLORNAME_LENGTH /pp (*+,-VG_COLORCOLOR_NAMEx'pp "#$%VG_COLORRED )pp "$%&'VG_COLORGREEN r8t)pp "$%&'VG_COLORBLUE pwB_DEPTNO      1   n   z                            z BpDTU(VpZpZ0Z0[@^8bdefg0h0i0j0k0l0mn0o0pqrstuvwxM_G_EMPNO_GRPFR  h0v BpDRS TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstM_G_EMPNO_HDRhp\v BpDNO(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstR_G_EMPNORhz# JpLTU(VpZpZ0Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_EMPNOiBaz# JpLTU(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_ENAMElz# JpLRS(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_JOB6o0zz# JpLRS(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_MGR Tr# JpLWX(^pbpb8b8d8f8hjklmnopqr0s0t0upvpv0vwxyz{|}~F_HIREDATE Tjuou# JpLRS(VpZpZ@Z8^8`8bdefghijkl0m0n0oppp0F_SAL TExLNNNGNNNGNNNGNN0EN# JpLST(Zp^p^@^8b8d8fhijklmnop0q0r0sptpv0vwxyz{|}~F_COMME{N# JpLUV(Zp^p^@^8b8d8fhijklmnop0q0r0sptpv0vwxyz{|}~F_DEPTNO~N}~ 000000ppppppp:DESFORMATdfltDestination Format (/ bpdlmnopqprrpspsstu vx0y0z0{0|0}0~ppppppp;DESNAMEDestination Name00/ bpdlmnopqprrpspzz{|}~000000pppppppidqrs+hh)ROSSTRINGStk2 uiStrings*hh(ROSSTRUCTSstruct types*hh(ROSTK2RESVtk2 reserved&h!"h#$SRW2_BODY_LOCATION #hh !SRW2_DATA_MODEL hhSRW2_LAYOUT hhSRW2_LISTS #hh !SRW2_PARAM_FORMhhTOOL_ACCESS hhTOOL_LIBRARY hhTOOL_MODULEj$pp"0VG_COLORVG_COLOR+pp $&'()VG_COLORITEMID@+pp $&'()VG_COLORCELLID@-pp &()*+VG_COLORNAME_SET@ n@n/pp (*+,-VG_COLORNAME_LENGTH /pp (*+,-VG_COLORCOLOR_NAMEx'pp "#$%VG_COLORRED )pp "$%&'VG_COLORGREEN r8t)pp "$%&'VG_COLORBLUE pwB_DEPTNO      1   n   z                            z BpDTU(VpZpZ0Z0[@^8bdefg0h0i0j0k0l0mn0o0pqrstuvwxM_G_EMPNO_GRPFR  h0v BpDRS TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstM_G_EMPNO_HDRhp\v BpDNO(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstR_G_EMPNORhz# JpLTU(VpZpZ0Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_EMPNOiBaz# JpLTU(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_ENAMElz# JpLRS(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_JOB6o0zz# JpLRS(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_MGR Tr# JpLWX(^pbpb8b8d8f8hjklmnopqr0s0t0upvpv0vwxyz{|}~F_HIREDATE Tjuou# JpLRS(VpZpZ@Z8^8`8bdefghijkl0m0n0oppp0F_SAL TExLNNNGNNNGNNNGNN0EN# JpLST(Zp^p^@^8b8d8fhijklmnop0q0r0sptpv0vwxyz{|}~F_COMME{N# JpLUV(Zp^p^@^8b8d8fhijklmnop0q0r0sptpv0vwxyz{|}~F_DEPTNO~N}~ 000000ppppppp:DESFORMATdfltDestination Format (/ bpdlmnopqprrpspsstu vx0y0z0{0|0}0~ppppppp;DESNAMEDestination Name00/ bpdlmnopqprrpspzz{|}~000000pppppppAB1F1GHIJKLMdpQLPB `` MjjLPB ``LPB ``  #hh !SRW2_DATA_MODEL hhSRW2_LAYOUT hhSRW2_LISTS #hh !SRW2_PARAM_FORMhhTOOL_ACCESS hhTOOL_LIBRARY hhTOOL_MODULEj$pp"0VG_COLORVG_COLOR+pp $&'()VG_COLORITEMID@+pp $&'()VG_COLORCELLID@-pp &()*+VG_COLORNAME_SET@ n@n/pp (*+,-VG_COLORNAME_LENGTH /pp (*+,-VG_COLORCOLOR_NAMEx'pp "#$%VG_COLORRED )pp "$%&'VG_COLORGREEN r8t)pp "$%&'VG_COLORBLUE pwB_DEPTNO      1   n   z                            z BpDTU(VpZpZ0Z0[@^8bdefg0h0i0j0k0l0mn0o0pqrstuvwxM_G_EMPNO_GRPFR  h0v BpDRS TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstM_G_EMPNO_HDRhp\v BpDNO(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstR_G_EMPNORhz# JpLTU(VpZpZ0Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_EMPNOiBaz# JpLTU(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_ENAMElz# JpLRS(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_JOB6o0zz# JpLRS(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_MGR Tr# JpLWX(^pbpb8b8d8f8hjklmnopqr0s0t0upvpv0vwxyz{|}~F_HIREDATE Tjuou# JpLRS(VpZpZ@Z8^8`8bdefghijkl0m0n0oppp0F_SAL TExLNNNGNNNGNNNGNN0EN# JpLST(Zp^p^@^8b8d8fhijklmnop0q0r0sptpv0vwxyz{|}~F_COMME{N# JpLUV(Zp^p^@^8b8d8fhijklmnop0q0r0sptpv0vwxyz{|}~F_DEPTNO~N}~ 000000ppppppp:DESFORMATdfltDestination Format (/ bpdlmnopqprrpspsstu vx0y0z0{0|0}0~ppppppp;DESNAMEDestination Name00/ bpdlmnopqprrpspzz{|}~000000ppppppp Oracle HTML Navigator
k0l 0800 0808 function BeforePForm return boolean is hold_cmd VARCHAR2(240); begin if :P_Role IS NOT NULL then if substr(:P_Pass,1,1) = chr(34) then Hold_Cmd := :P_Role || ' IDENTIFIED BY '||:P_Pass; else Hold_Cmd := :P_Role || ' IDENTIFIED BY '|| chr(34) ||:P_Pass ||chr(34); end if; DBMS_SESSION.SET_ROLE(Hold_Cmd); end if; :dept := TO_NUMBER(:parm01); if upper(:desformat) = 'DELIMITED' then :desformat := 'delimiteddata'; end if; return (TRUE); end; :00008&&select * from emp where deptno = :deptf*>FNW(Z ^bg(nrw(~(((F_SQL*ReportWriterKgREPORTEKU)gxjnprmtEKUxi 6EKUxi&vijklmnop0q0r0sptpv0vwxyz{|}~F_COMME{N# JpLUV(Zp^p^@^8b8d8fhijklmnop0q0r0sptpv0vwxyz{|}~F_DEPTNO~N}~ 000000ppppppp:DESFORMATdfltDestination Format (/ bpdlmnopqprrpspsstu vx0y0z0{0|0}0~ppppppp;DESNAMEDestination Name00/ bpdlmnopqprrpspzz{|}~000000pppppppb r50g50b75,00x $ & (*; c r75g50b75,00x $ & (*T d r88g50b75,00x $ & (*.fe r100g50b75*00x" $ &(onfr0g50b885or,00x $ & (*tog r25g50b88@,00x $ & (*> h r50g50b88,00x $ & (*tdi r75g50b88,00x $ & (*orj r88g50b88,00x $ & (*ALk r100g50b88*00x# $ &(cel r0g50b100Y>,00x $ & (*0m r25g50b100@,00x $ & (*n r50g50b100,00x $ & (*_co r75g50b100,00x $ & (*_Rp r88g50b100.00x & ( *, =q r100g50b100d_'00x "$%FIryellows+00x $ &() :s darkyellowI*00x "$ &(s tmagenta i.00x &( *,LEu darkmagenta:d(00x " $& vgray48(00x " $& :wgray44\\\(00x " $&etxgray40(00x " $&0ygray36ףף'00x! "$%dezr0g75b0>)00x " $&'({r25g75b0@ort)00x " $&'gx|r50g75b0EK)00x " $&'}r75g75b0kl)00x " $&'z~r88g75b0OMM+00x $ &(){ r100g75b0.08x& ( *,8d00r0g75b500r008x ( * ,. 00r25g75b50@008x ( * ,. 00r50g75b50008x ( * ,.p 00r75g75b50008x ( * ,. 00r88g75b50008x ( * ,. 00r100g75b50.08x& ( *,p00r0g75b750008x ( * ,.DE 00r25g75b75@008x ( * ,. 00r50g75b75008x ( * ,.} 00r75g75b75008x ( * ,. 00r88g75b75008x ( * ,.ti 00r100g75b75.08x& ( *,k00r0g75b885v008x ( * ,. 00r25g75b88@008x ( * ,. 00r50g75b88008x ( * ,. 00r75g75b88008x ( * ,.p~ 00r88g75b88008x ( * ,.EN 00r100g75b88.08x' ( *, 00r0g75b100pd008x ( * ,.r 00r25g75b100@008x ( * ,. 00r50g75b100008x ( * ,. 00r75g75b100008x ( * ,. 00r88g75b100208x * , .0  00r100g75b100pr.08x & ( *,E00custom1.08x & ( *, 00custom2.08x & ( *,5g00custom30.08x & ( *,b100custom4,08x $ & (*00gray32,08x $ & (*00gray28QQQ,08x $ & (*000gray24,08x $ & (*00gray20+08x% &()00r0g88b0 -08x & (*+000r25g88b0@ark-08x & (*+ 00r50g88b0(\(-08x & (*+ {00r75g88b0(-08x & (*+ay00r88g88b0/08x ( *,-z 00r100g88b0$.08x& ( *,00r0g88b50008x ( * ,.0 00r25g88b50@008x ( * ,. 00r50g88b50008x ( * ,. " 00r75g88b50008x ( * ,.( 00r88g88b50008x ( * ,.ge 00r100g88b50.08x& ( *, 00r0g88b750008x ( * ,.0g 00r25g88b75@008x ( * ,.b5 00r50g88b75008x ( * ,. 00r75g88b75008x ( * ,. 00r88g88b75008x ( * ,. 00r100g88b75.08x& ( *,00r0g88b885 008x ( * ,.0 00r25g88b88@008x ( * ,. 00r50g88b88008x ( * ,. $ 00r75g88b88008x ( * ,. & 00r88g88b88008x ( * ,.to 00r100g88b88.08x' ( *,  00r0g88b100008x ( * ,.5g 00r25g88b100@008x ( * ,.b8 00r50g88b100008x ( * ,. 00r75g88b100008x ( * ,.Y> 00r88g88b100208x * , .0 00r100g88b100 .08x & ( *,000custom55g.08x & ( *,00custom6b1.08x & ( *, &00custom70.08x & ( *, 00custom8s,08x $ & (* :00gray16 ,08x $ & (*s 00gray12GGG,08x $ & (*LE00gray8,08x $ & (* $00gray4-08x& (*+ :00r0g100b0(/08x ( *,-ay 00r25g100b0@/08x ( *,- 00r50g100b0$/08x ( *,- 00r75g100b0/08x ( *,-0 00r88g100b0g/08x ( *,- 00r100g100b00.08x' ( *, " 00r0g100b50008x ( * ,.( 00r25g100b50@008x ( * ,.8d 00r50g100b50008x ( * ,. 00r75g100b50008x ( * ,. 00r88g100b50208x * , .0p 00r100g100b50.08x' ( *, 00r0g100b75008x ( * ,. 00r25g100b75@008x ( * ,. 00r50g100b75008x ( * ,. 00r75g100b75008x ( * ,. 00r88g100b75208x * , .0 00r100g100b75.08x' ( *,00 00r0g100b88008x ( * ,.00 00r25g100b88@008x ( * ,.00 00r50g100b88008x ( * ,.00 00r75g100b88008x ( * ,.00 00r88g100b88208x * , .000 00r100g100b888008x( * ,.8g 00r0g100b100208x * , .000 00r25g100b100@208x * , .010 00r50g100b100 (208x * , .0@ 00r75g100b100 ,208x * , .0 00r88g100b100208x * , .0 00r100g100b100 00r88g75b100208x * , .0  00r100g75b100Lr]>p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ[j>p?p?p?8LNOPQRSTUVWX Z\]^_`abcdefghCourier New h>p?p?p?0KLMNOPQRSTUV XZ[\]^_`abcdefCourier New h>p?p?p?0KLMNOPQRSTUV XZ[\]^_`abcdefCourier New ]>p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ[ou + h >p@p@p@0LMNOPQRSTUVW XZ[\]^_`abcdefCourier New1p"&'*./beforepform  00@ pp%p/5670809:;<=>jEMPNOemp.EMPNOEMPNOg@ pp%p/5670809:;<=>mENAMEemp.ENAMEENAME g: pp#p+/01020345678pJOBemp.JOBJOB g ": pp#p+/01020345678sMGRemp.MGRMGRg8gI pp(p5>?@0A0BCDEFGvHIREDATEemp.HIREDATEHIREDATE g : pp#p+/01020345678ySALemp.SALSAL g0g= pp$p-2340506789:;|COMMemp.COMMCOMMg8b7C pp&p189:0;0<=>?@ADEPTNOemp.DEPTNODEPTNOgF&p'+,2p6p6p66788:8<8>8@BCDgQ_1 M4 ff00 FpGOPQRST0UVW0XYZ0[\]^_xb8b8d8f8h jlpmpmpuupvphG_EMPNO g,>f'6`G_EMPNOLIST_G_EMPNO (/bpclmnopqprrpspwwxyz{0|0}0~000pppppppYPRINTJOB YesPShow Print Job Dialog8b/bpchijklmpnnpopwwxyz{0|0}0~000pppppppZMODE DefaultPOutput Mode/bpcnopqrspvvpwpzz{|}~000000ppppppp[BACKGROUNDtNoPRun in Background */bpcopqrstpzzp{p000000ppppppp\ORIENTATIONNoDefaultPOrientations/bpcklmnoppvvpwpwwxyz{0|0}0~000ppppppp]DECIMALDecimal Indicator/bpcmnopqrpvvpwpwwxyz{0|0}0~000ppppppp^THOUSANDSThousands Indicator/bpclmnopqprrpspsstu vx0y0z0{0|0}0~ppppppp_CURRENCYCurrency Symbol'/bpcjklmnoprrpspuuvwxy0z0{0|0}0~0ppppppp`COPIES1Number of Copies00/bpcmnopqrpvvpwp||}~ 000000pppppppaDESFORMATdfltDestination Format/bpcklmnoppvvpwpwwxy z|0}0~0000pppppppbDESNAMEDestination Name/bpcklmnoppvvpwp~~000000pppppppcDESTYPEScreenPDestination Type/bpcijklmnprrpspsstuvw0x0y0z0{0|0}p~  ppppppiEMPNOhj!Empno`'on TEMPNO/bpcijklmnprrpspsstuvw0x0y0z0{0|0}p~( pppppplENAMEhm !Ename`'ENAME/bpcghijklprrpspsstuvw0x0y0z0{0|0}p~( ppppppoJOBhp !Job_'JOB * , .0 00r100g100b100 00r88g75b100208x * , .0  00r100g75b100Xr/bpcghijklprrpspsstuvw0x0y0z0{0|0}p~  pppppprMGRhs!Mgr`'MGRf/bpclmnopqprrpspsstuvw0x0y0z0{0|0}p~( ppppppuHIREDATEhv !Hiredate'_ 'BHIREDATEN/bpcghijklprrpspsstuvw0x0y0z0{0|0}p~( ppppppxSALhyhv! Sal'SAL/bpchijklmpnnpopoopqrs0t0u0v0w0x0ypz( pppppp{COMMh|!Commal_'COMM/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~  pppppp~DEPTNOh!Deptno@'DEPTNO102/bpchijklmpnnpopoopqrs0t0u0v0w0x0ypzz{|}~ppppppdept  @DEPTI/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~ppppppparm01 PARM01/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~ppppppP_pass P_PASSQR/bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~ppppppP_role P_ROLE{0|*Zp[cd(jpnpn0n0o8p8rtuvxz000000p0owB_EMPNO=h*Zp[cd(jpnpn8n0p8r8tvwxx~000000p0eB_ENAMEppppp[BACKGROUNDtNoPRun in Background */bpcopqrstpzzp{p000000ppppppp\ORIENTATIONNoDefaultPOrientations/bpcklmnoppvvpwpwwxyz{0|0}0~000ppppppp]DECIMALDecimal Indicator/bpcmnopqrpvvpwpwwxyz{0|0}0~000ppppppp^THOUSANDSThousands Indicator/bpclmnopqprrpspsstu vx0y0z0{0|0}0~ppppppp_CURRENCYCurrency Symbol'/bpcjklmnoprrpspuuvwxy0z0{0|0}0~0ppppppp`COPIES1Number of Copies00/bpcmnopqrpvvpwp||}~ 000000pppppppaDESFORMATdfltDestination Format/bpcklmnoppvvpwpwwxy z|0}0~0000pppppppbDESNAMEDestination Name/bpcklmnoppvvpwp~~000000pppppppcDESTYPEScreenPDestination Type/bpcijklmnprrpspsstuvw0x0y0z0{0|0}p~  ppppppiEMPNOhj!Empno`'on TEMPNO/bpcijklmnprrpspsstuvw0x0y0z0{0|0}p~( pppppplENAMEhm !Ename`'ENAME/bpcghijklprrpspsstuvw0x0y0z0{0|0}p~( ppppppoJOBhp !Job_'JOB * , .0 00r100g100b100 00r88g75b100208x * , .0  00r100g75b100l1 $" BEFOREPFORMfunction BeforePForm return boolean is hold_cmd VARCHAR2(240); begin if :P_Role IS NOT NULL then if substr(:P_Pass,1,1) = chr(34) then Hold_Cmd := :P_Role || ' IDENTIFIED BY '||:P_Pass; else Hold_Cmd := :P_Role || ' IDENTIFIED BY '|| chr(34) ||:P_Pass ||chr(34); end if; DBMS_SESSION.SET_ROLE(Hold_Cmd); end if; :dept := TO_NUMBER(:parm01); if upper(:desformat) = 'DELIMITED' then :desformat := 'delimiteddata'; end if; return (TRUE); end; =ͫͫͫͫͫͫͫw SYSSTANDARD DBMS_SESSION p <<EKU DBMS_SESSION xf PUBLIC DBMS_SESSIONxf SYS DBMS_SESSION $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 +  "PKG INIT"BEFOREPFORM"HOLD_CMD""#&')  l$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08Lnw4eedAA  $eGAAeAeeeeeeeAeA $e eeAeeAeeAeeAAAeAAeAAeAAe"FUNCTION"BEFOREPFORM"RETURN"BOOLEAN"HOLD_CMD"VARCHAR2"240"P_ROLE""IS NOT NULL"SUBSTR"P_PASS"1"CHR"="34"||" IDENTIFIED BY "DBMS_SESSION"SET_ROLE"DEPT"TO_NUMBER"PARM01"UPPER"DESFORMAT"DELIMITED"delimiteddata"TRUE""  #$(359:AIMPSUX\adelnquz~   #*/347<?CGHLPW\_`gjnswx}  #&'()*-089:=@HIJKLMNOPQTW_`cfh,cQ<.~<.|.QQ.Q .|.|n .|.|.|.|n.Q.QWk .<.|.n neZOcQcQcQcQQcQcQcQc    &!%.0C9.1115;EEEI  %  1E nL m     to(    xp  %&" *+( ,-"/0%to xp5(4785 9:*<=-?@0BC3toGH6 " xpLM!"8#"PSQR$%: VW  |qXY&'< }r> ]e[^_()@ab*+C sE\gh esj k,-  t x | } ./vuw012lzy{34567~89:;JRVG<=>?X[@ABC^acfiknprD EFGtH IJK  U[ilO4$!"#').3126;K>JAFDEINTZ\`dcf$opqrs!"#'12.3DEIAF>JN;KTZc`d:drps qoͫͫͫͫͫͫͫ0D AX  &'$B (&'( $*&'$/3 );(:(lk;&'$/;(;(&'$/:ll"{ttD(DE<<X&'X$,( @XX% hg!4 D0 BEFOREPFORM" IDENTIFIED BY xf  DBMS_SESSIONSYSSET_ROLED DBMS_SESSION DELIMITED delimiteddata(l(((,((0X(<\t(Dx(X9 ' ? sX\`( @ @@ c!"S c!T# graphic drawnFG123vOP$%4567 intro mlabel(OP12,h-A  MS Sans Serif567 finishopts radiog rwetc_rgeh rwetc_rgea9L:FG,h-d  MS Sans Serif generate_to_web checkbox  MS Sans Serif(nN8808L66RESFILE___st p8headerfieldrwbf_parameterFonts;9FieldsboxDatabox TypeboxSectionsboxTemplatesboxFinishedQueryboxrwwt_Expresswizardvgmisq_helpstringrwbwvpulmenurwlfs_helpstring|zrwlbstringqorwdqe_helpstringjhrwbwolwindowKIrwbwdowindow,*!rwbwfewindow*(Yrwbwetwindow)'rwbwtpwindow%#lrwbhrewindow#!rwbwtrwindow" rwbwfi1windowrwbwcmwindowrwbwdiwindow#rwbwmrwindowrwbwrgwindowrwbwcnwindow  rwbwsrwindow  rwbwgiwindow  HyperlinksWWboxMatrixCellbox rwbwmfwindow vgmitx_helpstringvgmirt_helpstringvgmigr_helpstringrwlo Tr*Zp[ab(fpjpj8j0l8n8prstxz000000p0pB_JOB66q*Zp[ab(fpjpj8j0l8n8prstxz000000p0vB_MGR TTs*Zp[fg(jpnpn8n0p8r8tvwxx~000000p0 B_HIREDATE jTjz*Zp[ab(fpjpj@j0n8p8rtuvxz000000p0B_SALTEj*Zp[bc(fpjpj@j0n8p8rtuvxz000000p002B_COMMEj*Zp[de(fpjpj@j0n8p8rtuvxz000000p0psB_DEPTNOj         m   v                            ~BpCST(Zp^p^0^0_@b8fhijk0l0m0n0o0p0qr0s0tuvwxyz{|M_G_EMPNO_GRPFRp hvBpCQR TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstM_G_EMPNO_HDRphpnvBpCMN(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrstR_G_EMPNORh~#JpKST(Zp^p^0^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_EMPNOind~#JpKST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_ENAMElTAz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_JOB6opz#JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvwxF_MGR Tr/~#JpKVW(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{|F_HIREDATE juou#JpKQR(VpZpZ@Z8^8`8bdefghijkl0m0n0oppp0F_SAL TExLNNNGNNNGNNNGNN0NC~#JpKRS(VpZpZ@Z8^8`8bdefghijkl0m0n0opppr0rstuvwxyz{|F_COMME{N~#JpKTU(VpZpZ@Z8^8`8bdefghijkl0m0n0opppr0rstuvwxyz{|F_DEPTNO~N}~ 000000pppppppaDESFORMATdfltDestination Format/bpcklmnoppvvpwpwwxy z|0}0~0000pppppppbDESNAMEDestination Name/bpcklmnoppvvpwp~~000000pppppppcDESTYPEScreenPDestination Type/bpcijklmnprrpspsstuvw0x0y0z0{0|0}p~  ppppppiEMPNOhj!Empno`'on TEMPNO/bpcijklmnprrpspsstuvw0x0y0z0{0|0}p~( pppppplENAMEhm !Ename`'ENAME/bpcghijklprrpspsstuvw0x0y0z0{0|0}p~( ppppppoJOBhp !Job_'JOB * , .0 00r100g100b100 00r88g75b100208x * , .0  00r100g75b100