'd3lPS_DEPARTMENT_LISTSMODULE2DEFAULT&SMARTBARAMERICAN_AMERICA.WE8ISO8859P11 $ P2_07_OCT_200414_43_10ͫͫͫͫͫͫͫw SYSSTANDARD xk%)MFSSY_TEMP_COUNTYxk%(MFSPS_TEMP_ORGANIZATION_TYPExk%)MFSPS_TEMP_ORG_FUNDING_TYPESQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ086 l"PKG INIT"""""""$&,.024     (0ͫͫͫͫͫͫͫ0D ? \q{t$  t q{tP((t( q{t|00t0 &'$&'&'&'GEGE $4!````P <<PP hh|P . ( DH ((LP (0TX 8@%<S_DELETE FROM SY_TEMP_COUNTY WHERE SESSION_ID = :b1"DELETE FROM PS_TEMP_ORGANIZATION_TYPE WHERE SESSION_ID = :b1"DELETE FROM PS_TEMP_ORG_FUNDING_TYPE WHERE SESSION_ID = :b1" 1 $ iP0_15_OCT_200407_43_18)ͫͫͫͫͫͫͫw SYSSTANDARD p <<MFSDUAL xh0-PUBLICDUALxh0-SYSDUALSEQ_ID xh 'MFSSEQ_IDSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 - <"PKG INIT"""""$')+   0ͫͫͫͫͫͫͫ0D 8P /q{t 0w08t088@@&'$;&'$/&' $;&'$/&'8$;&'$/!,, `P 8@TPS_ORGANIZATION_FUNDING_TYPE SY_COUNTYPS_ORGANIZATION_TYPE;`d (0hl(8p(@ T\K\hy    SELECT SEQ_ID.NEXTVAL FROM DUAL"8TX | 81 $ %SET_UP_RG_LIST_ͫͫͫͫͫͫͫ w SYSSTANDARD FORMS4C FORMS4G xk%)MFSSY_TEMP_COUNTYxk%(MFSPS_TEMP_ORGANIZATION_TYPExk%)MFSPS_TEMP_ORG_FUNDING_TYPESQLFORMS xh " MFSPS_ORGANIZATION_TYPExk!MFSPS_ORGANIZATION_FUNDING_TYPExh )MFS SY_COUNTY$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08XX+&"PKG INIT"SET_UP_RG_LIST"RG_ORG_TYPE_ID"ID"RG_ORG_FUND_ID"RG_SY_COUNTY_ID"F_TOTAL_ROWS"F_NEW_ROW"DONE"LASTREC"FILTERED"GC_ID"THE_ROWCOUNT"COLVALUE"""""I""""""""#&(./58:@AGJLRU[^deklrsyz   !#%')           W@ A  BCD E F G H  ! # I% J'&2) K+ L- M/N1O3P5Q7R9S;T=U?V (08HPdlt$,L  "$(*,.02468:<>ͫͫͫͫͫͫͫ0D  P &'8$&'P$&'h$ (0&'&'GI$ &'&'GI$ &'&'GI$ q{t0ddtd q{t\lltl q{ttttt &'$;&'$7   $$ v0&'$&'&'GI$.|A|8&'8 $$(  &'$TLL  (0 &'H$&'$ 8,Hzs.&' $Pq {tvPt Jhf q{tt &'$;&'$7( 0   `` w0&'$&'&'GI$.At&'t $$(  &'$TLL  (0 &'H$&'$ 8,H|u.&' $Pq{x $v$P$t$ Jhf!q{x8,,t, &' $;&'$7( 0    w0&'$&'&'GI$.4A4&'8 $$(  &'$TLL  (0 &'H$&'8<$ <8L,H\\TLT|u.Ld&'8dll $lPq{xdvPt JLLhf!q {xt &'$!4 4Zd `````````P HH\P ttP P P  P $$8P PPdP ||P SET_UP_RG_LIST &)*&)* &)*&)*RG_ORG_TYPE_IDRG_ORG_FUND_IDRG_SY_COUNTY_IDPS_ORGANIZATION_TYPEYESRG_ORG_TYPE_ID.IDTRUEPS_ORGANIZATION_FUNDING_TYPERG_ORG_FUND_ID.FUND_ID SY_COUNTYRG_SY_COUNTY_ID.ID,* 8*<T* X\*(`d*0hl8*Hp*P2 *d *l *t*|** **048 *<@ *DH*Ld*hl*pt*x|* *$ *,*4<*L*T*\*dl *  *(($(8(L(`(t((  1 T yy9!J"V$k%&(+-034692:8>@MBdCDEF #J=PNQZR`SfTlUVWY\^a ef&h2kIlOUrdt{uvwx#=|Xjv|%6BNekq?YtDELETE FROM SY_TEMP_COUNTY WHERE SESSION_ID = :b1"DELETE FROM PS_TEMP_ORGANIZATION_TYPE WHERE SESSION_ID = :b1"DELETE FROM PS_TEMP_ORG_FUNDING_TYPE WHERE SESSION_ID = :b1"INSERT INTO PS_TEMP_ORGANIZATION_TYPE VALUES ( :b1,:b2 )"INSERT INTO PS_TEMP_ORGANIZATION_TYPE SELECT ID,:b1 FROM PS_ORGANIZATION_TYPE"INSERT INTO PS_TEMP_ORG_FUNDING_TYPE VALUES ( :b1,:b2 )"INSERT INTO PS_TEMP_ORG_FUNDING_TYPE SELECT ID,:b1 FROM PS_ORGANIZATION_FUNDING_TYPE"INSERT INTO SY_TEMP_COUNTY VALUES ( :b1,:b2 )"INSERT INTO SY_TEMP_COUNTY SELECT ID,:b1 FROM SY_COUNTY",  D8Ph D ` 8p#POPUPHINT#Department ListsRG_ORG_FUND_IDFUND_IDRG_SY_COUNTY_IDIDRG_ORG_TYPE_IDID????= = = ?zzz??(((??@??????@??????@??????@??????@?????????333333?p=p=p=?GGG?QQQ?@?@@?@?@?@?@?@?@@?@?@?@?@?@?@@?@?@?@?@?@?@@?@?@?@?@?@?@@?@?@?@?@?????(\(\(\?ffffff?ppp?zzz??@??????@??????@??????@??????@??????????\\\??ףףף??@??????@??????@??????@??????@??????????QQQ????@??????@??????@??????@??????@????????? ?GGG????@??????@??????@??????@??????@?????TahomaTahomaPS_ORGANIZATION_TYPEPS_ORGANIZATION_TYPEID<<(NOREPORTTahomaIncludeYESNOIDIdTYPETypeps_organization_funding_typeps_organization_funding_typeIDp=p=(NOREPORTIncludeYESNOIDIdSY_COUNTYSY_COUNTYUNAME==L(NOREPORTIncludeYESNOIDIdNAMENameRun Report1 $ UP0_15_OCT_200408_31_48 ͫͫͫͫͫͫͫw SYSSTANDARD FORMS4C FORMS4G SQLFORMS TOOLS FORMS40 $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ0844"PKG INIT""FILTER_GROUP_ID"ID"ALL_GROUP_ID"F_TOTAL_ROWS"F_NEW_ROW"A_TOTAL_ROWS"A_NEW_ROW"IDSEL"CNT"DONE"LASTREC"FILTERED"PL_ID""j#&(./58:@CILRU[^dghnqwx~          3' (  )*+ , - . /  0! 1# 2%&p $   "ͫͫͫͫͫͫͫ0D h* &'8$p&'P$hhh&'&'pGI$ &'&'GI$ &'p$;&'$7Y  K  { q&'p$&'&'pGI$.A4&'4 $$z  l&'$&'&'pGI$. A 4&'4 $$ &'$THH   \ \\ \&'$$$&'4$J4'  &'$&'<$<&'&' GE 8$&'&'8GE $&'&'&'&'&'GEPGE` GElGEL$ !<)d &)*&)* &)*&)* RG_PACKET_ID RG_ALL_IDPS_ORGANIZATION_TYPEYESRG_PACKET_ID.ID RG_ALL_ID.IDTRUENOtmpdata Q_PACKET_IDS PARAMFORMpacketp(((( (((,0(48(<@*D\* `x$*4|<*L( `l(4p|(H(\ 1x}*J!X$z'()*+/025267=<K>]AiEoLoQWX]d'jRnoq p8 P hp , @LT ` 8t PBRB_NOTPAIDNOT PAIDNRB_BOTHBOTHBRB_PAIDPAIDPRC Member Paid List1 $ AP0_07_OCT_200415_58_14ͫͫͫͫͫͫͫw SYSSTANDARD /NSPC2/SET_UP_RG_LISTTOOLS FORMS40 $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 ,  "PKG INIT""PL_ID"ID""#&(*   Hyͫͫͫͫͫͫͫ0D zzbd '$H&'X$XH&'Hh$Jh%  &'H$&'p$pH&'&'H4G E L$&' &'HdG E  $&' 4&'H|G E 4$&'&'&'&'&'G EG E` G ElG EH$ !, $ &)*&)*tmpdata PARAMFORMNOP_SESSION_NUMBERP_PAIDps_department_list_datepaidDHX(hp( (4?iz    &yy x4 Ld|List by Staffing Type1 $ P0_07_OCT_200414_43_10ͫͫͫͫͫͫͫw SYSSTANDARD /NSPC2/SET_UP_RG_LISTTOOLS FORMS40 $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 ,  "PKG INIT""PL_ID"ID""#&(*   4Iͫͫͫͫͫͫͫ0D JJT '$4&'D$D4&'4T$JT%  &'4$&'\$\4&'&'44G E L$&' &'4dG E  $&'&'&'&'&'G E|G E` G ElG E4l$ !\,\  &)*&)*tmpdata PARAMFORMNOP_SESSION_NUMBERPS_OCA_Staffing:4D(T\(l ?i z   II x4 Ld|List by Staffing Type w/Chiefs1 $ P3_07_OCT_200414_43_10ͫͫͫͫͫͫͫw SYSSTANDARD /NSPC2/SET_UP_RG_LISTTOOLS FORMS40 $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 ,  "PKG INIT""PL_ID"ID""#&(*   4Iͫͫͫͫͫͫͫ0D JJT '$4&'D$D4&'4T$JT%  &'4$&'\$\4&'&'44G E L$&' &'4dG E  $&'&'&'&'&'G E|G E` G ElG E4l$ !d,d  &)*&)*tmpdata PARAMFORMNOP_SESSION_NUMBERPS_OCA_Staffing_chief:4D(T\(l ?iz    II x4 Ld|List by Funding Type1 $ P1_12_SEP_200718_07_50ͫͫͫͫͫͫͫw SYSSTANDARD /NSPC2/SET_UP_RG_LISTTOOLS FORMS40 $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 ,  "PKG INIT""PL_ID"ID""#&(*   4Iͫͫͫͫͫͫͫ0D JJT '$4&'D$D4&'4T$JT%  &'4$&'\$\4&'&'44G E L$&' &'4dG E  $&'&'&'&'&'G E|G E` G ElG E4l$ !\,\  &)*&)*tmpdata PARAMFORMNOP_SESSION_NUMBERPS_OCA_Funding:4D(T\(l ?i z   II x4 Ld|List by Funding Type w/Chiefs1 $ P3_12_SEP_200718_07_50ͫͫͫͫͫͫͫw SYSSTANDARD /NSPC2/SET_UP_RG_LISTTOOLS FORMS40 $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 ,  "PKG INIT""PL_ID"ID""#&(*   4Iͫͫͫͫͫͫͫ0D JJT '$4&'D$D4&'4T$JT%  &'4$&'\$\4&'&'44G E L$&' &'4dG E  $&'&'&'&'&'G E|G E` G ElG E4l$ !d,d  &)*&)*tmpdata PARAMFORMNOP_SESSION_NUMBERPS_OCA_funding_chief:4D(T\(l ?iz    II x4 Ld|List by County1 $ P2_12_SEP_200718_26_15ͫͫͫͫͫͫͫw SYSSTANDARD /NSPC2/SET_UP_RG_LISTTOOLS FORMS40 $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 ,  "PKG INIT""PL_ID"ID""#&(*   4Iͫͫͫͫͫͫͫ0D JJT '$4&'D$D4&'4T$JT%  &'4$&'\$\4&'&'44G E L$&' &'4dG E  $&'&'&'&'&'G E|G E` G ElG E4l$ !\,\  &)*&)*tmpdata PARAMFORMNOP_SESSION_NUMBER PS_OCA_County:4D(T\(l ?i z   II x4 Ld| List by County w/Chiefs1 $ P3_12_SEP_200718_26_15ͫͫͫͫͫͫͫw SYSSTANDARD /NSPC2/SET_UP_RG_LISTTOOLS FORMS40 $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 ,  "PKG INIT""PL_ID"ID""#&(*   4Iͫͫͫͫͫͫͫ0D JJT '$4&'D$D4&'4T$JT%  &'4$&'\$\4&'&'44G E L$&' &'4dG E  $&'&'&'&'&'G E|G E` G ElG E4l$ !`,`  &)*&)*tmpdata PARAMFORMNOP_SESSION_NUMBERPS_OCA_County_chief:4D(T\(l ?iz    II x4 Ld|Alphabetical List w/Chiefs1 $ P1_25_OCT_200713_21_23ͫͫͫͫͫͫͫw SYSSTANDARD /NSPC2/SET_UP_RG_LISTTOOLS FORMS40 $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 ,  "PKG INIT""PL_ID"ID""#&(*   4Iͫͫͫͫͫͫͫ0D JJT '$4&'D$D4&'4T$JT%  &'4$&'\$\4&'&'44G E L$&' &'4dG E  $&'&'&'&'&'G E|G E` G ElG E4l$ !`,`  &)*&)*tmpdata PARAMFORMNOP_SESSION_NUMBERPS_OCA_ALPHA_chief:4D(T\(l ?iz    II x4 Ld|SESSION_IDFILTERED_LIST|}4}`}} ~$~@~`~~~~~0P( BTN_DEPT_LIST>8980UFRAME7  9Uepq 99U0Tahoma  (rFQreSd rOr8Vr8Vp9FRAME24\   ,U: e-pq   ,U0Organization Staffing Types  (9rYNYUOT  9]9rYN92 0TEXT283TahomaSelect Staffing Types to include in reports above ((leave blank for all)  (KFQeOS KO8V8V9FRAME35  @UUUȘeppq \UUUU0dx Funding Types  (rYUMYMT    ]rYUMr0 0GRAPHIC36 , t @ 2Select funding types to include in reports above  (leave blank for all)  (ZFQe^S4  ZO;;8V8V@ 9FRAME43,    9Uepq  99U0  Counties  (UrYUEYET h  t U]UrYUEr0 0GRAPHIC44\    -Select Counties to include in reports above  (leave blank for all)(d=cA < @  d=cA   @ d=cA       d=cA p  9f=U9f;9f;| UFRAME21h    dUU:cppq  9fdUU0 Paid Status: &,&&xx'x'  ' x< < L|() >d(>0>4>L8~=*(#8><>L ~=M(d@>h H>4 !&&$}" ! 4"#d$'P()*@,-.00@T> Z#0$