'l]RS_LOANRS_LOANDEFAULT&SMARTBARAMERICAN_AMERICA.WE8ISO8859P11 $ P0_29_JAN_200216_40_39a>ͫͫͫͫͫͫͫSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T1ͫͫͫͫͫͫͫ0D 22k &'&'&'GEGE $4!00 11 $ P1_29_JAN_200216_40_39E>ͫͫͫͫͫͫͫSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D O &'$/!00 1 $ P2_29_JAN_200216_40_39eUͫͫͫͫͫͫͫ/NSPC8/CLEAR_ALL_MASTER_DETAILS$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D T '$!88 bb b1 $ P6_29_JAN_200216_40_39aWͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08; ,"PKG INIT""MSGNUM"MSGTXT"MSGTYP""%()/23579  P   < ͫͫͫͫͫͫͫ0D  &' $,&'(($-(&'PP$.P<.d d  6.l l  .t t5 +&'&'GE$F.0| |  .8 5 +&'&'@GE$F.X 5 +&'&'`GE$FG;"MSGNUM"MSGTXT"MSGTYP""%()/23579  P   <[ ͫͫͫͫͫͫͫ0D \\ex) &' $G&'(($H(&'PP$IP<.d d  6.l l  .t t  .| |  .    .( 5 +&'&'0GE$FG;DGHNQRX[\befntw} ?7 8  9:=;< = !>#" C &')*,@.- 0A21 4B65$8~%($  +/3ͫͫͫͫͫͫͫ0P Kx  56$$7888LL9``(   ؄0 ,,#s,&'@$B@ y&'$;'$&'&'G E$9``H8  (:tt`   h&'&'G I<HH $4H&'\$B\  &'&'G Idd $@d&'&'G Ixx $4x`b W&'$;'$&'&'G E($:tt`  h&'&'G I $@8LL*  &'$F'$68LL! &'$Fjk! %&'&'G I<LL $4L$&'$`$B`  &'&'$G Ihh $@h&'&'G I|| $4|0! %# 8&'8$B 8%S7&'&'$G I $@$% hg!80`P0CLEAR_ALL_MASTER_DETAILS CLEAR_RECORDSYNCHRONIZE_BLOCKSCHANGEDQUERYNEWFIRST_CHANGED_BLOCK_BELOW((<(@h(l=(ظ(* ( *, T ,X \ *@` d Hh l *\p t dx | x  (($(8(L(`(tz ($((8,TLX\(``dhhl|ptx|((@A&B2C>DJJqNSTYZ[\ `DbOPmnop"q4r=sWtnusx~$)Z~!"'+<,M1~9:` t0H`#POPUPHINT#Loan DetailUpdate Loan Status2????= = = ?zzz??(((??@??????@??????@??????@??????@?????????333333?p=p=p=?GGG?QQQ?@?@@?@?@?@?@?@?@@?@?@?@?@?@?@@?@?@?@?@?@?@@?@?@?@?@?@?@@?@?@?@?@?????(\(\(\?ffffff?ppp?zzz??@??????@??????@??????@??????@??????????\\\??ףףף??@??????@??????@??????@??????@??????????QQQ????@??????@??????@??????@??????@????????? ?GGG????@??????@??????@??????@??????@?????TahomaV_RS_LOANSV_RS_LOANSid=:1PURCHASEDPurchasedPRICEPriceCOPY_STATUSCopy StatusREORDER_INFOReorder InfoAUTHORAuthorVOLUMEVolumePUBLISHEDPublishedRS_COPY_IDRs Copy IdPS_PERSON_IDPs Person IdMAIL_ADDRESSMail AddressPS_MEMBERSHIP_IDPs Membership IdIDLoan IdTahomaCOPY_IDCopy IdV_NUMBERStock %DATE_NEEDEDDate Neededmm/dd/RRRRDAYS_NEEDEDDays NeededDATE_SENTDate Sentmm/dd/RRRRSHIPPING_DAYSShipping DaysLOAN_STATUSOUTLoan Status1 $  P0_20_JUN_200312_54_50Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""TGͫͫͫͫͫͫͫ0D HH!0 &'&'GE$F&'&'GE$F!PP8 fucked  >(>G> 0STATUS_DATEStatus Datemm/dd/RRRRPERSONPersonORGANIZATIONOrganizationITEM_IDItem IdITEM_TITLEItem TitleRS_MEDIA_TYPE_IDMedia TypeTahomaISSUE_IDIssue IdISSUE_TITLEIssue TitleDate Duemm/dd/RRRR1 $ P5_29_JAN_200216_40_39Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T=ͫͫͫͫͫͫͫ0D >>  > ?] ,@],$$ =!ddT1$,4< @HLdh=1 $ P3_29_JAN_200216_40_39ͫͫͫͫͫͫͫw SYSSTANDARD FORMS4C FORMS40 /NSPC8/QUERY_MASTER_DETAILS/NSPC8/CHECK_PACKAGE_FAILURE$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08D 2"PKG INIT""RECSTAT"STARTITM"REL_ID"ID"" &)*017:<>@B   = DXlJ ͫͫͫͫͫͫͫ0D KKb |A  D8  XlD  D4  B4&'4|$K|D <&'L$-l'ld$C<&'<$KD <&'|$-l'l$8  X*  &'X$F'$!4\ &)*&)*NEWINSERT V_RS_LOANS.V_RS_LOANS_SY_ADDRESS SY_ADDRESSV_RS_LOANS.V_RS_LOANS_RS_LOANRS_LOANf(D(X h=l(|lp(tx ( (4(<++QW !"(0)A*J,J1 x4L d |1 $ P4_29_JAN_200216_40_39Eͫͫͫͫͫͫͫw SYSSTANDARD xh ('MFS SY_ADDRESSxh ( MFSRS_LOANSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08bL"PKG INIT""DUMMY_DEFINE"SY_ADDRESS_CUR""RS_LOAN_CUR""P (.069AGIORTVXZ\^`     08&&   ͫͫͫͫͫͫͫ0\  D#w0@u0@/@HHy06 .&'&'GE$Fs0hs0#w8\u8\/\ddy86 .&'&'GE$Fs8hs8! r{t$gd0gd0Btgd0 ! r{tXgd8gd8Ctgd8 !  ``BB<DXBBpx?Cannot delete master record when matching detail records exist.SY_ADDRESS_CUR4  RS_LOAN_CURK 0 8@Hܠ\d x#$6%D&c'g(l*p1v234568<A BBSELECT 1 FROM SY_ADDRESS S WHERE S.ID = :b1"SELECT 1 FROM RS_LOAN R WHERE R.ID = :b1" ?SY_ADDRESSSY_ADDRESSIDIdSTREET_1Street 1STREET_2Street 2CITYCitySTATEStateZIPZipATTENTIONAttentionRS_LOANRS_LOANRS_COPY_IDRs Copy Id1 $ }P8_20_JUN_200312_54_50=oͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS xh 'MFSRS_COPY$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08D >"PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY""$&,/069:<>@B    4<& ͫͫͫͫͫͫͫ0P ""!0 L &' ($K(G  9E;0&'&'0GE$Fh<L &' P$KPh `#[w4`(( (4(<(P Xp t|?mv#BSELECT ''x'' FROM MFS.RS_COPY WHERE ID = :b1"!T-DPS_PERSON_IDPs Person Id1 $ P7_20_JUN_200312_54_50Eqͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS xh MFS PS_PERSON$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08D >"PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY""$&,/069:<>@B    4<& ͫͫͫͫͫͫͫ0P ""!0 K &' ($K(G  9E;0&'&'0GE$Fh<K &' P$KPh `#[w4`(( (4(<(P Xp t|?mv#BSELECT ''x'' FROM MFS.PS_PERSON WHERE ID = :b1"!T-DMAIL_ADDRESSMail Address1 $ P6_20_JUN_200312_54_50Erͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS xh ('MFS SY_ADDRESS$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08D >"PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY""$&,/069:<>@B    4<& ͫͫͫͫͫͫͫ0P ""!0 J &' ($K(G  9E;0&'&'0GE$Fh<J &' P$KPh `#[w4`(( (4(<(P Xp t|?mv#BSELECT ''x'' FROM MFS.SY_ADDRESS WHERE ID = :b1"!T-DDATE_NEEDEDDate Needed1 $ qP4_20_JUN_200312_54_501Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Trͫͫͫͫͫͫͫ0D ss" TT H &' (${(G  9E;0&'&'0GE$Fh!x-WHEN-VALIDATE-ITEM trigger failed on field - $((LP 4< @H?mr  -DAYS_NEEDEDDays Needed1 $ P1_20_JUN_200312_54_50Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D   XD .( (I  9E;0&'&'0GE$FhD &' 4$K4G  9E;<&'&'<GE$Fh!-WHEN-VALIDATE-ITEM trigger failed on field - ,((h(4 @X \d0^c $-DATE_SENTDate Sent1 $ qP5_20_JUN_200312_54_501Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Trͫͫͫͫͫͫͫ0D ss" TT I &' (${(G  9E;0&'&'0GE$Fh!x-WHEN-VALIDATE-ITEM trigger failed on field - $((LP 4< @H?mr  -SHIPPING_DAYSShipping DaysSTATUS_DATEStatus Date1 $ qP9_20_JUN_200312_54_501Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Trͫͫͫͫͫͫͫ0D ss" TT M &' (${(G  9E;0&'&'0GE$Fh!x-WHEN-VALIDATE-ITEM trigger failed on field - $((LP 4< @H?mr  -PS_MEMBERSHIP_IDIDId1 $ P2_20_JUN_200312_54_50Wͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D   XF .( (I  9E;0&'&'0GE$FhF &' 4$K4G  9E;<&'&'<GE$Fh!-WHEN-VALIDATE-ITEM trigger failed on field - ,((h(4 @X \d0^c $-Ps Membership Id1 $ P10_20_JUN_200312_54_50uuͫͫͫͫͫͫͫw SYSSTANDARD xh !MFS PS_MEMBERSHIPSQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08D >"PKG INIT""PRIMARY_CUR""PRIMARY_DUMMY""$&,/069:<>@B    & ͫͫͫͫͫͫͫ0P T tN &' 0$K0h `#[w`u y<  .&'&'G E$Fshs! r{t gdgdNtgd !\\ `BB8@TDForeign key value does not currently exist in the primary key table. PRIMARY_CUR' TX\h0lp 8P = C W kBSELECT ''x'' FROM MFS.PS_MEMBERSHIP WHERE ID = :b1"\DSTATUSStatusRETURNEDRETURNEDLOSTLOSTDAMAGEDDAMAGEDOUTOUTOUT1 $ P3_20_JUN_200312_54_50IWͫͫͫͫͫͫͫw SYSSTANDARD SQLFORMS $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D Kx; t4G   v p f 0` V HP  @E ;` 8&'&'8GE$FhG &' <$B<G  9E ;` D&'&'DGE$Fh!OUTLOSTDAMAGEDRETURNED-WHEN-VALIDATE-ITEM trigger failed on field - &(""T2ͫͫͫͫͫͫͫ0D 33 &'$&'$F&'$/!\$\<v_rs_loans.loan_status &2 Update Status1 $ P15_20_JUN_200312_54_50Vͫͫͫͫͫͫͫw SYSSTANDARD FORMS40 $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""Tͫͫͫͫͫͫͫ0D v &'$F!DD4RS_LOAN.STATUS  1 $ P11_20_JUN_200312_54_50Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"""T+ͫͫͫͫͫͫͫ0D ,,  x,. E D G !hhPOUT! \t(@ DXG+  $?ؕ <T0Ș0dԙ@\̚LdG DATE_NEEDED` REORDER_INFO-DATE_DUE$<STATEh9STREET_2COPY_IDl\ARS_LOAN\ PUBLISHED) ITEM_TITLEV_NUMBERԖ%PERSONXCANVAS12d=ZIP> ATTENTIOND'ITEM_IDJ!p DATE_SENTD PS_PERSON_IDT CHECK_PACKAGE_FAILUREAUTHOR`B5 ROWID& ORGANIZATION PRICEp CLEAR_ALL_MASTER_DETAILSQp6IDRSTATUS@C RS_COPY_ID4 SY_ADDRESS WND_UPDATEOPS_MEMBERSHIP_IDD:CITYdU PUSH_BUTTON22|CANVAS2 WINDOW1l4V_RS_LOANS_SY_ADDRESSSPB_SAVEt P_LOAN_ID4V_RS_LOANS_RS_LOAN  COPY_STATUSM$ STATUS_DATE*RS_MEDIA_TYPE_ID`I DAYS_NEEDEDt QUERY_MASTER_DETAILSd  PURCHASED  V_RS_LOANSPFX0 MAIL_ADDRESS,# LOAN_STATUS|+ISSUE_ID7STREET_1pL" SHIPPING_DAYSț, ISSUE_TITLEVOLUME@TtY p p  p  T, $``8 N2 p Dd+p1 7 Pt<p, #0---|, 30-x[,XXp Y-rer   rer d rU}qqp9FRAME3\  q U epq q q U0Tahoma  +W+V- UY(UY9UY9999FRAME9  $+WUUs#Vppq ,$UY$+WUU04HShipping AddresshY\e$(  e    9FRAME13  (U Uepq D U  U U0L `  Update Statust  ,B  4\A  \4d4BB  B  44 t . d   `\X!",#$%&')*|+,-  h ؚ A Q (BD 4B@ $A=@BHB@  A6PB\B@ dAhB@xB@ A2X2BB@  ԛABB@ `x A Q B<B@ A Q BB@ | A Q BB@ \  A Q B8C@  A Q C,C@ | U Q @C0DC@TLC  H U ,Q TC\C@ U ^Q dCpC@ ȕ U p:= xCC@C  UpH"C C@ "P U p,= C!C@C #UpV"C"C@ 0$<$D}?OC $D@b,# D$ %L U ?-= $G%0G@44t7|XA Q YP7Y@49pF8}(l(Y8+Y@4l:0F8}(l(YH:Y@4;<F8}lY;Y@4=F8}lY<Y@4h>F8} J YD>Y@4? F8}lZ? Z@p6<@&7(l@&h9(@&:@&<@&d= ,A&>&`(BXYZ ZBV\A\A `B@CDPFG`IJpLMOQRSdU\A\ADDDA Q (Z D4Z@n@C\A@ZD\AE|LFA Q `E`@nD\A`F\ATG GA Q hg0Gxg@nPF\AgG\AHȕ\I A Q nHn@nG\A(n,I\AdJJA"q@Jq@n`I\AqJ\AKPlL A Q uKu@nJ\AudUQRSYN 4A5A6A7A8A9A: -'= '>'?"'@A AX'B'C`I'DAEpL'FR'G G'H J'IPF'JD'K@C'L M'MO'NsĔȔ̔ܔ,048@LPTX\hlptܕ (@TXpԖؖ 4<D`h̗ԗܗ04X`hȘ̘04Hdhؙ08\`|К 4Ph|̛4(048<@DHLPTx8@DHLPTXltx \d(LdtD,4X\p$,\ D L p t     , 8 H X h     $ ( , 0 4 8 < @ D H L P T X \ ` d h l p t x | d l p $ ( D $x| x`hl $@ txt\dh <pt pX`d8lp  dl0DTl tx4H \ ! !!$!p!!!!"" "$"8""""",#4#8#D#L#\#### $$$$$$$$$ %t%x%%%%%%%4&&&&&&&&H'''''''(\(((() ))$)p))))* *$*8***** ++4+|+++++<,@,\,,,,,,P-T-p------..h........../,/L/\/|////// 00<0L0l0|000000 1,1<1\1l11111112,2L2\2|222222 33<3L3l3|33334$4@4T4\4`4d4h4l4t4|44444444445 5,505p5t5x5|5555555p6x6|6660747P77777(8088888h9p9t9999(:,:H::::: ;(;|;;;<<<0<t<|<<<<d=l=p====$>(>D>>>>>?$?x?|?? @@<@L@l@|@@@@@@ A,A\A`AtAAAAAAAAA(B,B0B4B8B