API tools faq
paste
Guest User

Untitled

a guest
Jul 21st, 2018
123
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 138.52 KB | None | 0 0
raw download clone embed print report
  1. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 31067.0701326259946949602122015915119363, MAX_RATE = 31067.0701326259946949602122015915119363, DAYRATE_USD = 31067.0701326259946949602122015915119363 WHERE JOURNAL_ID = 'CA01744265' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  2. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 31067.0701326259946949602122015915119363, MAX_RATE = 31067.0701326259946949602122015915119363, DAYRATE_USD = 31067.0701326259946949602122015915119363 WHERE JOURNAL_ID = 'CA01752771' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  3. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 31140.8221090909090909090909090909090909, MAX_RATE = 31140.8221090909090909090909090909090909, DAYRATE_USD = 31140.8221090909090909090909090909090909 WHERE JOURNAL_ID = 'CA01836163' AND JOURNAL_DATE = TO_DATE('30-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  4. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 29248.879080459770114942528735632183908, MAX_RATE = 29248.879080459770114942528735632183908, DAYRATE_USD = 29248.879080459770114942528735632183908 WHERE JOURNAL_ID = 'CA01786115' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  5. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 34123.1359186268277177368086458995549905, MAX_RATE = 34123.1359186268277177368086458995549905, DAYRATE_USD = 34123.1359186268277177368086458995549905 WHERE JOURNAL_ID = 'CA01658489' AND JOURNAL_DATE = TO_DATE('09-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  6. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 34123.1359186268277177368086458995549905, MAX_RATE = 34123.1359186268277177368086458995549905, DAYRATE_USD = 34123.1359186268277177368086458995549905 WHERE JOURNAL_ID = 'CA01643393' AND JOURNAL_DATE = TO_DATE('29-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  7. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 34258.9945154343144292893036611629576454, MAX_RATE = 34258.9945154343144292893036611629576454, DAYRATE_USD = 34258.9945154343144292893036611629576454 WHERE JOURNAL_ID = 'CA01679759' AND JOURNAL_DATE = TO_DATE('29-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  8. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 34322.8633144704931285367825383993532741, MAX_RATE = 34322.8633144704931285367825383993532741, DAYRATE_USD = 34322.8633144704931285367825383993532741 WHERE JOURNAL_ID = 'CA01554216' AND JOURNAL_DATE = TO_DATE('30-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 12;
  9. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 34322.8633144704931285367825383993532741, MAX_RATE = 34322.8633144704931285367825383993532741, DAYRATE_USD = 34322.8633144704931285367825383993532741 WHERE JOURNAL_ID = 'CA01579013' AND JOURNAL_DATE = TO_DATE('04-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  10. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 34469.28, MAX_RATE = 34469.28, DAYRATE_USD = 34469.28 WHERE JOURNAL_ID = 'CA01610503' AND JOURNAL_DATE = TO_DATE('07-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 11;
  11. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 34469.28, MAX_RATE = 34469.28, DAYRATE_USD = 34469.28 WHERE JOURNAL_ID = 'CA01597207' AND JOURNAL_DATE = TO_DATE('31-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 14;
  12. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 34469.28, MAX_RATE = 34469.28, DAYRATE_USD = 34469.28 WHERE JOURNAL_ID = 'CA01599717' AND JOURNAL_DATE = TO_DATE('31-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  13. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 34469.28, MAX_RATE = 34469.28, DAYRATE_USD = 34469.28 WHERE JOURNAL_ID = 'CA01579014' AND JOURNAL_DATE = TO_DATE('13-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  14. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 34869.3969445521519968980224893369523071, MAX_RATE = 34869.3969445521519968980224893369523071, DAYRATE_USD = 34869.3969445521519968980224893369523071 WHERE JOURNAL_ID = 'CA01511776' AND JOURNAL_DATE = TO_DATE('12-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  15. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 34869.3969445521519968980224893369523071, MAX_RATE = 34869.3969445521519968980224893369523071, DAYRATE_USD = 34869.3969445521519968980224893369523071 WHERE JOURNAL_ID = 'CA01487605' AND JOURNAL_DATE = TO_DATE('30-MAR-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  16. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 38532.0505583756345177664974619289340101, MAX_RATE = 38532.0505583756345177664974619289340101, DAYRATE_USD = 38532.0505583756345177664974619289340101 WHERE JOURNAL_ID = 'CA01564110' AND JOURNAL_DATE = TO_DATE('30-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  17. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 44073.3488, MAX_RATE = 44073.3488, DAYRATE_USD = 44073.3488 WHERE JOURNAL_ID = 'CA01792601' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 15;
  18. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 44073.3488, MAX_RATE = 44073.3488, DAYRATE_USD = 44073.3488 WHERE JOURNAL_ID = 'CA01786422' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  19. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 44073.3488, MAX_RATE = 44073.3488, DAYRATE_USD = 44073.3488 WHERE JOURNAL_ID = 'CA01792601' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 17;
  20. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 44878.4356626506024096385542168674698795, MAX_RATE = 44878.4356626506024096385542168674698795, DAYRATE_USD = 44878.4356626506024096385542168674698795 WHERE JOURNAL_ID = 'CA01786422' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 18;
  21. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 45294.0326174496644295302013422818791946, MAX_RATE = 45294.0326174496644295302013422818791946, DAYRATE_USD = 45294.0326174496644295302013422818791946 WHERE JOURNAL_ID = 'CA01786422' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 15;
  22. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 46992.2546564885496183206106870229007634, MAX_RATE = 46992.2546564885496183206106870229007634, DAYRATE_USD = 46992.2546564885496183206106870229007634 WHERE JOURNAL_ID = 'CA01380092' AND JOURNAL_DATE = TO_DATE('31-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 24;
  23. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 46992.2546564885496183206106870229007634, MAX_RATE = 46992.2546564885496183206106870229007634, DAYRATE_USD = 46992.2546564885496183206106870229007634 WHERE JOURNAL_ID = 'CA01380092' AND JOURNAL_DATE = TO_DATE('31-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 20;
  24. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 46992.2546564885496183206106870229007634, MAX_RATE = 46992.2546564885496183206106870229007634, DAYRATE_USD = 46992.2546564885496183206106870229007634 WHERE JOURNAL_ID = 'CA01381895' AND JOURNAL_DATE = TO_DATE('31-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  25. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 46992.2546564885496183206106870229007634, MAX_RATE = 46992.2546564885496183206106870229007634, DAYRATE_USD = 46992.2546564885496183206106870229007634 WHERE JOURNAL_ID = 'CA01380092' AND JOURNAL_DATE = TO_DATE('31-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 16;
  26. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 52748.2114285714285714285714285714285714, MAX_RATE = 52748.2114285714285714285714285714285714, DAYRATE_USD = 52748.2114285714285714285714285714285714 WHERE JOURNAL_ID = 'CA01912884' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  27. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 52748.2114285714285714285714285714285714, MAX_RATE = 52748.2114285714285714285714285714285714, DAYRATE_USD = 52748.2114285714285714285714285714285714 WHERE JOURNAL_ID = 'CA01912884' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  28. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 55228.236521739130434782608695652173913, MAX_RATE = 55228.236521739130434782608695652173913, DAYRATE_USD = 55228.236521739130434782608695652173913 WHERE JOURNAL_ID = 'CA01879452' AND JOURNAL_DATE = TO_DATE('06-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  29. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 55228.236521739130434782608695652173913, MAX_RATE = 55228.236521739130434782608695652173913, DAYRATE_USD = 55228.236521739130434782608695652173913 WHERE JOURNAL_ID = 'CA01871617' AND JOURNAL_DATE = TO_DATE('31-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 11;
  30. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 55228.236521739130434782608695652173913, MAX_RATE = 55228.236521739130434782608695652173913, DAYRATE_USD = 55228.236521739130434782608695652173913 WHERE JOURNAL_ID = 'CA01871616' AND JOURNAL_DATE = TO_DATE('01-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 55;
  31. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 55228.236521739130434782608695652173913, MAX_RATE = 55228.236521739130434782608695652173913, DAYRATE_USD = 55228.236521739130434782608695652173913 WHERE JOURNAL_ID = 'CA01871616' AND JOURNAL_DATE = TO_DATE('01-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 42;
  32. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 55228.236521739130434782608695652173913, MAX_RATE = 55228.236521739130434782608695652173913, DAYRATE_USD = 55228.236521739130434782608695652173913 WHERE JOURNAL_ID = 'CA01871617' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 11;
  33. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 55228.236521739130434782608695652173913, MAX_RATE = 55228.236521739130434782608695652173913, DAYRATE_USD = 55228.236521739130434782608695652173913 WHERE JOURNAL_ID = 'CA01871616' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 55;
  34. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 55228.236521739130434782608695652173913, MAX_RATE = 55228.236521739130434782608695652173913, DAYRATE_USD = 55228.236521739130434782608695652173913 WHERE JOURNAL_ID = 'CA01871616' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 42;
  35. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 55228.236521739130434782608695652173913, MAX_RATE = 55228.236521739130434782608695652173913, DAYRATE_USD = 55228.236521739130434782608695652173913 WHERE JOURNAL_ID = 'CA01833447' AND JOURNAL_DATE = TO_DATE('30-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 14;
  36. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 55228.236521739130434782608695652173913, MAX_RATE = 55228.236521739130434782608695652173913, DAYRATE_USD = 55228.236521739130434782608695652173913 WHERE JOURNAL_ID = 'CA01845946' AND JOURNAL_DATE = TO_DATE('07-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  37. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 56639.52, MAX_RATE = 56639.52, DAYRATE_USD = 56639.52 WHERE JOURNAL_ID = 'CA01783074' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 14;
  38. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 56639.52, MAX_RATE = 56639.52, DAYRATE_USD = 56639.52 WHERE JOURNAL_ID = 'CA01785933' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  39. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 56639.52, MAX_RATE = 56639.52, DAYRATE_USD = 56639.52 WHERE JOURNAL_ID = 'CA01799205' AND JOURNAL_DATE = TO_DATE('07-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  40. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 56639.52, MAX_RATE = 56639.52, DAYRATE_USD = 56639.52 WHERE JOURNAL_ID = 'CA01833447' AND JOURNAL_DATE = TO_DATE('30-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  41. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 59103.740952380952380952380952380952381, MAX_RATE = 59103.740952380952380952380952380952381, DAYRATE_USD = 59103.740952380952380952380952380952381 WHERE JOURNAL_ID = 'CA01715371' AND JOURNAL_DATE = TO_DATE('27-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  42. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 59103.740952380952380952380952380952381, MAX_RATE = 59103.740952380952380952380952380952381, DAYRATE_USD = 59103.740952380952380952380952380952381 WHERE JOURNAL_ID = 'CA01715370' AND JOURNAL_DATE = TO_DATE('26-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  43. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 59103.740952380952380952380952380952381, MAX_RATE = 59103.740952380952380952380952380952381, DAYRATE_USD = 59103.740952380952380952380952380952381 WHERE JOURNAL_ID = 'CA01738884' AND JOURNAL_DATE = TO_DATE('20-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  44. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 59103.740952380952380952380952380952381, MAX_RATE = 59103.740952380952380952380952380952381, DAYRATE_USD = 59103.740952380952380952380952380952381 WHERE JOURNAL_ID = 'CA01748341' AND JOURNAL_DATE = TO_DATE('25-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  45. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 62137.6077108433734939759036144578313253, MAX_RATE = 62137.6077108433734939759036144578313253, DAYRATE_USD = 62137.6077108433734939759036144578313253 WHERE JOURNAL_ID = 'CA01783074' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  46. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 62137.6077108433734939759036144578313253, MAX_RATE = 62137.6077108433734939759036144578313253, DAYRATE_USD = 62137.6077108433734939759036144578313253 WHERE JOURNAL_ID = 'CA01759975' AND JOURNAL_DATE = TO_DATE('06-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  47. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 62137.6077108433734939759036144578313253, MAX_RATE = 62137.6077108433734939759036144578313253, DAYRATE_USD = 62137.6077108433734939759036144578313253 WHERE JOURNAL_ID = 'CA01750665' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 16;
  48. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 62515.8754285714285714285714285714285714, MAX_RATE = 62515.8754285714285714285714285714285714, DAYRATE_USD = 62515.8754285714285714285714285714285714 WHERE JOURNAL_ID = 'CA01691891' AND JOURNAL_DATE = TO_DATE('04-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  49. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 62515.8754285714285714285714285714285714, MAX_RATE = 62515.8754285714285714285714285714285714, DAYRATE_USD = 62515.8754285714285714285714285714285714 WHERE JOURNAL_ID = 'CA01679062' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 14;
  50. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 62515.8754285714285714285714285714285714, MAX_RATE = 62515.8754285714285714285714285714285714, DAYRATE_USD = 62515.8754285714285714285714285714285714 WHERE JOURNAL_ID = 'CA01716357' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  51. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 63481.6724475524475524475524475524475524, MAX_RATE = 63481.6724475524475524475524475524475524, DAYRATE_USD = 63481.6724475524475524475524475524475524 WHERE JOURNAL_ID = 'CA01727549' AND JOURNAL_DATE = TO_DATE('08-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  52. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 63481.6724475524475524475524475524475524, MAX_RATE = 63481.6724475524475524475524475524475524, DAYRATE_USD = 63481.6724475524475524475524475524475524 WHERE JOURNAL_ID = 'CA01750665' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 12;
  53. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 63481.6724475524475524475524475524475524, MAX_RATE = 63481.6724475524475524475524475524475524, DAYRATE_USD = 63481.6724475524475524475524475524475524 WHERE JOURNAL_ID = 'CA01716357' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 14;
  54. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 64645.9122267206477732793522267206477733, MAX_RATE = 64645.9122267206477732793522267206477733, DAYRATE_USD = 64645.9122267206477732793522267206477733 WHERE JOURNAL_ID = 'CA01546638' AND JOURNAL_DATE = TO_DATE('27-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  55. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 64645.9122267206477732793522267206477733, MAX_RATE = 64645.9122267206477732793522267206477733, DAYRATE_USD = 64645.9122267206477732793522267206477733 WHERE JOURNAL_ID = 'CA01549700' AND JOURNAL_DATE = TO_DATE('28-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  56. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01707898' AND JOURNAL_DATE = TO_DATE('22-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  57. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01659301' AND JOURNAL_DATE = TO_DATE('12-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 16;
  58. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01659301' AND JOURNAL_DATE = TO_DATE('12-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 14;
  59. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01659301' AND JOURNAL_DATE = TO_DATE('12-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 9;
  60. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01711501' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  61. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01692193' AND JOURNAL_DATE = TO_DATE('05-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  62. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01692193' AND JOURNAL_DATE = TO_DATE('05-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  63. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01679613' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  64. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01692193' AND JOURNAL_DATE = TO_DATE('05-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 12;
  65. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01659301' AND JOURNAL_DATE = TO_DATE('12-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 11;
  66. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01707898' AND JOURNAL_DATE = TO_DATE('22-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  67. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01707898' AND JOURNAL_DATE = TO_DATE('22-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  68. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01552297' AND JOURNAL_DATE = TO_DATE('29-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  69. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01623465' AND JOURNAL_DATE = TO_DATE('13-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  70. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01595040' AND JOURNAL_DATE = TO_DATE('31-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  71. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01623465' AND JOURNAL_DATE = TO_DATE('13-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  72. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01534566' AND JOURNAL_DATE = TO_DATE('18-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 1;
  73. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01579205' AND JOURNAL_DATE = TO_DATE('13-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  74. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01579205' AND JOURNAL_DATE = TO_DATE('13-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  75. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01641837' AND JOURNAL_DATE = TO_DATE('30-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  76. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01552297' AND JOURNAL_DATE = TO_DATE('29-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 12;
  77. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01534566' AND JOURNAL_DATE = TO_DATE('18-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 19;
  78. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01579205' AND JOURNAL_DATE = TO_DATE('13-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 16;
  79. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01552297' AND JOURNAL_DATE = TO_DATE('29-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  80. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01534566' AND JOURNAL_DATE = TO_DATE('18-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 13;
  81. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01485658' AND JOURNAL_DATE = TO_DATE('29-MAR-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  82. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01453498' AND JOURNAL_DATE = TO_DATE('15-MAR-11', 'DD-MON-YY') AND JOURNAL_LINE = 3;
  83. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01453498' AND JOURNAL_DATE = TO_DATE('15-MAR-11', 'DD-MON-YY') AND JOURNAL_LINE = 7;
  84. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01485658' AND JOURNAL_DATE = TO_DATE('29-MAR-11', 'DD-MON-YY') AND JOURNAL_LINE = 20;
  85. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01453498' AND JOURNAL_DATE = TO_DATE('15-MAR-11', 'DD-MON-YY') AND JOURNAL_LINE = 15;
  86. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01485658' AND JOURNAL_DATE = TO_DATE('29-MAR-11', 'DD-MON-YY') AND JOURNAL_LINE = 14;
  87. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01485658' AND JOURNAL_DATE = TO_DATE('29-MAR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  88. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01453498' AND JOURNAL_DATE = TO_DATE('15-MAR-11', 'DD-MON-YY') AND JOURNAL_LINE = 1;
  89. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01400234' AND JOURNAL_DATE = TO_DATE('11-FEB-11', 'DD-MON-YY') AND JOURNAL_LINE = 5;
  90. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01400234' AND JOURNAL_DATE = TO_DATE('11-FEB-11', 'DD-MON-YY') AND JOURNAL_LINE = 1;
  91. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01400234' AND JOURNAL_DATE = TO_DATE('11-FEB-11', 'DD-MON-YY') AND JOURNAL_LINE = 11;
  92. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01400234' AND JOURNAL_DATE = TO_DATE('11-FEB-11', 'DD-MON-YY') AND JOURNAL_LINE = 21;
  93. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01422703' AND JOURNAL_DATE = TO_DATE('28-FEB-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  94. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01376688' AND JOURNAL_DATE = TO_DATE('30-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  95. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01376644' AND JOURNAL_DATE = TO_DATE('30-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  96. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01376644' AND JOURNAL_DATE = TO_DATE('30-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  97. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01352648' AND JOURNAL_DATE = TO_DATE('12-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 1;
  98. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01376644' AND JOURNAL_DATE = TO_DATE('30-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 20;
  99. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01352648' AND JOURNAL_DATE = TO_DATE('12-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 15;
  100. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01376644' AND JOURNAL_DATE = TO_DATE('30-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  101. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 71699.82, MAX_RATE = 71699.82, DAYRATE_USD = 71699.82 WHERE JOURNAL_ID = 'CA01352648' AND JOURNAL_DATE = TO_DATE('12-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 9;
  102. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 74570.3380645161290322580645161290322581, MAX_RATE = 74570.3380645161290322580645161290322581, DAYRATE_USD = 74570.3380645161290322580645161290322581 WHERE JOURNAL_ID = 'CA01912904' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  103. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 74570.3380645161290322580645161290322581, MAX_RATE = 74570.3380645161290322580645161290322581, DAYRATE_USD = 74570.3380645161290322580645161290322581 WHERE JOURNAL_ID = 'CA01912582' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 14;
  104. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 74570.3380645161290322580645161290322581, MAX_RATE = 74570.3380645161290322580645161290322581, DAYRATE_USD = 74570.3380645161290322580645161290322581 WHERE JOURNAL_ID = 'CA01912582' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  105. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 80894.4973584905660377358490566037735849, MAX_RATE = 80894.4973584905660377358490566037735849, DAYRATE_USD = 80894.4973584905660377358490566037735849 WHERE JOURNAL_ID = 'CA01834804' AND JOURNAL_DATE = TO_DATE('26-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 22;
  106. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 80894.4973584905660377358490566037735849, MAX_RATE = 80894.4973584905660377358490566037735849, DAYRATE_USD = 80894.4973584905660377358490566037735849 WHERE JOURNAL_ID = 'CA01834805' AND JOURNAL_DATE = TO_DATE('27-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 17;
  107. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 80894.4973584905660377358490566037735849, MAX_RATE = 80894.4973584905660377358490566037735849, DAYRATE_USD = 80894.4973584905660377358490566037735849 WHERE JOURNAL_ID = 'CA01846004' AND JOURNAL_DATE = TO_DATE('07-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 23;
  108. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 79790.4997570850202429149797570850202429, MAX_RATE = 79790.4997570850202429149797570850202429, DAYRATE_USD = 79790.4997570850202429149797570850202429 WHERE JOURNAL_ID = 'CA01872055' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  109. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 79790.4997570850202429149797570850202429, MAX_RATE = 79790.4997570850202429149797570850202429, DAYRATE_USD = 79790.4997570850202429149797570850202429 WHERE JOURNAL_ID = 'CA01865304' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  110. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 79790.4997570850202429149797570850202429, MAX_RATE = 79790.4997570850202429149797570850202429, DAYRATE_USD = 79790.4997570850202429149797570850202429 WHERE JOURNAL_ID = 'CA01865304' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  111. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 79790.4997570850202429149797570850202429, MAX_RATE = 79790.4997570850202429149797570850202429, DAYRATE_USD = 79790.4997570850202429149797570850202429 WHERE JOURNAL_ID = 'CA01913369' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  112. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 79790.4997570850202429149797570850202429, MAX_RATE = 79790.4997570850202429149797570850202429, DAYRATE_USD = 79790.4997570850202429149797570850202429 WHERE JOURNAL_ID = 'CA01909874' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 9;
  113. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 79790.4997570850202429149797570850202429, MAX_RATE = 79790.4997570850202429149797570850202429, DAYRATE_USD = 79790.4997570850202429149797570850202429 WHERE JOURNAL_ID = 'CA01909873' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 11;
  114. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 79790.4997570850202429149797570850202429, MAX_RATE = 79790.4997570850202429149797570850202429, DAYRATE_USD = 79790.4997570850202429149797570850202429 WHERE JOURNAL_ID = 'CA01834805' AND JOURNAL_DATE = TO_DATE('27-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 3;
  115. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 79790.4997570850202429149797570850202429, MAX_RATE = 79790.4997570850202429149797570850202429, DAYRATE_USD = 79790.4997570850202429149797570850202429 WHERE JOURNAL_ID = 'CA01798820' AND JOURNAL_DATE = TO_DATE('07-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 14;
  116. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 79790.4997570850202429149797570850202429, MAX_RATE = 79790.4997570850202429149797570850202429, DAYRATE_USD = 79790.4997570850202429149797570850202429 WHERE JOURNAL_ID = 'CA01834805' AND JOURNAL_DATE = TO_DATE('27-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 13;
  117. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 79790.4997570850202429149797570850202429, MAX_RATE = 79790.4997570850202429149797570850202429, DAYRATE_USD = 79790.4997570850202429149797570850202429 WHERE JOURNAL_ID = 'CA01785932' AND JOURNAL_DATE = TO_DATE('27-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 1;
  118. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 79790.4997570850202429149797570850202429, MAX_RATE = 79790.4997570850202429149797570850202429, DAYRATE_USD = 79790.4997570850202429149797570850202429 WHERE JOURNAL_ID = 'CA01785931' AND JOURNAL_DATE = TO_DATE('26-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 1;
  119. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 79790.4997570850202429149797570850202429, MAX_RATE = 79790.4997570850202429149797570850202429, DAYRATE_USD = 79790.4997570850202429149797570850202429 WHERE JOURNAL_ID = 'CA01834803' AND JOURNAL_DATE = TO_DATE('25-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 12;
  120. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 79790.4997570850202429149797570850202429, MAX_RATE = 79790.4997570850202429149797570850202429, DAYRATE_USD = 79790.4997570850202429149797570850202429 WHERE JOURNAL_ID = 'CA01834803' AND JOURNAL_DATE = TO_DATE('25-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 5;
  121. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 79790.4997570850202429149797570850202429, MAX_RATE = 79790.4997570850202429149797570850202429, DAYRATE_USD = 79790.4997570850202429149797570850202429 WHERE JOURNAL_ID = 'CA01834804' AND JOURNAL_DATE = TO_DATE('26-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 14;
  122. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 79790.4997570850202429149797570850202429, MAX_RATE = 79790.4997570850202429149797570850202429, DAYRATE_USD = 79790.4997570850202429149797570850202429 WHERE JOURNAL_ID = 'CA01846004' AND JOURNAL_DATE = TO_DATE('07-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 17;
  123. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 79790.4997570850202429149797570850202429, MAX_RATE = 79790.4997570850202429149797570850202429, DAYRATE_USD = 79790.4997570850202429149797570850202429 WHERE JOURNAL_ID = 'CA01834804' AND JOURNAL_DATE = TO_DATE('26-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 30;
  124. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 79790.4997570850202429149797570850202429, MAX_RATE = 79790.4997570850202429149797570850202429, DAYRATE_USD = 79790.4997570850202429149797570850202429 WHERE JOURNAL_ID = 'CA01834803' AND JOURNAL_DATE = TO_DATE('25-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 23;
  125. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 80972.1921163636363636363636363636363636, MAX_RATE = 80972.1921163636363636363636363636363636, DAYRATE_USD = 80972.1921163636363636363636363636363636 WHERE JOURNAL_ID = 'CA01610832' AND JOURNAL_DATE = TO_DATE('07-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  126. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 80972.1921163636363636363636363636363636, MAX_RATE = 80972.1921163636363636363636363636363636, DAYRATE_USD = 80972.1921163636363636363636363636363636 WHERE JOURNAL_ID = 'CA01597029' AND JOURNAL_DATE = TO_DATE('31-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  127. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 81329.1414925373134328358208955223880597, MAX_RATE = 81329.1414925373134328358208955223880597, DAYRATE_USD = 81329.1414925373134328358208955223880597 WHERE JOURNAL_ID = 'CA01865304' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 18;
  128. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 81329.1414925373134328358208955223880597, MAX_RATE = 81329.1414925373134328358208955223880597, DAYRATE_USD = 81329.1414925373134328358208955223880597 WHERE JOURNAL_ID = 'CA01785930' AND JOURNAL_DATE = TO_DATE('25-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  129. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 81329.1414925373134328358208955223880597, MAX_RATE = 81329.1414925373134328358208955223880597, DAYRATE_USD = 81329.1414925373134328358208955223880597 WHERE JOURNAL_ID = 'CA01761455' AND JOURNAL_DATE = TO_DATE('08-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 7;
  130. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 81329.1414925373134328358208955223880597, MAX_RATE = 81329.1414925373134328358208955223880597, DAYRATE_USD = 81329.1414925373134328358208955223880597 WHERE JOURNAL_ID = 'CA01798820' AND JOURNAL_DATE = TO_DATE('07-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 11;
  131. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 81329.1414925373134328358208955223880597, MAX_RATE = 81329.1414925373134328358208955223880597, DAYRATE_USD = 81329.1414925373134328358208955223880597 WHERE JOURNAL_ID = 'CA01750908' AND JOURNAL_DATE = TO_DATE('27-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  132. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 81329.1414925373134328358208955223880597, MAX_RATE = 81329.1414925373134328358208955223880597, DAYRATE_USD = 81329.1414925373134328358208955223880597 WHERE JOURNAL_ID = 'CA01750907' AND JOURNAL_DATE = TO_DATE('26-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  133. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 89429.2774054054054054054054054054054054, MAX_RATE = 89429.2774054054054054054054054054054054, DAYRATE_USD = 89429.2774054054054054054054054054054054 WHERE JOURNAL_ID = 'CA01761454' AND JOURNAL_DATE = TO_DATE('07-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  134. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 89429.2774054054054054054054054054054054, MAX_RATE = 89429.2774054054054054054054054054054054, DAYRATE_USD = 89429.2774054054054054054054054054054054 WHERE JOURNAL_ID = 'CA01750906' AND JOURNAL_DATE = TO_DATE('25-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  135. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 89429.2774054054054054054054054054054054, MAX_RATE = 89429.2774054054054054054054054054054054, DAYRATE_USD = 89429.2774054054054054054054054054054054 WHERE JOURNAL_ID = 'CA01716740' AND JOURNAL_DATE = TO_DATE('26-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 5;
  136. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 89429.2774054054054054054054054054054054, MAX_RATE = 89429.2774054054054054054054054054054054, DAYRATE_USD = 89429.2774054054054054054054054054054054 WHERE JOURNAL_ID = 'CA01716741' AND JOURNAL_DATE = TO_DATE('27-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 1;
  137. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 89429.2774054054054054054054054054054054, MAX_RATE = 89429.2774054054054054054054054054054054, DAYRATE_USD = 89429.2774054054054054054054054054054054 WHERE JOURNAL_ID = 'CA01728089' AND JOURNAL_DATE = TO_DATE('08-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  138. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 90249.52, MAX_RATE = 90249.52, DAYRATE_USD = 90249.52 WHERE JOURNAL_ID = 'CA01418650' AND JOURNAL_DATE = TO_DATE('24-FEB-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  139. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 90249.52, MAX_RATE = 90249.52, DAYRATE_USD = 90249.52 WHERE JOURNAL_ID = 'CA01379948' AND JOURNAL_DATE = TO_DATE('31-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  140. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 90249.52, MAX_RATE = 90249.52, DAYRATE_USD = 90249.52 WHERE JOURNAL_ID = 'CA01383797' AND JOURNAL_DATE = TO_DATE('31-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  141. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 90249.52, MAX_RATE = 90249.52, DAYRATE_USD = 90249.52 WHERE JOURNAL_ID = 'CA01380091' AND JOURNAL_DATE = TO_DATE('31-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  142. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 90249.52, MAX_RATE = 90249.52, DAYRATE_USD = 90249.52 WHERE JOURNAL_ID = 'CA01379948' AND JOURNAL_DATE = TO_DATE('31-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  143. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 90249.52, MAX_RATE = 90249.52, DAYRATE_USD = 90249.52 WHERE JOURNAL_ID = 'CA01379705' AND JOURNAL_DATE = TO_DATE('31-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  144. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 90249.52, MAX_RATE = 90249.52, DAYRATE_USD = 90249.52 WHERE JOURNAL_ID = 'CA01379948' AND JOURNAL_DATE = TO_DATE('31-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  145. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 100000.000329896907216494845360824742268, MAX_RATE = 100000.000329896907216494845360824742268, DAYRATE_USD = 100000.000329896907216494845360824742268 WHERE JOURNAL_ID = 'CA01418743' AND JOURNAL_DATE = TO_DATE('28-FEB-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  146. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 92142.8595488721804511278195488721804511, MAX_RATE = 92142.8595488721804511278195488721804511, DAYRATE_USD = 92142.8595488721804511278195488721804511 WHERE JOURNAL_ID = 'CA01683833' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 13;
  147. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 92142.8595488721804511278195488721804511, MAX_RATE = 92142.8595488721804511278195488721804511, DAYRATE_USD = 92142.8595488721804511278195488721804511 WHERE JOURNAL_ID = 'CA01683833' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 16;
  148. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 92142.8595488721804511278195488721804511, MAX_RATE = 92142.8595488721804511278195488721804511, DAYRATE_USD = 92142.8595488721804511278195488721804511 WHERE JOURNAL_ID = 'CA01683833' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  149. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 92142.8595488721804511278195488721804511, MAX_RATE = 92142.8595488721804511278195488721804511, DAYRATE_USD = 92142.8595488721804511278195488721804511 WHERE JOURNAL_ID = 'CA01687162' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  150. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 92142.8595488721804511278195488721804511, MAX_RATE = 92142.8595488721804511278195488721804511, DAYRATE_USD = 92142.8595488721804511278195488721804511 WHERE JOURNAL_ID = 'CA01683091' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  151. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 118601.3074889867841409691629955947136564, MAX_RATE = 118601.3074889867841409691629955947136564, DAYRATE_USD = 118601.3074889867841409691629955947136564 WHERE JOURNAL_ID = 'CA01597375' AND JOURNAL_DATE = TO_DATE('31-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 14;
  152. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 118601.3074889867841409691629955947136564, MAX_RATE = 118601.3074889867841409691629955947136564, DAYRATE_USD = 118601.3074889867841409691629955947136564 WHERE JOURNAL_ID = 'CA01597375' AND JOURNAL_DATE = TO_DATE('31-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  153. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 119212.2, MAX_RATE = 119212.2, DAYRATE_USD = 119212.2 WHERE JOURNAL_ID = 'CA01871703' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 66;
  154. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 119212.2, MAX_RATE = 119212.2, DAYRATE_USD = 119212.2 WHERE JOURNAL_ID = 'CA01871703' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 64;
  155. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 119212.2, MAX_RATE = 119212.2, DAYRATE_USD = 119212.2 WHERE JOURNAL_ID = 'CA01911466' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 51;
  156. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 119212.2, MAX_RATE = 119212.2, DAYRATE_USD = 119212.2 WHERE JOURNAL_ID = 'CA01911466' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 48;
  157. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 119212.2, MAX_RATE = 119212.2, DAYRATE_USD = 119212.2 WHERE JOURNAL_ID = 'CA01597375' AND JOURNAL_DATE = TO_DATE('31-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 30;
  158. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 119212.2, MAX_RATE = 119212.2, DAYRATE_USD = 119212.2 WHERE JOURNAL_ID = 'CA01597375' AND JOURNAL_DATE = TO_DATE('31-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 24;
  159. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 123738.4402649006622516556291390728476821, MAX_RATE = 123738.4402649006622516556291390728476821, DAYRATE_USD = 123738.4402649006622516556291390728476821 WHERE JOURNAL_ID = 'CA01871703' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 32;
  160. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 123738.4402649006622516556291390728476821, MAX_RATE = 123738.4402649006622516556291390728476821, DAYRATE_USD = 123738.4402649006622516556291390728476821 WHERE JOURNAL_ID = 'CA01871703' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 29;
  161. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 123738.4402649006622516556291390728476821, MAX_RATE = 123738.4402649006622516556291390728476821, DAYRATE_USD = 123738.4402649006622516556291390728476821 WHERE JOURNAL_ID = 'CA01915493' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  162. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 123738.4402649006622516556291390728476821, MAX_RATE = 123738.4402649006622516556291390728476821, DAYRATE_USD = 123738.4402649006622516556291390728476821 WHERE JOURNAL_ID = 'CA01915493' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  163. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 123738.4402649006622516556291390728476821, MAX_RATE = 123738.4402649006622516556291390728476821, DAYRATE_USD = 123738.4402649006622516556291390728476821 WHERE JOURNAL_ID = 'CA01912301' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  164. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 123738.4402649006622516556291390728476821, MAX_RATE = 123738.4402649006622516556291390728476821, DAYRATE_USD = 123738.4402649006622516556291390728476821 WHERE JOURNAL_ID = 'CA01872617' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 36;
  165. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 123738.4402649006622516556291390728476821, MAX_RATE = 123738.4402649006622516556291390728476821, DAYRATE_USD = 123738.4402649006622516556291390728476821 WHERE JOURNAL_ID = 'CA01872617' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 30;
  166. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 123738.4402649006622516556291390728476821, MAX_RATE = 123738.4402649006622516556291390728476821, DAYRATE_USD = 123738.4402649006622516556291390728476821 WHERE JOURNAL_ID = 'CA01872617' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 19;
  167. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 123738.4402649006622516556291390728476821, MAX_RATE = 123738.4402649006622516556291390728476821, DAYRATE_USD = 123738.4402649006622516556291390728476821 WHERE JOURNAL_ID = 'CA01872617' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 16;
  168. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 125580.1681218274111675126903553299492386, MAX_RATE = 125580.1681218274111675126903553299492386, DAYRATE_USD = 125580.1681218274111675126903553299492386 WHERE JOURNAL_ID = 'CA01871703' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 27;
  169. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 125580.1681218274111675126903553299492386, MAX_RATE = 125580.1681218274111675126903553299492386, DAYRATE_USD = 125580.1681218274111675126903553299492386 WHERE JOURNAL_ID = 'CA01872617' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 13;
  170. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 125580.1681218274111675126903553299492386, MAX_RATE = 125580.1681218274111675126903553299492386, DAYRATE_USD = 125580.1681218274111675126903553299492386 WHERE JOURNAL_ID = 'CA01872617' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  171. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 135956.0788110403397027600849256900212314, MAX_RATE = 135956.0788110403397027600849256900212314, DAYRATE_USD = 135956.0788110403397027600849256900212314 WHERE JOURNAL_ID = 'CA01788300' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  172. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 140567.9657142857142857142857142857142857, MAX_RATE = 140567.9657142857142857142857142857142857, DAYRATE_USD = 140567.9657142857142857142857142857142857 WHERE JOURNAL_ID = 'CA01788031' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 13;
  173. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 140567.9657142857142857142857142857142857, MAX_RATE = 140567.9657142857142857142857142857142857, DAYRATE_USD = 140567.9657142857142857142857142857142857 WHERE JOURNAL_ID = 'CA01791468' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  174. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 140367.5148679245283018867924528301886792, MAX_RATE = 140367.5148679245283018867924528301886792, DAYRATE_USD = 140367.5148679245283018867924528301886792 WHERE JOURNAL_ID = 'CA01717548' AND JOURNAL_DATE = TO_DATE('01-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  175. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 140367.5148679245283018867924528301886792, MAX_RATE = 140367.5148679245283018867924528301886792, DAYRATE_USD = 140367.5148679245283018867924528301886792 WHERE JOURNAL_ID = 'CA01717548' AND JOURNAL_DATE = TO_DATE('01-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 30;
  176. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 140367.5148679245283018867924528301886792, MAX_RATE = 140367.5148679245283018867924528301886792, DAYRATE_USD = 140367.5148679245283018867924528301886792 WHERE JOURNAL_ID = 'CA01717548' AND JOURNAL_DATE = TO_DATE('01-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 32;
  177. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 140367.5148679245283018867924528301886792, MAX_RATE = 140367.5148679245283018867924528301886792, DAYRATE_USD = 140367.5148679245283018867924528301886792 WHERE JOURNAL_ID = 'CA01717548' AND JOURNAL_DATE = TO_DATE('01-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 9;
  178. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 140367.5148679245283018867924528301886792, MAX_RATE = 140367.5148679245283018867924528301886792, DAYRATE_USD = 140367.5148679245283018867924528301886792 WHERE JOURNAL_ID = 'CA01717548' AND JOURNAL_DATE = TO_DATE('01-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 7;
  179. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 140367.5148679245283018867924528301886792, MAX_RATE = 140367.5148679245283018867924528301886792, DAYRATE_USD = 140367.5148679245283018867924528301886792 WHERE JOURNAL_ID = 'CA01717548' AND JOURNAL_DATE = TO_DATE('01-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 29;
  180. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 140367.5148679245283018867924528301886792, MAX_RATE = 140367.5148679245283018867924528301886792, DAYRATE_USD = 140367.5148679245283018867924528301886792 WHERE JOURNAL_ID = 'CA01717538' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  181. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 140367.5148679245283018867924528301886792, MAX_RATE = 140367.5148679245283018867924528301886792, DAYRATE_USD = 140367.5148679245283018867924528301886792 WHERE JOURNAL_ID = 'CA01717548' AND JOURNAL_DATE = TO_DATE('01-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 31;
  182. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 140367.5148679245283018867924528301886792, MAX_RATE = 140367.5148679245283018867924528301886792, DAYRATE_USD = 140367.5148679245283018867924528301886792 WHERE JOURNAL_ID = 'CA01717548' AND JOURNAL_DATE = TO_DATE('01-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 24;
  183. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 140565.8550954063604240282685512367491166, MAX_RATE = 140565.8550954063604240282685512367491166, DAYRATE_USD = 140565.8550954063604240282685512367491166 WHERE JOURNAL_ID = 'CA01682663' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  184. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 140576.3197540353574173712528823981552652, MAX_RATE = 140576.3197540353574173712528823981552652, DAYRATE_USD = 140576.3197540353574173712528823981552652 WHERE JOURNAL_ID = 'CA01752762' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 13;
  185. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 132595, MAX_RATE = 132595, DAYRATE_USD = 132595 WHERE JOURNAL_ID = 'CA01753064' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  186. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 132595, MAX_RATE = 132595, DAYRATE_USD = 132595 WHERE JOURNAL_ID = 'CA01753064' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  187. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 141598.8826592797783933518005540166204986, MAX_RATE = 141598.8826592797783933518005540166204986, DAYRATE_USD = 141598.8826592797783933518005540166204986 WHERE JOURNAL_ID = 'CA01792825' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  188. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 144306.5100811541929666366095581605049594, MAX_RATE = 144306.5100811541929666366095581605049594, DAYRATE_USD = 144306.5100811541929666366095581605049594 WHERE JOURNAL_ID = 'CA01647824' AND JOURNAL_DATE = TO_DATE('30-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 36;
  189. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 145129.0520127795527156549520766773162939, MAX_RATE = 145129.0520127795527156549520766773162939, DAYRATE_USD = 145129.0520127795527156549520766773162939 WHERE JOURNAL_ID = 'CA01716108' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  190. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 145129.0520127795527156549520766773162939, MAX_RATE = 145129.0520127795527156549520766773162939, DAYRATE_USD = 145129.0520127795527156549520766773162939 WHERE JOURNAL_ID = 'CA01717333' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  191. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 145334.120881057268722466960352422907489, MAX_RATE = 145334.120881057268722466960352422907489, DAYRATE_USD = 145334.120881057268722466960352422907489 WHERE JOURNAL_ID = 'CA01683230' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 20;
  192. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 145334.1208888888888888888888888888888889, MAX_RATE = 145334.1208888888888888888888888888888889, DAYRATE_USD = 145334.1208888888888888888888888888888889 WHERE JOURNAL_ID = 'CA01683230' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  193. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 145344.9397468354430379746835443037974683, MAX_RATE = 145344.9397468354430379746835443037974683, DAYRATE_USD = 145344.9397468354430379746835443037974683 WHERE JOURNAL_ID = 'CA01748196' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  194. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 145344.9397468354430379746835443037974683, MAX_RATE = 145344.9397468354430379746835443037974683, DAYRATE_USD = 145344.9397468354430379746835443037974683 WHERE JOURNAL_ID = 'CA01752599' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  195. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 145364.8386149003147953830010493179433368, MAX_RATE = 145364.8386149003147953830010493179433368, DAYRATE_USD = 145364.8386149003147953830010493179433368 WHERE JOURNAL_ID = 'CA01647556' AND JOURNAL_DATE = TO_DATE('30-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  196. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 146193.4133894736842105263157894736842105, MAX_RATE = 146193.4133894736842105263157894736842105, DAYRATE_USD = 146193.4133894736842105263157894736842105 WHERE JOURNAL_ID = 'CA01716959' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  197. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 146399.9860078208318521151795236402417348, MAX_RATE = 146399.9860078208318521151795236402417348, DAYRATE_USD = 146399.9860078208318521151795236402417348 WHERE JOURNAL_ID = 'CA01684779' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  198. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 146410.8848501938667606626718364469510046, MAX_RATE = 146410.8848501938667606626718364469510046, DAYRATE_USD = 146410.8848501938667606626718364469510046 WHERE JOURNAL_ID = 'CA01752403' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 7;
  199. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 145004.1937688442211055276381909547738693, MAX_RATE = 145004.1937688442211055276381909547738693, DAYRATE_USD = 145004.1937688442211055276381909547738693 WHERE JOURNAL_ID = 'CA01791665' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 17;
  200. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 145004.1937688442211055276381909547738693, MAX_RATE = 145004.1937688442211055276381909547738693, DAYRATE_USD = 145004.1937688442211055276381909547738693 WHERE JOURNAL_ID = 'CA01792995' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 20;
  201. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 145004.1937688442211055276381909547738693, MAX_RATE = 145004.1937688442211055276381909547738693, DAYRATE_USD = 145004.1937688442211055276381909547738693 WHERE JOURNAL_ID = 'CA01792995' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 17;
  202. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 145004.1937688442211055276381909547738693, MAX_RATE = 145004.1937688442211055276381909547738693, DAYRATE_USD = 145004.1937688442211055276381909547738693 WHERE JOURNAL_ID = 'CA01791665' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 20;
  203. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 149709.216, MAX_RATE = 149709.216, DAYRATE_USD = 149709.216 WHERE JOURNAL_ID = 'CA01732734' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 19;
  204. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 149709.216, MAX_RATE = 149709.216, DAYRATE_USD = 149709.216 WHERE JOURNAL_ID = 'CA01732884' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  205. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 149709.216, MAX_RATE = 149709.216, DAYRATE_USD = 149709.216 WHERE JOURNAL_ID = 'CA01717539' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  206. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 149709.216, MAX_RATE = 149709.216, DAYRATE_USD = 149709.216 WHERE JOURNAL_ID = 'CA01732734' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  207. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 149709.216, MAX_RATE = 149709.216, DAYRATE_USD = 149709.216 WHERE JOURNAL_ID = 'CA01717539' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  208. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 149920.7594156706507304116865869853917663, MAX_RATE = 149920.7594156706507304116865869853917663, DAYRATE_USD = 149920.7594156706507304116865869853917663 WHERE JOURNAL_ID = 'CA01683088' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  209. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 149931.920573183213920163766632548618219, MAX_RATE = 149931.920573183213920163766632548618219, DAYRATE_USD = 149931.920573183213920163766632548618219 WHERE JOURNAL_ID = 'CA01753065' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  210. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 149931.920573183213920163766632548618219, MAX_RATE = 149931.920573183213920163766632548618219, DAYRATE_USD = 149931.920573183213920163766632548618219 WHERE JOURNAL_ID = 'CA01753065' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 12;
  211. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 167620, MAX_RATE = 167620, DAYRATE_USD = 167620 WHERE JOURNAL_ID = 'CA01376968' AND JOURNAL_DATE = TO_DATE('31-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  212. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 158703.4653252385082393755420641803989592, MAX_RATE = 158703.4653252385082393755420641803989592, DAYRATE_USD = 158703.4653252385082393755420641803989592 WHERE JOURNAL_ID = 'CA01670422' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  213. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 158703.4653252385082393755420641803989592, MAX_RATE = 158703.4653252385082393755420641803989592, DAYRATE_USD = 158703.4653252385082393755420641803989592 WHERE JOURNAL_ID = 'CA01647824' AND JOURNAL_DATE = TO_DATE('30-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  214. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 158703.4653252385082393755420641803989592, MAX_RATE = 158703.4653252385082393755420641803989592, DAYRATE_USD = 158703.4653252385082393755420641803989592 WHERE JOURNAL_ID = 'CA01647824' AND JOURNAL_DATE = TO_DATE('30-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 20;
  215. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 158703.4653252385082393755420641803989592, MAX_RATE = 158703.4653252385082393755420641803989592, DAYRATE_USD = 158703.4653252385082393755420641803989592 WHERE JOURNAL_ID = 'CA01647669' AND JOURNAL_DATE = TO_DATE('30-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  216. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 159608.0705325443786982248520710059171598, MAX_RATE = 159608.0705325443786982248520710059171598, DAYRATE_USD = 159608.0705325443786982248520710059171598 WHERE JOURNAL_ID = 'CA01715633' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  217. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 159833.5974880546075085324232081911262799, MAX_RATE = 159833.5974880546075085324232081911262799, DAYRATE_USD = 159833.5974880546075085324232081911262799 WHERE JOURNAL_ID = 'CA01683087' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  218. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 174500.0123076923076923076923076923076923, MAX_RATE = 174500.0123076923076923076923076923076923, DAYRATE_USD = 174500.0123076923076923076923076923076923 WHERE JOURNAL_ID = 'CA01915494' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 9;
  219. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 174500.0123076923076923076923076923076923, MAX_RATE = 174500.0123076923076923076923076923076923, DAYRATE_USD = 174500.0123076923076923076923076923076923 WHERE JOURNAL_ID = 'CA01915304' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 22;
  220. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 180879.9993234672304439746300211416490486, MAX_RATE = 180879.9993234672304439746300211416490486, DAYRATE_USD = 180879.9993234672304439746300211416490486 WHERE JOURNAL_ID = 'CA01549698' AND JOURNAL_DATE = TO_DATE('28-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 7;
  221. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 179036.0007804878048780487804878048780488, MAX_RATE = 179036.0007804878048780487804878048780488, DAYRATE_USD = 179036.0007804878048780487804878048780488 WHERE JOURNAL_ID = 'CA01597204' AND JOURNAL_DATE = TO_DATE('31-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  222. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 180384, MAX_RATE = 180384, DAYRATE_USD = 180384 WHERE JOURNAL_ID = 'CA01426301' AND JOURNAL_DATE = TO_DATE('28-FEB-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  223. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 180384, MAX_RATE = 180384, DAYRATE_USD = 180384 WHERE JOURNAL_ID = 'CA01423292' AND JOURNAL_DATE = TO_DATE('28-FEB-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  224. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 180816, MAX_RATE = 180816, DAYRATE_USD = 180816 WHERE JOURNAL_ID = 'CA01683837' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  225. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 179396, MAX_RATE = 179396, DAYRATE_USD = 179396 WHERE JOURNAL_ID = 'CA01645024' AND JOURNAL_DATE = TO_DATE('30-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  226. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 179764, MAX_RATE = 179764, DAYRATE_USD = 179764 WHERE JOURNAL_ID = 'CA01492182' AND JOURNAL_DATE = TO_DATE('31-MAR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  227. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 188092, MAX_RATE = 188092, DAYRATE_USD = 188092 WHERE JOURNAL_ID = 'CA01786230' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  228. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 188092, MAX_RATE = 188092, DAYRATE_USD = 188092 WHERE JOURNAL_ID = 'CA01786230' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 18;
  229. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 186220, MAX_RATE = 186220, DAYRATE_USD = 186220 WHERE JOURNAL_ID = 'CA01836159' AND JOURNAL_DATE = TO_DATE('30-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  230. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 187267.9977464788732394366197183098591549, MAX_RATE = 187267.9977464788732394366197183098591549, DAYRATE_USD = 187267.9977464788732394366197183098591549 WHERE JOURNAL_ID = 'CA01872056' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  231. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 187267.9977464788732394366197183098591549, MAX_RATE = 187267.9977464788732394366197183098591549, DAYRATE_USD = 187267.9977464788732394366197183098591549 WHERE JOURNAL_ID = 'CA01872056' AND JOURNAL_DATE = TO_DATE('31-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  232. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 193092.0002689075630252100840336134453782, MAX_RATE = 193092.0002689075630252100840336134453782, DAYRATE_USD = 193092.0002689075630252100840336134453782 WHERE JOURNAL_ID = 'CA01781059' AND JOURNAL_DATE = TO_DATE('26-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  233. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 189963.9927272727272727272727272727272727, MAX_RATE = 189963.9927272727272727272727272727272727, DAYRATE_USD = 189963.9927272727272727272727272727272727 WHERE JOURNAL_ID = 'CA01755951' AND JOURNAL_DATE = TO_DATE('27-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 15;
  234. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 189963.9927272727272727272727272727272727, MAX_RATE = 189963.9927272727272727272727272727272727, DAYRATE_USD = 189963.9927272727272727272727272727272727 WHERE JOURNAL_ID = 'CA01744264' AND JOURNAL_DATE = TO_DATE('27-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 9;
  235. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 189963.9927272727272727272727272727272727, MAX_RATE = 189963.9927272727272727272727272727272727, DAYRATE_USD = 189963.9927272727272727272727272727272727 WHERE JOURNAL_ID = 'CA01717341' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  236. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 189963.9927272727272727272727272727272727, MAX_RATE = 189963.9927272727272727272727272727272727, DAYRATE_USD = 189963.9927272727272727272727272727272727 WHERE JOURNAL_ID = 'CA01744264' AND JOURNAL_DATE = TO_DATE('27-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 40;
  237. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 189963.9927272727272727272727272727272727, MAX_RATE = 189963.9927272727272727272727272727272727, DAYRATE_USD = 189963.9927272727272727272727272727272727 WHERE JOURNAL_ID = 'CA01715782' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  238. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 193435.9998051157125456760048721071863581, MAX_RATE = 193435.9998051157125456760048721071863581, DAYRATE_USD = 193435.9998051157125456760048721071863581 WHERE JOURNAL_ID = 'CA01912302' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  239. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 193435.9998051157125456760048721071863581, MAX_RATE = 193435.9998051157125456760048721071863581, DAYRATE_USD = 193435.9998051157125456760048721071863581 WHERE JOURNAL_ID = 'CA01949938' AND JOURNAL_DATE = TO_DATE('16-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 16;
  240. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 193435.9998051157125456760048721071863581, MAX_RATE = 193435.9998051157125456760048721071863581, DAYRATE_USD = 193435.9998051157125456760048721071863581 WHERE JOURNAL_ID = 'CA01948061' AND JOURNAL_DATE = TO_DATE('15-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  241. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 193435.9998051157125456760048721071863581, MAX_RATE = 193435.9998051157125456760048721071863581, DAYRATE_USD = 193435.9998051157125456760048721071863581 WHERE JOURNAL_ID = 'CA01903680' AND JOURNAL_DATE = TO_DATE('26-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  242. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 193435.9998051157125456760048721071863581, MAX_RATE = 193435.9998051157125456760048721071863581, DAYRATE_USD = 193435.9998051157125456760048721071863581 WHERE JOURNAL_ID = 'CA01912302' AND JOURNAL_DATE = TO_DATE('31-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  243. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 190360, MAX_RATE = 190360, DAYRATE_USD = 190360 WHERE JOURNAL_ID = 'CA01749885' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  244. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 216000, MAX_RATE = 216000, DAYRATE_USD = 216000 WHERE JOURNAL_ID = 'CA01914794' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  245. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 216000, MAX_RATE = 216000, DAYRATE_USD = 216000 WHERE JOURNAL_ID = 'CA01912883' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 30;
  246. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 216000, MAX_RATE = 216000, DAYRATE_USD = 216000 WHERE JOURNAL_ID = 'CA01914794' AND JOURNAL_DATE = TO_DATE('31-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  247. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 216000, MAX_RATE = 216000, DAYRATE_USD = 216000 WHERE JOURNAL_ID = 'CA01912883' AND JOURNAL_DATE = TO_DATE('31-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 30;
  248. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 220217.986494915254237288135593220338983, MAX_RATE = 220217.986494915254237288135593220338983, DAYRATE_USD = 220217.986494915254237288135593220338983 WHERE JOURNAL_ID = 'CA01910407' AND JOURNAL_DATE = TO_DATE('01-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  249. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 220217.986494915254237288135593220338983, MAX_RATE = 220217.986494915254237288135593220338983, DAYRATE_USD = 220217.986494915254237288135593220338983 WHERE JOURNAL_ID = 'CA01871471' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  250. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274182, MAX_RATE = 274182, DAYRATE_USD = 274182 WHERE JOURNAL_ID = 'CA01402587' AND JOURNAL_DATE = TO_DATE('14-FEB-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  251. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274182, MAX_RATE = 274182, DAYRATE_USD = 274182 WHERE JOURNAL_ID = 'CA01400769' AND JOURNAL_DATE = TO_DATE('11-FEB-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  252. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274182, MAX_RATE = 274182, DAYRATE_USD = 274182 WHERE JOURNAL_ID = 'CA01376108' AND JOURNAL_DATE = TO_DATE('31-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  253. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274182, MAX_RATE = 274182, DAYRATE_USD = 274182 WHERE JOURNAL_ID = 'CA01353260' AND JOURNAL_DATE = TO_DATE('12-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  254. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01871738' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 18;
  255. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01955842' AND JOURNAL_DATE = TO_DATE('29-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  256. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01955842' AND JOURNAL_DATE = TO_DATE('29-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  257. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01955842' AND JOURNAL_DATE = TO_DATE('29-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 7;
  258. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01955842' AND JOURNAL_DATE = TO_DATE('29-FEB-12', 'DD-MON-YY') AND JOURNAL_LINE = 5;
  259. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01835821' AND JOURNAL_DATE = TO_DATE('29-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  260. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01837600' AND JOURNAL_DATE = TO_DATE('27-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  261. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01871670' AND JOURNAL_DATE = TO_DATE('31-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  262. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01786417' AND JOURNAL_DATE = TO_DATE('28-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  263. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01786417' AND JOURNAL_DATE = TO_DATE('28-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 12;
  264. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01837600' AND JOURNAL_DATE = TO_DATE('27-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  265. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01871738' AND JOURNAL_DATE = TO_DATE('31-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 18;
  266. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01786417' AND JOURNAL_DATE = TO_DATE('28-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  267. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01835793' AND JOURNAL_DATE = TO_DATE('30-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  268. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01786938' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 24;
  269. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01871670' AND JOURNAL_DATE = TO_DATE('31-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  270. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01835793' AND JOURNAL_DATE = TO_DATE('30-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  271. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01714023' AND JOURNAL_DATE = TO_DATE('29-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  272. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01677507' AND JOURNAL_DATE = TO_DATE('27-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  273. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01681082' AND JOURNAL_DATE = TO_DATE('29-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  274. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01750299' AND JOURNAL_DATE = TO_DATE('29-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  275. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01677507' AND JOURNAL_DATE = TO_DATE('27-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  276. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01656604' AND JOURNAL_DATE = TO_DATE('07-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 14;
  277. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01714023' AND JOURNAL_DATE = TO_DATE('29-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  278. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01753360' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 45;
  279. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01750299' AND JOURNAL_DATE = TO_DATE('29-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 16;
  280. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01716356' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 22;
  281. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01750299' AND JOURNAL_DATE = TO_DATE('29-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 15;
  282. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01714023' AND JOURNAL_DATE = TO_DATE('29-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  283. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01614462' AND JOURNAL_DATE = TO_DATE('08-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  284. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01595904' AND JOURNAL_DATE = TO_DATE('30-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  285. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 274638.997183098591549295774647887323944, MAX_RATE = 274638.997183098591549295774647887323944, DAYRATE_USD = 274638.997183098591549295774647887323944 WHERE JOURNAL_ID = 'CA01644377' AND JOURNAL_DATE = TO_DATE('29-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  286. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 294999.9991709844559585492227979274611392, MAX_RATE = 294999.9991709844559585492227979274611392, DAYRATE_USD = 294999.9991709844559585492227979274611392 WHERE JOURNAL_ID = 'CA01480912' AND JOURNAL_DATE = TO_DATE('24-MAR-11', 'DD-MON-YY') AND JOURNAL_LINE = 25;
  287. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 318712.4998677443056576047024246877296096, MAX_RATE = 318712.4998677443056576047024246877296096, DAYRATE_USD = 318712.4998677443056576047024246877296096 WHERE JOURNAL_ID = 'CA01658489' AND JOURNAL_DATE = TO_DATE('09-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  288. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 318712.4998677443056576047024246877296096, MAX_RATE = 318712.4998677443056576047024246877296096, DAYRATE_USD = 318712.4998677443056576047024246877296096 WHERE JOURNAL_ID = 'CA01679759' AND JOURNAL_DATE = TO_DATE('29-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  289. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 318712.4998677443056576047024246877296096, MAX_RATE = 318712.4998677443056576047024246877296096, DAYRATE_USD = 318712.4998677443056576047024246877296096 WHERE JOURNAL_ID = 'CA01643393' AND JOURNAL_DATE = TO_DATE('29-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  290. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 318712.4998677443056576047024246877296096, MAX_RATE = 318712.4998677443056576047024246877296096, DAYRATE_USD = 318712.4998677443056576047024246877296096 WHERE JOURNAL_ID = 'CA01511776' AND JOURNAL_DATE = TO_DATE('12-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  291. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 318712.4998677443056576047024246877296096, MAX_RATE = 318712.4998677443056576047024246877296096, DAYRATE_USD = 318712.4998677443056576047024246877296096 WHERE JOURNAL_ID = 'CA01579013' AND JOURNAL_DATE = TO_DATE('04-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  292. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 318712.4998677443056576047024246877296096, MAX_RATE = 318712.4998677443056576047024246877296096, DAYRATE_USD = 318712.4998677443056576047024246877296096 WHERE JOURNAL_ID = 'CA01579014' AND JOURNAL_DATE = TO_DATE('13-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  293. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 318712.4998677443056576047024246877296096, MAX_RATE = 318712.4998677443056576047024246877296096, DAYRATE_USD = 318712.4998677443056576047024246877296096 WHERE JOURNAL_ID = 'CA01610503' AND JOURNAL_DATE = TO_DATE('07-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 1;
  294. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 318712.4998677443056576047024246877296096, MAX_RATE = 318712.4998677443056576047024246877296096, DAYRATE_USD = 318712.4998677443056576047024246877296096 WHERE JOURNAL_ID = 'CA01554216' AND JOURNAL_DATE = TO_DATE('30-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  295. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 318712.4998677443056576047024246877296096, MAX_RATE = 318712.4998677443056576047024246877296096, DAYRATE_USD = 318712.4998677443056576047024246877296096 WHERE JOURNAL_ID = 'CA01599717' AND JOURNAL_DATE = TO_DATE('31-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  296. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 318712.4998677443056576047024246877296096, MAX_RATE = 318712.4998677443056576047024246877296096, DAYRATE_USD = 318712.4998677443056576047024246877296096 WHERE JOURNAL_ID = 'CA01597207' AND JOURNAL_DATE = TO_DATE('31-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  297. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 318712.4998677443056576047024246877296096, MAX_RATE = 318712.4998677443056576047024246877296096, DAYRATE_USD = 318712.4998677443056576047024246877296096 WHERE JOURNAL_ID = 'CA01487605' AND JOURNAL_DATE = TO_DATE('30-MAR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  298. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01872054' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  299. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01865302' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 19;
  300. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01865302' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  301. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01865302' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  302. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01865219' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 22;
  303. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01865219' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 20;
  304. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01865219' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 11;
  305. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01864973' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 19;
  306. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01864973' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  307. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01864973' AND JOURNAL_DATE = TO_DATE('01-JAN-12', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  308. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01865302' AND JOURNAL_DATE = TO_DATE('31-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  309. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01834800' AND JOURNAL_DATE = TO_DATE('26-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 17;
  310. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01834801' AND JOURNAL_DATE = TO_DATE('27-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 14;
  311. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01865219' AND JOURNAL_DATE = TO_DATE('31-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 22;
  312. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01834799' AND JOURNAL_DATE = TO_DATE('25-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 7;
  313. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01834800' AND JOURNAL_DATE = TO_DATE('26-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 30;
  314. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01785929' AND JOURNAL_DATE = TO_DATE('27-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  315. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01865302' AND JOURNAL_DATE = TO_DATE('31-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 19;
  316. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01872054' AND JOURNAL_DATE = TO_DATE('31-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  317. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01761453' AND JOURNAL_DATE = TO_DATE('08-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 7;
  318. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01834800' AND JOURNAL_DATE = TO_DATE('26-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 13;
  319. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01865219' AND JOURNAL_DATE = TO_DATE('31-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 11;
  320. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01834801' AND JOURNAL_DATE = TO_DATE('27-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 7;
  321. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01862622' AND JOURNAL_DATE = TO_DATE('07-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  322. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01834799' AND JOURNAL_DATE = TO_DATE('25-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 11;
  323. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01785927' AND JOURNAL_DATE = TO_DATE('25-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 5;
  324. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01785928' AND JOURNAL_DATE = TO_DATE('26-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  325. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01834801' AND JOURNAL_DATE = TO_DATE('27-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  326. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01761452' AND JOURNAL_DATE = TO_DATE('07-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  327. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01798818' AND JOURNAL_DATE = TO_DATE('07-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 11;
  328. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01864973' AND JOURNAL_DATE = TO_DATE('31-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 19;
  329. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01862622' AND JOURNAL_DATE = TO_DATE('07-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  330. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01864973' AND JOURNAL_DATE = TO_DATE('31-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  331. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01865302' AND JOURNAL_DATE = TO_DATE('31-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  332. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01864973' AND JOURNAL_DATE = TO_DATE('31-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  333. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01865219' AND JOURNAL_DATE = TO_DATE('31-DEC-11', 'DD-MON-YY') AND JOURNAL_LINE = 20;
  334. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01798818' AND JOURNAL_DATE = TO_DATE('07-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 14;
  335. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01834799' AND JOURNAL_DATE = TO_DATE('25-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 21;
  336. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01731869' AND JOURNAL_DATE = TO_DATE('08-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  337. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01750904' AND JOURNAL_DATE = TO_DATE('26-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  338. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01677890' AND JOURNAL_DATE = TO_DATE('27-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  339. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01692433' AND JOURNAL_DATE = TO_DATE('05-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  340. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01716736' AND JOURNAL_DATE = TO_DATE('26-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 1;
  341. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01750905' AND JOURNAL_DATE = TO_DATE('27-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  342. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01679553' AND JOURNAL_DATE = TO_DATE('29-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 9;
  343. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01750903' AND JOURNAL_DATE = TO_DATE('25-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 5;
  344. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01716737' AND JOURNAL_DATE = TO_DATE('27-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 1;
  345. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 307008.9394552529182879377431906614785984, MAX_RATE = 307008.9394552529182879377431906614785984, DAYRATE_USD = 307008.9394552529182879377431906614785984 WHERE JOURNAL_ID = 'CA01716735' AND JOURNAL_DATE = TO_DATE('25-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 1;
  346. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 357000, MAX_RATE = 357000, DAYRATE_USD = 357000 WHERE JOURNAL_ID = 'CA01679982' AND JOURNAL_DATE = TO_DATE('29-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  347. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 357000, MAX_RATE = 357000, DAYRATE_USD = 357000 WHERE JOURNAL_ID = 'CA01652204' AND JOURNAL_DATE = TO_DATE('06-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  348. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 357000, MAX_RATE = 357000, DAYRATE_USD = 357000 WHERE JOURNAL_ID = 'CA01646852' AND JOURNAL_DATE = TO_DATE('30-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  349. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 325740.199826539462272333044232437120556, MAX_RATE = 325740.199826539462272333044232437120556, DAYRATE_USD = 325740.199826539462272333044232437120556 WHERE JOURNAL_ID = 'CA01715633' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  350. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 325740.199826539462272333044232437120556, MAX_RATE = 325740.199826539462272333044232437120556, DAYRATE_USD = 325740.199826539462272333044232437120556 WHERE JOURNAL_ID = 'CA01683087' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  351. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 325740.199826539462272333044232437120556, MAX_RATE = 325740.199826539462272333044232437120556, DAYRATE_USD = 325740.199826539462272333044232437120556 WHERE JOURNAL_ID = 'CA01670422' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  352. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 325740.199826539462272333044232437120556, MAX_RATE = 325740.199826539462272333044232437120556, DAYRATE_USD = 325740.199826539462272333044232437120556 WHERE JOURNAL_ID = 'CA01647669' AND JOURNAL_DATE = TO_DATE('30-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  353. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 325740.199826539462272333044232437120556, MAX_RATE = 325740.199826539462272333044232437120556, DAYRATE_USD = 325740.199826539462272333044232437120556 WHERE JOURNAL_ID = 'CA01647824' AND JOURNAL_DATE = TO_DATE('30-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  354. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 325740.199826539462272333044232437120556, MAX_RATE = 325740.199826539462272333044232437120556, DAYRATE_USD = 325740.199826539462272333044232437120556 WHERE JOURNAL_ID = 'CA01647824' AND JOURNAL_DATE = TO_DATE('30-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 18;
  355. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 347085, MAX_RATE = 347085, DAYRATE_USD = 347085 WHERE JOURNAL_ID = 'CA01753063' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  356. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 347085, MAX_RATE = 347085, DAYRATE_USD = 347085 WHERE JOURNAL_ID = 'CA01753063' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  357. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 367188, MAX_RATE = 367188, DAYRATE_USD = 367188 WHERE JOURNAL_ID = 'CA01792995' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  358. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 367188, MAX_RATE = 367188, DAYRATE_USD = 367188 WHERE JOURNAL_ID = 'CA01791665' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  359. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 367188, MAX_RATE = 367188, DAYRATE_USD = 367188 WHERE JOURNAL_ID = 'CA01792995' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 5;
  360. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 367188, MAX_RATE = 367188, DAYRATE_USD = 367188 WHERE JOURNAL_ID = 'CA01791665' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 5;
  361. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 367188, MAX_RATE = 367188, DAYRATE_USD = 367188 WHERE JOURNAL_ID = 'CA01717539' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  362. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 367188, MAX_RATE = 367188, DAYRATE_USD = 367188 WHERE JOURNAL_ID = 'CA01753065' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  363. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 367188, MAX_RATE = 367188, DAYRATE_USD = 367188 WHERE JOURNAL_ID = 'CA01732734' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 17;
  364. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 367188, MAX_RATE = 367188, DAYRATE_USD = 367188 WHERE JOURNAL_ID = 'CA01683088' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  365. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 367188, MAX_RATE = 367188, DAYRATE_USD = 367188 WHERE JOURNAL_ID = 'CA01732884' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  366. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 367188, MAX_RATE = 367188, DAYRATE_USD = 367188 WHERE JOURNAL_ID = 'CA01717539' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  367. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 367188, MAX_RATE = 367188, DAYRATE_USD = 367188 WHERE JOURNAL_ID = 'CA01732734' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  368. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 367188, MAX_RATE = 367188, DAYRATE_USD = 367188 WHERE JOURNAL_ID = 'CA01753065' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  369. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 408000, MAX_RATE = 408000, DAYRATE_USD = 408000 WHERE JOURNAL_ID = 'CA01838436' AND JOURNAL_DATE = TO_DATE('29-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  370. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 408000, MAX_RATE = 408000, DAYRATE_USD = 408000 WHERE JOURNAL_ID = 'CA01838436' AND JOURNAL_DATE = TO_DATE('29-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  371. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 408000, MAX_RATE = 408000, DAYRATE_USD = 408000 WHERE JOURNAL_ID = 'CA01838567' AND JOURNAL_DATE = TO_DATE('29-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  372. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 408000, MAX_RATE = 408000, DAYRATE_USD = 408000 WHERE JOURNAL_ID = 'CA01832759' AND JOURNAL_DATE = TO_DATE('29-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  373. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 408000, MAX_RATE = 408000, DAYRATE_USD = 408000 WHERE JOURNAL_ID = 'CA01832759' AND JOURNAL_DATE = TO_DATE('29-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  374. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 408000, MAX_RATE = 408000, DAYRATE_USD = 408000 WHERE JOURNAL_ID = 'CA01786107' AND JOURNAL_DATE = TO_DATE('30-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  375. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 408000, MAX_RATE = 408000, DAYRATE_USD = 408000 WHERE JOURNAL_ID = 'CA01832759' AND JOURNAL_DATE = TO_DATE('29-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  376. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 408000, MAX_RATE = 408000, DAYRATE_USD = 408000 WHERE JOURNAL_ID = 'CA01838567' AND JOURNAL_DATE = TO_DATE('29-NOV-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  377. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 408000, MAX_RATE = 408000, DAYRATE_USD = 408000 WHERE JOURNAL_ID = 'CA01786107' AND JOURNAL_DATE = TO_DATE('30-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 12;
  378. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 456499.9999999999999999999999999999999992, MAX_RATE = 456499.9999999999999999999999999999999992, DAYRATE_USD = 456499.9999999999999999999999999999999992 WHERE JOURNAL_ID = 'CA01436650' AND JOURNAL_DATE = TO_DATE('04-MAR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  379. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 456499.9999999999999999999999999999999992, MAX_RATE = 456499.9999999999999999999999999999999992, DAYRATE_USD = 456499.9999999999999999999999999999999992 WHERE JOURNAL_ID = 'CA01459873' AND JOURNAL_DATE = TO_DATE('15-MAR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  380. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 456499.9999999999999999999999999999999992, MAX_RATE = 456499.9999999999999999999999999999999992, DAYRATE_USD = 456499.9999999999999999999999999999999992 WHERE JOURNAL_ID = 'CA01428991' AND JOURNAL_DATE = TO_DATE('28-FEB-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  381. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 471163.9999999999999999999999999999999992, MAX_RATE = 471163.9999999999999999999999999999999992, DAYRATE_USD = 471163.9999999999999999999999999999999992 WHERE JOURNAL_ID = 'CA01513259' AND JOURNAL_DATE = TO_DATE('13-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  382. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 471163.9999999999999999999999999999999992, MAX_RATE = 471163.9999999999999999999999999999999992, DAYRATE_USD = 471163.9999999999999999999999999999999992 WHERE JOURNAL_ID = 'CA01510832' AND JOURNAL_DATE = TO_DATE('11-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  383. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 471163.9999999999999999999999999999999992, MAX_RATE = 471163.9999999999999999999999999999999992, DAYRATE_USD = 471163.9999999999999999999999999999999992 WHERE JOURNAL_ID = 'CA01600369' AND JOURNAL_DATE = TO_DATE('31-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 21;
  384. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 471163.9999999999999999999999999999999992, MAX_RATE = 471163.9999999999999999999999999999999992, DAYRATE_USD = 471163.9999999999999999999999999999999992 WHERE JOURNAL_ID = 'CA01535391' AND JOURNAL_DATE = TO_DATE('18-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  385. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 471163.9999999999999999999999999999999992, MAX_RATE = 471163.9999999999999999999999999999999992, DAYRATE_USD = 471163.9999999999999999999999999999999992 WHERE JOURNAL_ID = 'CA01554059' AND JOURNAL_DATE = TO_DATE('30-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 5;
  386. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 471163.9999999999999999999999999999999992, MAX_RATE = 471163.9999999999999999999999999999999992, DAYRATE_USD = 471163.9999999999999999999999999999999992 WHERE JOURNAL_ID = 'CA01488215' AND JOURNAL_DATE = TO_DATE('31-MAR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  387. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 483770.9999138549892318736539842067480264, MAX_RATE = 483770.9999138549892318736539842067480264, DAYRATE_USD = 483770.9999138549892318736539842067480264 WHERE JOURNAL_ID = 'CA01513303' AND JOURNAL_DATE = TO_DATE('13-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  388. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 483770.9999138549892318736539842067480264, MAX_RATE = 483770.9999138549892318736539842067480264, DAYRATE_USD = 483770.9999138549892318736539842067480264 WHERE JOURNAL_ID = 'CA01510832' AND JOURNAL_DATE = TO_DATE('11-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  389. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 483770.9999138549892318736539842067480264, MAX_RATE = 483770.9999138549892318736539842067480264, DAYRATE_USD = 483770.9999138549892318736539842067480264 WHERE JOURNAL_ID = 'CA01600369' AND JOURNAL_DATE = TO_DATE('31-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 14;
  390. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 483770.9999138549892318736539842067480264, MAX_RATE = 483770.9999138549892318736539842067480264, DAYRATE_USD = 483770.9999138549892318736539842067480264 WHERE JOURNAL_ID = 'CA01613852' AND JOURNAL_DATE = TO_DATE('09-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  391. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 483770.9999138549892318736539842067480264, MAX_RATE = 483770.9999138549892318736539842067480264, DAYRATE_USD = 483770.9999138549892318736539842067480264 WHERE JOURNAL_ID = 'CA01554059' AND JOURNAL_DATE = TO_DATE('30-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 16;
  392. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 483770.9999138549892318736539842067480264, MAX_RATE = 483770.9999138549892318736539842067480264, DAYRATE_USD = 483770.9999138549892318736539842067480264 WHERE JOURNAL_ID = 'CA01506559' AND JOURNAL_DATE = TO_DATE('08-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  393. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 483770.9999138549892318736539842067480264, MAX_RATE = 483770.9999138549892318736539842067480264, DAYRATE_USD = 483770.9999138549892318736539842067480264 WHERE JOURNAL_ID = 'CA01513515' AND JOURNAL_DATE = TO_DATE('13-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  394. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 483770.9999138549892318736539842067480264, MAX_RATE = 483770.9999138549892318736539842067480264, DAYRATE_USD = 483770.9999138549892318736539842067480264 WHERE JOURNAL_ID = 'CA01445611' AND JOURNAL_DATE = TO_DATE('08-MAR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  395. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 483770.9999138549892318736539842067480264, MAX_RATE = 483770.9999138549892318736539842067480264, DAYRATE_USD = 483770.9999138549892318736539842067480264 WHERE JOURNAL_ID = 'CA01490020' AND JOURNAL_DATE = TO_DATE('31-MAR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  396. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 483770.9999138549892318736539842067480264, MAX_RATE = 483770.9999138549892318736539842067480264, DAYRATE_USD = 483770.9999138549892318736539842067480264 WHERE JOURNAL_ID = 'CA01490020' AND JOURNAL_DATE = TO_DATE('31-MAR-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  397. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 483770.9999138549892318736539842067480264, MAX_RATE = 483770.9999138549892318736539842067480264, DAYRATE_USD = 483770.9999138549892318736539842067480264 WHERE JOURNAL_ID = 'CA01422911' AND JOURNAL_DATE = TO_DATE('28-FEB-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  398. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 536499.9992079207920792079207920792079216, MAX_RATE = 536499.9992079207920792079207920792079216, DAYRATE_USD = 536499.9992079207920792079207920792079216 WHERE JOURNAL_ID = 'CA01448601' AND JOURNAL_DATE = TO_DATE('09-MAR-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  399. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 536499.9992079207920792079207920792079216, MAX_RATE = 536499.9992079207920792079207920792079216, DAYRATE_USD = 536499.9992079207920792079207920792079216 WHERE JOURNAL_ID = 'CA01448601' AND JOURNAL_DATE = TO_DATE('09-MAR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  400. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 536499.9992079207920792079207920792079216, MAX_RATE = 536499.9992079207920792079207920792079216, DAYRATE_USD = 536499.9992079207920792079207920792079216 WHERE JOURNAL_ID = 'CA01424676' AND JOURNAL_DATE = TO_DATE('28-FEB-11', 'DD-MON-YY') AND JOURNAL_LINE = 10;
  401. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 536499.9992079207920792079207920792079216, MAX_RATE = 536499.9992079207920792079207920792079216, DAYRATE_USD = 536499.9992079207920792079207920792079216 WHERE JOURNAL_ID = 'CA01400155' AND JOURNAL_DATE = TO_DATE('10-FEB-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  402. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 536499.9992079207920792079207920792079216, MAX_RATE = 536499.9992079207920792079207920792079216, DAYRATE_USD = 536499.9992079207920792079207920792079216 WHERE JOURNAL_ID = 'CA01375217' AND JOURNAL_DATE = TO_DATE('28-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  403. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 536499.9992079207920792079207920792079216, MAX_RATE = 536499.9992079207920792079207920792079216, DAYRATE_USD = 536499.9992079207920792079207920792079216 WHERE JOURNAL_ID = 'CA01362797' AND JOURNAL_DATE = TO_DATE('21-JAN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  404. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 486279.9996475770925110132158590308370056, MAX_RATE = 486279.9996475770925110132158590308370056, DAYRATE_USD = 486279.9996475770925110132158590308370056 WHERE JOURNAL_ID = 'CA01792285' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  405. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 486279.9996475770925110132158590308370056, MAX_RATE = 486279.9996475770925110132158590308370056, DAYRATE_USD = 486279.9996475770925110132158590308370056 WHERE JOURNAL_ID = 'CA01792285' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  406. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 512854.9995505617977528089887640449438192, MAX_RATE = 512854.9995505617977528089887640449438192, DAYRATE_USD = 512854.9995505617977528089887640449438192 WHERE JOURNAL_ID = 'CA01764531' AND JOURNAL_DATE = TO_DATE('12-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  407. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 512854.9995505617977528089887640449438192, MAX_RATE = 512854.9995505617977528089887640449438192, DAYRATE_USD = 512854.9995505617977528089887640449438192 WHERE JOURNAL_ID = 'CA01764531' AND JOURNAL_DATE = TO_DATE('12-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  408. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 512854.9995505617977528089887640449438192, MAX_RATE = 512854.9995505617977528089887640449438192, DAYRATE_USD = 512854.9995505617977528089887640449438192 WHERE JOURNAL_ID = 'CA01783955' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 144;
  409. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 512854.9995505617977528089887640449438192, MAX_RATE = 512854.9995505617977528089887640449438192, DAYRATE_USD = 512854.9995505617977528089887640449438192 WHERE JOURNAL_ID = 'CA01667818' AND JOURNAL_DATE = TO_DATE('19-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  410. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 512854.9995505617977528089887640449438192, MAX_RATE = 512854.9995505617977528089887640449438192, DAYRATE_USD = 512854.9995505617977528089887640449438192 WHERE JOURNAL_ID = 'CA01750309' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 124;
  411. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 512854.9995505617977528089887640449438192, MAX_RATE = 512854.9995505617977528089887640449438192, DAYRATE_USD = 512854.9995505617977528089887640449438192 WHERE JOURNAL_ID = 'CA01680330' AND JOURNAL_DATE = TO_DATE('29-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  412. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 512854.9995505617977528089887640449438192, MAX_RATE = 512854.9995505617977528089887640449438192, DAYRATE_USD = 512854.9995505617977528089887640449438192 WHERE JOURNAL_ID = 'CA01730540' AND JOURNAL_DATE = TO_DATE('12-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  413. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 512854.9995505617977528089887640449438192, MAX_RATE = 512854.9995505617977528089887640449438192, DAYRATE_USD = 512854.9995505617977528089887640449438192 WHERE JOURNAL_ID = 'CA01667818' AND JOURNAL_DATE = TO_DATE('19-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  414. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 512854.9995505617977528089887640449438192, MAX_RATE = 512854.9995505617977528089887640449438192, DAYRATE_USD = 512854.9995505617977528089887640449438192 WHERE JOURNAL_ID = 'CA01694389' AND JOURNAL_DATE = TO_DATE('08-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  415. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 512854.9995505617977528089887640449438192, MAX_RATE = 512854.9995505617977528089887640449438192, DAYRATE_USD = 512854.9995505617977528089887640449438192 WHERE JOURNAL_ID = 'CA01715784' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  416. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 512854.9995505617977528089887640449438192, MAX_RATE = 512854.9995505617977528089887640449438192, DAYRATE_USD = 512854.9995505617977528089887640449438192 WHERE JOURNAL_ID = 'CA01642140' AND JOURNAL_DATE = TO_DATE('28-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  417. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 519289.9991489361702127659574468085106384, MAX_RATE = 519289.9991489361702127659574468085106384, DAYRATE_USD = 519289.9991489361702127659574468085106384 WHERE JOURNAL_ID = 'CA01791469' AND JOURNAL_DATE = TO_DATE('31-OCT-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  418. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 519289.9991489361702127659574468085106384, MAX_RATE = 519289.9991489361702127659574468085106384, DAYRATE_USD = 519289.9991489361702127659574468085106384 WHERE JOURNAL_ID = 'CA01683521' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  419. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 519289.9991489361702127659574468085106384, MAX_RATE = 519289.9991489361702127659574468085106384, DAYRATE_USD = 519289.9991489361702127659574468085106384 WHERE JOURNAL_ID = 'CA01738995' AND JOURNAL_DATE = TO_DATE('21-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  420. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 519289.9991489361702127659574468085106384, MAX_RATE = 519289.9991489361702127659574468085106384, DAYRATE_USD = 519289.9991489361702127659574468085106384 WHERE JOURNAL_ID = 'CA01753357' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 8;
  421. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 519289.9991489361702127659574468085106384, MAX_RATE = 519289.9991489361702127659574468085106384, DAYRATE_USD = 519289.9991489361702127659574468085106384 WHERE JOURNAL_ID = 'CA01753357' AND JOURNAL_DATE = TO_DATE('30-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  422. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 519289.9991489361702127659574468085106384, MAX_RATE = 519289.9991489361702127659574468085106384, DAYRATE_USD = 519289.9991489361702127659574468085106384 WHERE JOURNAL_ID = 'CA01739189' AND JOURNAL_DATE = TO_DATE('21-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  423. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 519289.9991489361702127659574468085106384, MAX_RATE = 519289.9991489361702127659574468085106384, DAYRATE_USD = 519289.9991489361702127659574468085106384 WHERE JOURNAL_ID = 'CA01680324' AND JOURNAL_DATE = TO_DATE('08-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  424. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 519289.9991489361702127659574468085106384, MAX_RATE = 519289.9991489361702127659574468085106384, DAYRATE_USD = 519289.9991489361702127659574468085106384 WHERE JOURNAL_ID = 'CA01739130' AND JOURNAL_DATE = TO_DATE('21-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 12;
  425. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 519289.9991489361702127659574468085106384, MAX_RATE = 519289.9991489361702127659574468085106384, DAYRATE_USD = 519289.9991489361702127659574468085106384 WHERE JOURNAL_ID = 'CA01718497' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  426. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 519289.9991489361702127659574468085106384, MAX_RATE = 519289.9991489361702127659574468085106384, DAYRATE_USD = 519289.9991489361702127659574468085106384 WHERE JOURNAL_ID = 'CA01738995' AND JOURNAL_DATE = TO_DATE('21-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  427. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 519289.9991489361702127659574468085106384, MAX_RATE = 519289.9991489361702127659574468085106384, DAYRATE_USD = 519289.9991489361702127659574468085106384 WHERE JOURNAL_ID = 'CA01739130' AND JOURNAL_DATE = TO_DATE('21-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  428. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 519289.9991489361702127659574468085106384, MAX_RATE = 519289.9991489361702127659574468085106384, DAYRATE_USD = 519289.9991489361702127659574468085106384 WHERE JOURNAL_ID = 'CA01739130' AND JOURNAL_DATE = TO_DATE('21-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  429. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 519289.9991489361702127659574468085106384, MAX_RATE = 519289.9991489361702127659574468085106384, DAYRATE_USD = 519289.9991489361702127659574468085106384 WHERE JOURNAL_ID = 'CA01641990' AND JOURNAL_DATE = TO_DATE('28-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  430. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 547882.0000000000000000000000000000000008, MAX_RATE = 547882.0000000000000000000000000000000008, DAYRATE_USD = 547882.0000000000000000000000000000000008 WHERE JOURNAL_ID = 'CA01731868' AND JOURNAL_DATE = TO_DATE('13-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  431. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 547882.0000000000000000000000000000000008, MAX_RATE = 547882.0000000000000000000000000000000008, DAYRATE_USD = 547882.0000000000000000000000000000000008 WHERE JOURNAL_ID = 'CA01719372' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  432. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 547882.0000000000000000000000000000000008, MAX_RATE = 547882.0000000000000000000000000000000008, DAYRATE_USD = 547882.0000000000000000000000000000000008 WHERE JOURNAL_ID = 'CA01683990' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  433. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 547882.0000000000000000000000000000000008, MAX_RATE = 547882.0000000000000000000000000000000008, DAYRATE_USD = 547882.0000000000000000000000000000000008 WHERE JOURNAL_ID = 'CA01684322' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 12;
  434. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 547882.0000000000000000000000000000000008, MAX_RATE = 547882.0000000000000000000000000000000008, DAYRATE_USD = 547882.0000000000000000000000000000000008 WHERE JOURNAL_ID = 'CA01684135' AND JOURNAL_DATE = TO_DATE('31-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  435. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 547882.0000000000000000000000000000000008, MAX_RATE = 547882.0000000000000000000000000000000008, DAYRATE_USD = 547882.0000000000000000000000000000000008 WHERE JOURNAL_ID = 'CA01716652' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  436. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 547882.0000000000000000000000000000000008, MAX_RATE = 547882.0000000000000000000000000000000008, DAYRATE_USD = 547882.0000000000000000000000000000000008 WHERE JOURNAL_ID = 'CA01741333' AND JOURNAL_DATE = TO_DATE('22-SEP-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  437. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 547882.0000000000000000000000000000000008, MAX_RATE = 547882.0000000000000000000000000000000008, DAYRATE_USD = 547882.0000000000000000000000000000000008 WHERE JOURNAL_ID = 'CA01718598' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  438. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 547882.0000000000000000000000000000000008, MAX_RATE = 547882.0000000000000000000000000000000008, DAYRATE_USD = 547882.0000000000000000000000000000000008 WHERE JOURNAL_ID = 'CA01717838' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  439. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 547882.0000000000000000000000000000000008, MAX_RATE = 547882.0000000000000000000000000000000008, DAYRATE_USD = 547882.0000000000000000000000000000000008 WHERE JOURNAL_ID = 'CA01719372' AND JOURNAL_DATE = TO_DATE('31-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 4;
  440. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 547882.0000000000000000000000000000000008, MAX_RATE = 547882.0000000000000000000000000000000008, DAYRATE_USD = 547882.0000000000000000000000000000000008 WHERE JOURNAL_ID = 'CA01644032' AND JOURNAL_DATE = TO_DATE('30-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  441. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 547882.0000000000000000000000000000000008, MAX_RATE = 547882.0000000000000000000000000000000008, DAYRATE_USD = 547882.0000000000000000000000000000000008 WHERE JOURNAL_ID = 'CA01624504' AND JOURNAL_DATE = TO_DATE('16-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  442. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 659218.0005633802816901408450704225352112, MAX_RATE = 659218.0005633802816901408450704225352112, DAYRATE_USD = 659218.0005633802816901408450704225352112 WHERE JOURNAL_ID = 'CA01426756' AND JOURNAL_DATE = TO_DATE('28-FEB-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  443. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 660194.0000570206699928724162508909479696, MAX_RATE = 660194.0000570206699928724162508909479696, DAYRATE_USD = 660194.0000570206699928724162508909479696 WHERE JOURNAL_ID = 'CA01602192' AND JOURNAL_DATE = TO_DATE('31-MAY-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  444. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 660194.0000570206699928724162508909479696, MAX_RATE = 660194.0000570206699928724162508909479696, DAYRATE_USD = 660194.0000570206699928724162508909479696 WHERE JOURNAL_ID = 'CA01632210' AND JOURNAL_DATE = TO_DATE('24-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  445. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 660194.0000570206699928724162508909479696, MAX_RATE = 660194.0000570206699928724162508909479696, DAYRATE_USD = 660194.0000570206699928724162508909479696 WHERE JOURNAL_ID = 'CA01554549' AND JOURNAL_DATE = TO_DATE('30-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  446. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 660194.0000570206699928724162508909479696, MAX_RATE = 660194.0000570206699928724162508909479696, DAYRATE_USD = 660194.0000570206699928724162508909479696 WHERE JOURNAL_ID = 'CA01554059' AND JOURNAL_DATE = TO_DATE('30-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  447. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 660194.0000570206699928724162508909479696, MAX_RATE = 660194.0000570206699928724162508909479696, DAYRATE_USD = 660194.0000570206699928724162508909479696 WHERE JOURNAL_ID = 'CA01551571' AND JOURNAL_DATE = TO_DATE('29-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  448. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 660194.0000570206699928724162508909479696, MAX_RATE = 660194.0000570206699928724162508909479696, DAYRATE_USD = 660194.0000570206699928724162508909479696 WHERE JOURNAL_ID = 'CA01550312' AND JOURNAL_DATE = TO_DATE('28-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  449. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 660194.0000570206699928724162508909479696, MAX_RATE = 660194.0000570206699928724162508909479696, DAYRATE_USD = 660194.0000570206699928724162508909479696 WHERE JOURNAL_ID = 'CA01610502' AND JOURNAL_DATE = TO_DATE('07-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  450. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 660194.0000570206699928724162508909479696, MAX_RATE = 660194.0000570206699928724162508909479696, DAYRATE_USD = 660194.0000570206699928724162508909479696 WHERE JOURNAL_ID = 'CA01554428' AND JOURNAL_DATE = TO_DATE('30-APR-11', 'DD-MON-YY') AND JOURNAL_LINE = 6;
  451. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 702691.9998895027624309392265193370165744, MAX_RATE = 702691.9998895027624309392265193370165744, DAYRATE_USD = 702691.9998895027624309392265193370165744 WHERE JOURNAL_ID = 'CA01657233' AND JOURNAL_DATE = TO_DATE('08-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  452. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 702691.9998895027624309392265193370165744, MAX_RATE = 702691.9998895027624309392265193370165744, DAYRATE_USD = 702691.9998895027624309392265193370165744 WHERE JOURNAL_ID = 'CA01702582' AND JOURNAL_DATE = TO_DATE('15-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  453. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 702691.9998895027624309392265193370165744, MAX_RATE = 702691.9998895027624309392265193370165744, DAYRATE_USD = 702691.9998895027624309392265193370165744 WHERE JOURNAL_ID = 'CA01676792' AND JOURNAL_DATE = TO_DATE('27-JUL-11', 'DD-MON-YY') AND JOURNAL_LINE = 9;
  454. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 702691.9998895027624309392265193370165744, MAX_RATE = 702691.9998895027624309392265193370165744, DAYRATE_USD = 702691.9998895027624309392265193370165744 WHERE JOURNAL_ID = 'CA01702690' AND JOURNAL_DATE = TO_DATE('17-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  455. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 702691.9998895027624309392265193370165744, MAX_RATE = 702691.9998895027624309392265193370165744, DAYRATE_USD = 702691.9998895027624309392265193370165744 WHERE JOURNAL_ID = 'CA01694067' AND JOURNAL_DATE = TO_DATE('08-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 3;
  456. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 702691.9998895027624309392265193370165744, MAX_RATE = 702691.9998895027624309392265193370165744, DAYRATE_USD = 702691.9998895027624309392265193370165744 WHERE JOURNAL_ID = 'CA01721416' AND JOURNAL_DATE = TO_DATE('30-AUG-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  457. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 702691.9998895027624309392265193370165744, MAX_RATE = 702691.9998895027624309392265193370165744, DAYRATE_USD = 702691.9998895027624309392265193370165744 WHERE JOURNAL_ID = 'CA01628084' AND JOURNAL_DATE = TO_DATE('21-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 20;
  458. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 702691.9998895027624309392265193370165744, MAX_RATE = 702691.9998895027624309392265193370165744, DAYRATE_USD = 702691.9998895027624309392265193370165744 WHERE JOURNAL_ID = 'CA01623654' AND JOURNAL_DATE = TO_DATE('15-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  459. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 702691.9998895027624309392265193370165744, MAX_RATE = 702691.9998895027624309392265193370165744, DAYRATE_USD = 702691.9998895027624309392265193370165744 WHERE JOURNAL_ID = 'CA01623610' AND JOURNAL_DATE = TO_DATE('15-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  460. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 702691.9998895027624309392265193370165744, MAX_RATE = 702691.9998895027624309392265193370165744, DAYRATE_USD = 702691.9998895027624309392265193370165744 WHERE JOURNAL_ID = 'CA01645261' AND JOURNAL_DATE = TO_DATE('30-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 12;
  461. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 702691.9998895027624309392265193370165744, MAX_RATE = 702691.9998895027624309392265193370165744, DAYRATE_USD = 702691.9998895027624309392265193370165744 WHERE JOURNAL_ID = 'CA01645261' AND JOURNAL_DATE = TO_DATE('30-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 2;
  462. UPDATE SYSADM.PS_LEDGER_RATE_SNAPSHOT SET PPA_RATE = 3 AND CALCED_RATE = 702691.9998895027624309392265193370165744, MAX_RATE = 702691.9998895027624309392265193370165744, DAYRATE_USD = 702691.9998895027624309392265193370165744 WHERE JOURNAL_ID = 'CA01628084' AND JOURNAL_DATE = TO_DATE('21-JUN-11', 'DD-MON-YY') AND JOURNAL_LINE = 24;
  463. commit;
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!