ROS.60050(4`r    !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~\(h rwpuf]f_\(h rwpin_\(h rwplo_\]hy label(  MS Sans Serif label findl]hy field> ? z  MS Sans Serif132 field findf\ (h ucolsf_\ (h ucolsb_\ (h help_tu0 drawn drawnZ  MS Sans Serif# 0 outlinerOP,^-Z13!{ 1 labelOPZ%?_0808N[9\O(_\(_\M(_\P(_\Y(_( 0800O& @ `@0000>P,,  MS Sans Serif\(]^_`[9\(]_fg\(]_fg\(]_fg\(]_f08000 pe(h open_\@(h save_\(h cut_\(h copy_\(h paste_\\p3(h rwzmin_\p4(h rwzmot_\(h rwitd_\(h rwipn_\\(h rwlmg]f_\Y(h help_tuX0808VV@@s[9\\\ \ \q)(h rwlpl]_fg\q(h rwlpc]_fg\q*(h rwlpg]_fg\q8(h rwlpf]_fg\(h rwldr]f_\(h rwlpr]f_\(h rwlcm]f_\(h rwlud_\(h rwldd_\\(h rwspar_tu@r0 x;;  08lumn is ed@00ical parmetP080000 L`08mula col n p08 the Inv ce08d. 080808 08  $ P08FOREPFOR 08forePFor$re08 is begi* (0@org_context('171'); --102,108 null; return (TRUE); end;@@c0000~~function BeforePForm return boolean is begindpf8 p 88('  -` 88 r (TP 88 0&00x $08D r88g25b88,08x *rmula re 00r100g75b100,08x *egin l 00r100g100b100Qpp-p@NOOUNT; return lsaddress_line3pvsa.address_line3ADDRESS_LINE3retU FpHPQRSthen return 0; end;= prec; :c_base_min_acct_unit :=G_Dummy_bawbpcrstu descr;*/ RETURN (TRUE); RETURN NULL; EXCEPTION WHEN OTHERS THEN RETURaddress_line_1 { bpdvwxy>0808<"&&function CF_Invoice_Amount_FMTFormula return Cha8P_CONC_REQUEST_IDR bpdz{|}NT); SRW.USER_EXIT('FND FORMAT_CURRECF_Invoice_Amount_FMT hYtZp[ij(npr DISPLAY_WIDTH="17" AMOUNT=":C_INVOICE_AMOUNT" bp_check_datece0t Zp\ fh(npr_Amount_FMT" MINIMUM_PRECISION=":P_MIN(bp_line_9#mber0t Zp\gh(nproice_Amount_FMT); EXCEPTION WHEN OTHERS THEN RETURN NULL; bp_Balance&unt0 | Zp\qr(vpz paste_\\p3(h rwzmin_\p4(h rwzmot_\(h rwitd_\(h rwipn_\\(h rwlmg]f_\Y(h help_tuX0808VV@@s[9\\\ \ \q)(h rwlpl]_fg\q(h rwlpc]_fg\q*(h rwlpg]_fg\q8(h rwlpf]_fg\(h rwldr]f_\(h rwlpr]f_\(h rwlcm]f_\(h rwlud_\(h rwldd_\\(h rwspar_tu@r.hh,ROSATTRIBSclass attributes+hh)ROSLFDESCros lf descripn)hh' ROSOBJMAPros name->idT')+hh));ROSSTRINGStk2 uiStrings*hh(ROSSTRUCTSstruct typesND*hh(RWROSTK2RESVtk2 reservedͫhh0SRW2_ANCHOR&h!"h#$SRW2_BODY_LOCATION $h h!"SRW2_BOILERPLATEhhINSRW2_BUTTON!"hhSRW2_COLUMN#hh !SRW2_DATA_MODEL $h h!"SRW2_DISPLAY_TAG%h !h"#SRW2_DISTRIBUTION'ͫ hhͫSRW2_ELEMENThhSRW2_FIELD)h$%h&'SRW2_FORMAT_EXCEPTION&hhSRW2_FRAMEhhSRW2_GROUPER#hh !EASRW2_GROUP_NODE# "hh SRW2_HYPERLINK"$$h h!"MSRW2_JAVA_APPLET$(h#$h%&SRW2_JAVA_PROPERTIES%hhSRW2_LAYOUT %h !h"#SRW2_LAYOUT_GROUP hh SRW2_LINKhhSRW2_LISTS hhSRW2_MATRIX'h"#h$%SRW2_OGD_COLUMN_MAP$h h!"SRW2_OG_DOCUMENT#hh !SRW2_PARAM_FORMhhSRW2_QUERY %h !h"#SRW2_TEXT_SEGMENThhͫTOOL_ACCESS hhTOOL_COMMENT hhTOOL_LIBRARY hh TOOL_MODULEhh TOOL_PLSQL$pp"lVG_COLORVG_COLOR+pp $&'()VG_COLORITEMID(@+pp $&'()VG_COLORCELLID(@-pp &()*+VG_COLORNAME_SET@ xx/pp (*+,-VG_COLORNAME_LENGTH /pp (*+,-VG_COLORCOLOR_NAMEx 'pp "#$%VG_COLORRED )pp "$%&'VG_COLORGREEN Np)pp "$%&'VG_COLORBLUE hxn)x'p (Transaction !x(TypeR_S#x!SE( Our 6&x$\ (Reference$x"( Your &x$ (Reference"x ( Date(%x# ( Amount%x# (CIS Tax %x# (Withheld"x ( Nett@& x$ Project ! xName\0 x.\A Carillion company% x#q  Project # x! Number xRof! x]VPageY xW(=Your bank account will be credited with the above amount by _' x% Total Nett* x( Less Discount$ x"Balance! xh dPage_ xfof6 x4h***** No Data Found *****% x#j Project # x!jNumber% x#k Project ! xkName% x#m CIS Tax % x#m Withheld% x#o  Amount# x!p Date$ x"q Your & x$q Reference# x!r Our & x$r Reference6 x4***** End of Report *****8 x6Carillion Remittance Advice0 x.A Carillion company% x# Project # x!Number% x# Project ! xName" x  Nett% x# CIS Tax Pr 88` J 2jk0l8n0p8r8tv x0z0{|}0~ppppppppr'rJrJr_r_r_r_r_rbbrcrffrjrqqrrsr be w 'xi 97| 2

ORAFAQB(F0JK@N@R@V@Z0^0_0`0a0b0c d0f0ghi8j8l0nop rtpuppͫfr_r_r@@PjjwReport ParametersEnter values for the parameters$00x !"black(00x " $&IGwhite%00x "#green9=)00x# $&' darkgreen(00x " $& gray96 = = =(00x " $&gray92zzz(00x " $&gray88(00x " $&gray84(((%00x !"#r0g0b0(00x "$%& r25g0b0@(00x "$%&ͫ r50g0b0(00x "$%& r75g0b0(00x "$%& r88g0b0(00x "$%& r100g0b0(00x!" $&r0g0b50*00x "$ &(r25g0b50@ *00x "$ &(r50g0b50*00x "$ &(r75g0b50*00x "$ &(amr88g0b50tu,00x $& (*if r100g0b50(00x!" $&ldr0g0b75*00x "$ &(E)r25g0b75@; *00x "$ &(r50g0b75_C*00x "$ &(r75g0b75_C*00x "$ &(r88g0b75,00x $& (* r100g0b75(00x!" $&r0g0b88*00x "$ &(xr25g0b88@nc*00x "$ &(r50g0b88*00x "$ &(r75g0b88*00x "$ &(atr88g0b88,00x $& (* r100g0b88(00x"# $& r0g0b100,00x $& (*! r25g0b100@,00x $& (*" r50g0b100,00x $& (*# r75g0b100,00x $& (*\$ r88g0b100,00x $& (*x% r100g0b100&00x  "$&gray*00x " $ &('darkgray&00x "$(cyanr*00x" $ &(ac)darkcyanit(00x " $&y *gray80333333(00x " $&Ne+gray76=p=p=p(00x " $&is,gray72GGG(00x " $&la-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@h)00x " $&'**0r50g25b0@)00x " $&'1r75g25b0@x)00x " $&'2r88g25b0@k+00x $ &()3 r100g25b0@*00x" $ &(x4r0g25b50@x ,00x $ & (*5 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (* 8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(:r0g25b750@,00x $ & (*; r25g25b75@@,00x $ & (*< r50g25b75@,00x $ & (*ce= r75g25b75@,00x $ & (*ll> r88g25b75@,00x $ & (*oj? r100g25b75@*00x" $ &(@r0g25b885@x,00x $ & (*A r25g25b88@@,00x $ & (*B r50g25b88@,00x $ & (*xC r75g25b88@`r 88 RIBSclass attributes+hh)&'ROSLFDESCros lf descripC)hh'VWROSOBJMAPros name->idqrs+hh)ROSSTRINGStk2 uiStrings*hh(ROSSTRUCTSstruct types*hh(ROSTK2RESVtk2 reserved&h!"h#$SRW2_BODY_LOCATION #hh !SRW2_DATA_MODEL hhSRW2_LAYOUT hhSRW2_LISTS #hh !SRW2_PARAM_FORMhh\TOOL_ACCESSw hhTOOL_LIBRARY hhpiTOOL_MODULE$pp"wpVG_COLORVG_COLOR+pp $&'()VG_COLORITEMID(@+pp $&'()VG_COLORCELLID(@-pp &()*+VG_COLORNAME_SET@ ]/pp (*+,-VG_COLORNAME_LENGTH /pp (*+,-VG_COLORCOLOR_NAMEx'pp "#$%VG_COLORRED )pp "$%&'VG_COLORGREEN 0>u)pp "$%&'VG_COLORBLUE ucolsb_\ (h help_tu0 drawn drawnZ  MS Sans Serif# 0 outlinerOP,^-Z13!{ 1 labelOPZ%?_0808N[9\O(_\(_\M(_\P(_\Y(_( 0800O& @ `@0000>P,,  MS Sans Serif\(]^_`[9\(]_fg\(]_fg\(]_fg\(]_f08000 pe(h open_\@(h save_\(h cut_\(h copy_\(h paste_\\p3(h rwzmin_\p4(h rwzmot_\(h rwitd_\(h rwipn_\\(h rwlmg]f_\Y(h help_tuX0808VV@@s[9\\\ \ \q)(h rwlpl]_fg\q(h rwlpc]_fg\q*(h rwlpg]_fg\q8(h rwlpf]_fg\(h rwldr]f_\(h rwlpr]f_\(h rwlcm]f_\(h rwlud_\(h rwldd_\\(h rwspar_tupr 88 RIBSclass attributes+hh)&'ROSLFDESCros lf descripC)hh'VWROSOBJMAPros name->idqrs+hh)ROSSTRINGStk2 uiStrings*hh(ROSSTRUCTSstruct types*hh(ROSTK2RESVtk2 reserved&h!"h#$SRW2_BODY_LOCATION #hh !SRW2_DATA_MODEL hhSRW2_LAYOUT hhSRW2_LISTS #hh !SRW2_PARAM_FORMhh\TOOL_ACCESSw hhTOOL_LIBRARY hhpiTOOL_MODULE$pp"wpVG_COLORVG_COLOR+pp $&'()VG_COLORITEMID(@+pp $&'()VG_COLORCELLID(@-pp &()*+VG_COLORNAME_SET@ ]/pp (*+,-VG_COLORNAME_LENGTH /pp (*+,-VG_COLORCOLOR_NAMEx'pp "#$%VG_COLORRED )pp "$%&'VG_COLORGREEN 0>u)pp "$%&'VG_COLORBLUE ucolsb_\ (h help_tu0 drawn drawnZ  MS Sans Serif# 0 outlinerOP,^-Z13!{ 1 labelOPZ%?_0808N[9\O(_\(_\M(_\P(_\Y(_( 0800O& @ `@0000>P,,  MS Sans Serif\(]^_`[9\(]_fg\(]_fg\(]_fg\(]_f08000 pe(h open_\@(h save_\(h cut_\(h copy_\(h paste_\\p3(h rwzmin_\p4(h rwzmot_\(h rwitd_\(h rwipn_\\(h rwlmg]f_\Y(h help_tuX0808VV@@s[9\\\ \ \q)(h rwlpl]_fg\q(h rwlpc]_fg\q*(h rwlpg]_fg\q8(h rwlpf]_fg\(h rwldr]f_\(h rwlpr]f_\(h rwlcm]f_\(h rwlud_\(h rwldd_\\(h rwspar_tu`r[ N(0@@00@@@@@@000000ppp 00880 @A91AAAAAA"1&1'A*A.9214A:A>ABAFAJAN1R1STUVWXYUSdpf8  pXBtc `` jj@ B2_LAY ``B ``  otalNett_FMT" MINIMUM_PRECISION=":P_MIN_PRECISION" '); */ RETURN(:CF_TotalNett_FMT); EXCEPTION WHEN OTHERS THEN RETURN NULL; end;TA0808+1  $"CF_PROJECT_NUMBER3function CF_Project_Number return Char is l_proj_number pa_projects.segment1%type; BEGIN SELECT segment1 INTO l_proj_number FROM pa_projects_all WHERE project_id=:project_id; RETURN(l_proj_number); Exception When NO_DATA_FOUND then return(null); When Others then return(null); end;@@K0808I,33function CF_Project_Number return Char is l_proj_number pa_projects.segment1%type; BEGIN SELECT segment1 INTO l_proj_number FROM pa_projects_all WHERE project_id=:project_id; RETURN(l_proj_number); Exception When NO_DATA_FOUND then return(null); When Others then return(null); end;0808-1  $"CF_PROJECT_NAMEFORMULA/function CF_Project_NameFormula return Char is l_project_name pa_projects.name%type; BEGIN SELECT NAME INTO l_project_name FROM PA_PROJECTS WHERE project_id = :project_id; return (l_project_name); EXCEPTION WHEN NO_DATA_FOUND THEN return null; WHEN OTHERS THEN return null; end;@@eG0808E.//function CF_Project_NameFormula return Char is l_project_name pa_projects.name%type; BEGIN SELECT NAME INTO l_project_name FROM PA_PROJECTS WHERE project_id = :project_id; return (l_project_name); EXCEPTION WHEN NO_DATA_FOUND THEN return null; WHEN OTHERS THEN return null; end;0800/08080function bp_end_of_report1FormatTrigger return boolean is begin if :CS_RECORD_COUNT <=0 then return(FALSE); end if; return (TRUE); end;08001 . 0808 2function F_Invoice_Amount1FormatTrigger return boolean is begin -- Automatically Generated from Report Builder. if ((:c_invoice_amount IS NULL) or (:c_invoice_amount = '0')) then return (FALSE); end if; return (TRUE); end;,08003 <*>FFN(R VZ`(jnt(~(((SQL*ReportWriterxxREPORTOrafaqEng APPSxi 97ere APPSxj%3xxx ss*00x" $ &(ac)darkcyanit(00x " $&y *gray80333333(00x " $&Ne+gray76=p=p=p(00x " $&is,gray72GGG(00x " $&la-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@h)00x " $&'**0r50g25b0@)00x " $&'1r75g25b0@x)00x " $&'2r88g25b0@k+00x $ &()3 r100g25b0@*00x" $ &(x4r0g25b50@x ,00x $ & (*5 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (* 8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(:r0g25b750@,00x $ & (*; r25g25b75@@,00x $ & (*< r50g25b75@,00x $ & (*ce= r75g25b75@,00x $ & (*ll> r88g25b75@,00x $ & (*oj? r100g25b75@*00x" $ &(@r0g25b885@x,00x $ & (*A r25g25b88@@,00x $ & (*B r50g25b88@,00x $ & (*xC r75g25b88@r,00x $ & (*SD r88g25b88@,00x $ & (*ESE r100g25b88@*00x# $ &(HF r0g25b100@e',00x $ & (* G r25g25b100@@,00x $ & (*FaH r50g25b100@,00x $ & (*0@I r75g25b100@,00x $ & (*J r88g25b100@.00x & ( *,ntK r100g25b100@e$00x  !"CILred(00x "$%&amMdarkred$00x "p@Nblue(00x"# $&.aOdarkblue(00x " $&Pgray64\(\(\((00x " $&inQgray60ffffff(00x " $&gRgray56ppp(00x " $&ddSgray52zzz'00x! "$%_3Tr0g50b0)00x " $&'dUr25g50b0@typ)00x " $&'odVr50g50b0E )00x " $&'OWr75g50b0c_o)00x " $&'mXr88g50b02+00x $ &()QY r100g50b0y*00x" $ &(umZr0g50b50,00x $ & (*D[ r25g50b50@,00x $ & (*EC\ r50g50b50,00x $ & (*T] r75g50b50,00x $ & (*DA^ r88g50b50,00x $ & (*\_ r100g50b50*00x" $ &(AM`r0g50b750,00x $ & (*a r25g50b75@,00x $ & (*e_b r50g50b75,00x $ & (*Cc r75g50b75,00x $ & (*<d r88g50b75,00x $ & (*e r100g50b75*00x" $ &(_dfr0g50b885is,00x $ & (*ENg r25g50b88@,00x $ & (*Ah r50g50b88,00x $ & (*p'i r75g50b88,00x $ & (*ttj r88g50b88,00x $ & (*pGk r100g50b88*00x# $ &(xl r0g50b100_d,00x $ & (*m r25g50b100@,00x $ & (*TAn r50g50b100,00x $ & (*co r75g50b100,00x $ & (*dep r88g50b100.00x & ( *,ADq r100g50b100DE'00x "$%D_ryellow +00x $ &() s darkyellow;*00x "$ &(tmagenta8.00x &( *,oiu darkmagentar (00x " $& -vgray48(00x " $&dewgray44\\\(00x " $& xgray40(00x " $&etygray36ףף'00x! "$%ndzr0g75b0)00x " $&'{r25g75b0@`(j)00x " $&'Re|r50g75b0ORT)00x " $&'xi}r75g75b0Sxj)00x " $&'~r88g75b0(ac+00x $ &() r100g75b0 .08x& ( *,000r0g75b50ay008x ( * ,.  00r25g75b50@008x ( * ,.la 00r50g75b50008x ( * ,.g2 00r75g75b50008x ( * ,.@ 00r88g75b50008x ( * ,. 00r100g75b50.08x& ( *,00r0g75b750008x ( * ,. 00r25g75b75@008x ( * ,.0 00r50g75b75008x ( * ,. 00r75g75b75008x ( * ,. $ 00r88g75b75008x ( * ,. ( 00r100g75b75.08x& ( *, 00r0g75b885008x ( * ,.  00r25g75b88@008x ( * ,.g2 00r50g75b88008x ( * ,.b7 00r75g75b88008x ( * ,. 00r88g75b88008x ( * ,. 00r100g75b88.08x' ( *, 00r0g75b100oj008x ( * ,. 00r25g75b100@008x ( * ,.0 00r50g75b100008x ( * ,. 00r75g75b100008x ( * ,. $ 00r88g75b100@pr208x * , .0 00r100g75b100p.08x & ( *,p00custom1CF.08x & ( *,00custom2.08x & ( *,FM00custom3~.08x & ( *,000custom4p,08x $ & (*00gray32,08x $ & (* 00gray28QQQ,08x $ & (*00gray24,08x $ & (*000gray20+08x% &()00r0g88b0s-08x & (*+ 00r25g88b0@mt-08x & (*+_L00r50g88b0-08x & (*+p00r75g88b0p-08x & (*+p00r88g88b0CF/08x ( *,- 00r100g88b0t.08x& ( *,00r0g88b50008x ( * ,.p 00r25g88b50@008x ( * ,.p 00r50g88b50008x ( * ,. 00r75g88b50008x ( * ,. 00r88g88b50008x ( * ,.0 00r100g88b50.08x& ( *,00r0g88b750r008x ( * ,. 00r25g88b75@008x ( * ,.w 00r50g88b75008x ( * ,.p 00r75g88b75008x ( * ,.  00r88g88b75008x ( * ,.E 00r100g88b75.08x& ( *,000r0g88b8850008x ( * ,.p_ 00r25g88b88@008x ( * ,.> 00r50g88b88008x ( * ,. 00r75g88b88008x ( * ,.0 00r88g88b88008x ( * ,.ur 00r100g88b88.08x' ( *,  00r0g88b100008x ( * ,.* 00r25g88b100@008x ( * ,. 00r50g88b100008x ( * ,.re 00r75g88b100008x ( * ,. 00r88g88b100208x * , .00 00r100g88b100b1.08x & ( *, $00custom5.08x & ( *, (00custom6.08x & ( *,AD00custom7DE.08x & ( *,D_00custom8,08x $ & (*rk00gray16 ,08x $ & (*ge00gray12GGG,08x $ & (*rk00gray8,08x $ & (*00gray4-08x& (*+ay00r0g100b0/08x ( *,- 00r25g100b0@$/08x ( *,- 00r50g100b0/08x ( *,- 00r75g100b00/08x ( *,- " 00r88g100b0/08x ( *,-& 00r100g100b0j.08x' ( *, 00r0g100b50008x ( * ,.  00r25g100b50@008x ( * ,.00 00r50g100b50008x ( * ,.00 00r75g100b50008x ( * ,.00 00r88g100b50208x * , .000 00r100g100b508.08x' ( *,8g 00r0g100b758008x ( * ,.00 00r25g100b75@008x ( * ,.g7 00r50g100b75008x ( * ,.5g 00r75g100b75008x ( * ,.0g 00r88g100b75208x * , .05g 00r100g100b75.08x' ( *,b7 00r0g100b88008x ( * ,.5b 00r25g100b88@008x ( * ,.88 00r50g100b88008x ( * ,.b8 00r75g100b88008x ( * ,.b8 00r88g100b88208x * , .0b8 00r100g100b88 (008x( * ,. 00r0g100b100208x * , .0 00r25g100b100@ *208x * , .0oj 00r50g100b100208x * , .0 00r75g100b100208x * , .0 00r88g100b10000r75g75b100008x ( * ,. $ 00r88g75b100@ Hr208x * , .08x 00r100g100b100]>p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ[ ]>p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ[ ]>p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ[ h >p@p@p@0LMNOPQRSTUVW XZ[\]^_`abcdefCourier New ] >p@p@pB0BCDEFGHIJKLMNOPQRSTUVWXYZ[#o h >p@p@p@0LMNOPQRSTUVW XZ[\]^_`abcdef}Courier New b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`Arial h >p@p@p@0LMNOPQRSTUVW XZ[\]^_`abcdefzCourier New ] >p@p@pB0BCDEFGHIJKLMNOPQRSTUVWXYZ[ob >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`Arial 8b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`)Arial ] >p@p@pB0BCDEFGHIJKLMNOPQRSTUVWXYZ[ or b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_` Arial 5   g1 p"&'*./beforepform  = p* .06:;9totalnettformula 8 5 p&*+.23kbeforereportula  01 p"&'*./lafterreportu  E p6:;>BCb_c_withheld_amountformattrigg ecI p6 :BCm_remittance_advice_reportformc 00I p6 :BCcf_withheld_amount_fmtformula#c$ 00= p* .06:;cf_balance_fmtformula%#&E p2 68>BCcf_lessdiscount_fmtformula'c(( *A p. 24:>?cf_totalnett_fmtformulala)*00b9 p& *,267cf_project_number+a),A p. 24:>? ,cf_project_nameformulaa- +.* ,I p6 :t hBpCYZ(^pbpb8b8d@f8jlmno0p0q0r0s0t0uv0w0xyz{|}~M_Column_Header_GRPFRFR >r hz BpD Z\(bpfpf8f8h@j8npqrs0t0u0v0w0x0yz0{0|}~M_Summary_Calc_Fields#! rt( BpD Z\(bpfpf0f@j@n8rtuvw0x0y0z0{0|0}~00M_No_Data_Found_GRPFR#- rJ BpD^_(bpfpf8f@j@n8rtuvw0x0y0z0{0|0}~00M_Column_Header_NDF_GRPFR0 | h BpD XZ(^pbpb@b8f8h8jlmno0p0q0r0s0t0uv0w0xyz{|}~M_AccountNumber_FR_#LFR Vm BpD VX(^pbpb@b8f8h8jlmno0p0q0r0s0t0uv0w0xyz{|}~M_Payment_Date_FR#OLFR V' BpD[\(bpfpf0f@j@n8rtuvw0x0y0z0{0|0}~00M_No_Input_Parameters1T 0Vt_ BpD RT(Zp^p^8^8`@b8fh jlm0n0o0p0q0r0st0u0vwxyz{|}~R_Dummy_GRPRFoters1 JrV BpD \^(bpfpf8f8h@j8npqrs0t0u0v0w0x0yz0{0|}~ ]R_Detail_Section_GRPRF1 oeJLr hDR#JpK Z\(bpfpf8f8h8j8lnopqrstuv0w0x0ypzpz0z{|}~f_Vendor_NameF eJ ^i #JpK \^(bpfpf8f8h8j8lnopqrstuv0w0x0ypzpz0z{|}~f_address_line1J ^l#JpK \^(bpfpf8f8h8j8lnopqrstuv0w0x0ypzpz0z{|}~f_address_line2J ^ov#JpK \^(bpfpf8f8h8j8lnopqrstuv0w0x0ypzpz0z{|}~f_address_line3J  ^r#JpK \^(bpfpf@f8j8l8npqrstuvwx0y0z0{p|p~0~F_Org_TelephoneJ 4&DuP_#JpK \^(bpfpf@f8j8l8npqrstuvwx0y0z0{p|p~0~F_Org_FaxNumber J 4,Dxp#JpK df(jpnpn@n8r8t8vxyz{|}~000pp0F_Organization_Unit_Name 4 4Dp{#JpK ^`(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0F__Org_Addr_line_1 me 4DT#JpK ^`(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0F__Org_Addr_line_2 me 4Dx * , .0 00r88g100b10000r75g75b100008x ( * ,. $ 00r88g75b100@ r#JpK ^`(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0F__Org_Addr_line_3 me 4 D# JpL \^(bpfpf@f8j8l8npqrstuvwx0y0z0{p|p0f_Checkrun_Date* m0t,~DD-MON-RRbp# JpL XZ(^pbpb@b@f8j8lnopqr tvwx0y0z0{p|p~0~f_TotalNett)$0>:8 D0# JpL \^(bpfpf@f8j8l8npqrst vxyz0{0|0}p~p~0~f_Lessdiscount)#00>z:7 # JpL VX(^pbpb@b8f8h8jlmnop rtuv0w0x0ypzpz0z{|}~f_Balance)"t)0>r:4 # JpL \^(bpfpf@f@j8n8prstuvwxyz0{0|0}p~p~0~f_Total_Pages1=00 D0# JpL \^(bpfpf@f@j8n8prstuvwxyz0{0|0}p~p~0~f_Current_Page1;00 p\# JpL ^`(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0f_account_number1M00 .{# JpL `b(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0F_Payment_Run_Date1P0 .~DD-MON-YYYY HH24:MI# JpL \^(bpfpf@f@j8n8prstuvwxyz0{0|0}p~p~0~ f_Total_Pages2ac D# JpL \^(bpfpf@f@j8n8prstuvwxyz0{0|0}p~p~0~ f_Current_Page2a # JpL ^`(fpjpj8j8l8n8prstuv xz{|0}0~0pp0 Sf_Project_Number1n0lL # JpL \^(bpfpf@f8j8l8npqrst vxyz0{0|0}p~p~0~ Tf_Project_Name1mn0L& +U# JpL XZ(^pbpb@b8f8h8jlmnopqrst0u0v0wpxpz0z{|}~ UF_c_amount1l0BL6 # JpL `b(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0 VF_CIS_Tax_Withheld1kB0L6 '# JpL ^`(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0 WF_Invoice_Amount1jkB0L6 # JpL ^`(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0 YF_c_invoice_date1ikB0LDDD-MON-RR@j# JpL ^`(fpjpj8j8l8n8prstuvwxyz0{0|0}p~p~0~ Zf_Your_Reference1hkB0NLn# JpL ^`(fpjpj8j8l8n8prstuvwxyz0{0|0}p~p~0~ [f_Our_Reference1gkB00Lp# JpL `b(fpjpj8j8l8n8prstuvwxyz0{0|0}p~p~0~ \f_Transaction_type1fB0L(r&./ 0(26p7stpupuuvwpxpzz{|p}p}}~}((:c_invoice_amount IS NULL) or (:c_invoice_amount = '0')) 0d& .01(26p7HIpJpJJKLpMp^^_`papaab"c_invoice_amount c_invoice_amountd& .01(26p7HIpJpJJKLpMp^^_`papaab Wc_invoice_amount c_invoice_amountJ 4&DuP_#JpK \^(bpfpf@f8j8l8npqrstuvwx0y0z0{p|p~0~F_Org_FaxNumber J 4,Dxp#JpK df(jpnpn@n8r8t8vxyz{|}~000pp0F_Organization_Unit_Name 4 4Dp{#JpK ^`(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0F__Org_Addr_line_1 me 4DT#JpK ^`(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0F__Org_Addr_line_2 me 4Dx * , .0 00r88g100b10000r75g75b100008x ( * ,. $ 00r88g75b100@l/**************************************************************************************************************************************************************************************************************************************************/ * * *Report name : RAP_01 Remittance Advice * *Purpose : This is the remittance advice template for electronic payments made to suppliers and will be sent to suppliers in either hard copy or electronically to notify them of the payments being * * made to them. The report should identify the transaction type for each transaction, for example invoice, credit note. The report also needs to identify any CIS tax deductions being made * * against the payments. * * Input Parameters : Payment Batch * * Payment Number * *Modification History: * * * * Date Author Version * --------------------- ----------- --------------------------------- * * 27-Dec-2005 Safeeq 1.00 Initial Version * * * * * * $Author$ * * $Date$ * * $Revision$ * ****************************************************************************************/0pp0F__Org_Addr_line_2 me 4D#JKp^ `f(jpjpj@n8p8r8tuvwxyz{|}0~00pp0F__Org_Addr_line_3 me 4 Drwlo dr]0808[EE Oracle HTML Navigator
0p0pL bp_Page2`bDDD* Zp\pq(rpvpv8v@z@~8x000000p0 bp_hardcoded_text_2_0TldTDp* Zp\ `b(fpjpj8j@n@r0vwxyxz000000p0 B_4#dcod0txT                        pL  t  0~   f_     R  VpL  t  0~  f_    dz  fz/  hzpx  jz  jzS   kzmo  kz  mzI  mzpa  oz_a  pzmo  qz(2  qz^_`papaab Wc_invoice_amount c_invoice_amountJ 4&DuP_#JpK \^(bpfpf@f8j8l8npqrstuvwx0y0z0{p|p~0~F_Org_FaxNumber J 4,Dxp#JpK df(jpnpn@n8r8t8vxyz{|}~000pp0F_Organization_Unit_Name 4 4Dp{#JpK ^`(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0F__Org_Addr_line_1 me 4DT#JpK ^`(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0F__Org_Addr_line_2 me 4Dx * , .0 00r88g100b10000r75g75b100008x ( * ,. $ 00r88g75b100@0!l1 $" TOTALNETTFORMULAfunction TotalNettFormula return Number is l_totalnett number(20); begin l_totalnett := :CS_BALANCE - :CS_LESSDISCOUNT; return l_totalnett; exception when no_data_found then return 0; when others then return 0; end;Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 . ("PKG INIT"TOTALNETTFORMULA"L_TOTALNETT""%()*,     h$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ080000HAAA AAn"FUNCTION"TOTALNETTFORMULA"RETURN"NUMBER"L_TOTALNETT"20"CS_BALANCE""-"CS_LESSDISCOUNT"NO_DATA_FOUND"0"OTHERS""P #$(359:AIMPSVX\`eijqx|h,cQQ .|e eQ SeQO  "       *     / -+ .,   " $&#(& - .   #!%')+,(d ,+ͫͫͫͫͫͫͫ0D ii h d B E%7,.%k%k.%kkhg!H0TOTALNETTFORMULA%\tx$< @X,7=P \ {<=<P\`@@ * * Date Author Version * --------------------- ----------- --------------------------------- * * 27-Dec-2005 Safeeq 1.00 Initial Version * * * * * * $Author$ * * $Date$ * * $Revision$ * ****************************************************************************************/iwindow  HyperlinksWWboxMatrixCellbox rwbwmfwindow vgmitx_helpstringvgmirt_helpstringvgmigr_helpstringrwlo@\rO0000M;;This Place Holder column is used for the lexical parameter._N0000L::This Formula column is to format the Invoice Amount field. 080008081  $  BEFOREPFORM~function BeforePForm return boolean is begin fnd_client_info.set_org_context('171'); --102,108 null; return (TRUE); end;@@c0000~~function BeforePForm return boolean is begin fnd_client_info.set_org_context('171'); --102,108 null; return (TRUE); end;ab0800 00808function TotalNettFormula return Number is l_totalnett number(20); begin l_totalnett := :CS_BALANCE - :CS_LESSDISCOUNT; return l_totalnett; exception when no_data_found then return 0; when others then return 0; end;= prec; :c_base_min_acct_unit := min_au; :c_base_description := descr;*/ RETURN (TRUE); RETURN NULL; EXCEPTION WHEN OTHERS THEN RETURN (FALSE); END;0800!>0808<"&&function CF_Invoice_Amount_FMTFormula return Char is begin /*SRW.REFERENCE(:C_INVOICE_AMOUNT); SRW.USER_EXIT('FND FORMAT_CURRENCY CODE=":C_BASE_CURRENCY_CODE" DISPLAY_WIDTH="17" AMOUNT=":C_INVOICE_AMOUNT" DISPLAY=":CF_Invoice_Amount_FMT" MINIMUM_PRECISION=":P_MIN_PRECISION" '); */ RETURN(:CF_Invoice_Amount_FMT); EXCEPTION WHEN OTHERS THEN RETURN NULL; end; on0800#;0 0p0pL bp_Page2`bDDD* Zp\pq(rpvpv8v@z@~8x000000p0 bp_hardcoded_text_2_0TldTDp* Zp\ `b(fpjpj8j@n@r0vwxyxz000000p0 B_4#dcod0txT                        pL  t  0~   f_     R  VpL  t  0~  f_    dz  fz/  hzpx  jz  jzS   kzmo  kz  mzI  mzpa  oz_a  pzmo  qz(2  qz^_`papaab Wc_invoice_amount c_invoice_amountJ 4&DuP_#JpK \^(bpfpf@f8j8l8npqrstuvwx0y0z0{p|p~0~F_Org_FaxNumber J 4,Dxp#JpK df(jpnpn@n8r8t8vxyz{|}~000pp0F_Organization_Unit_Name 4 4Dp{#JpK ^`(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0F__Org_Addr_line_1 me 4DT#JpK ^`(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0F__Org_Addr_line_2 me 4Dx * , .0 00r88g100b10000r75g75b100008x ( * ,. $ 00r88g75b100@Pr0808 1  $" BEFOREREPORTBfunction BeforeReport return boolean is begin DECLARE init_failure EXCEPTION; begin --srw.user_exit('FND SRWINIT'); -- Payment Processing Enhancements IF (:P_CHECKRUN_NAME IS NOT NULL) THEN :LP_PAYMENT_BATCH :='AND Ac.checkrun_name = ''' || :P_CHECKRUN_NAME ||''''; END IF; IF (:P_CHECK_ID IS NOT NULL) THEN -- :LP_PAYMENT_BATCH := :LP_PAYMENT_BATCH ||' AND ch.check_id = ' || :P_CHECK_ID; :LP_PAYMENT_BATCH :=:LP_PAYMENT_BATCH || 'AND Ac.check_id = ''' || :P_CHECK_ID ||''''; END IF; /* Get code, precision, min.accountable unit,and descr. for base currency */ IF (get_base_curr_data != TRUE) THEN -- Call report level PL/SQL function RAISE init_failure; END IF; return (TRUE); EXCEPTION WHEN OTHERS THEN RAISE SRW.PROGRAM_ABORT; RETURN (TRUE); end; END; " @@Z0808X BBfunction BeforeReport return boolean is begin DECLARE init_failure EXCEPTION; begin --srw.user_exit('FND SRWINIT'); -- Payment Processing Enhancements IF (:P_CHECKRUN_NAME IS NOT NULL) THEN :LP_PAYMENT_BATCH :='AND Ac.checkrun_name = ''' || :P_CHECKRUN_NAME ||''''; END IF; IF (:P_CHECK_ID IS NOT NULL) THEN -- :LP_PAYMENT_BATCH := :LP_PAYMENT_BATCH ||' AND ch.check_id = ' || :P_CHECK_ID; :LP_PAYMENT_BATCH :=:LP_PAYMENT_BATCH || 'AND Ac.check_id = ''' || :P_CHECK_ID ||''''; END IF; /* Get code, precision, min.accountable unit,and descr. for base currency */ IF (get_base_curr_data != TRUE) THEN -- Call report level PL/SQL function RAISE init_failure; END IF; return (TRUE); EXCEPTION WHEN OTHERS THEN RAISE SRW.PROGRAM_ABORT; RETURN (TRUE); end; END;pphg_detail_sectiong^paste_\\p3(h rwzmin_\p4(h rwzmot_\(h rwitd_\(h rwipn_\\(h rwlmg]f_\Y(h help_tuX0808VV@@s[9\\\ \ \q)(h rwlpl]_fg\q(h rwlpc]_fg\q*(h rwlpg]_fg\q8(h rwlpf]_fg\(h rwldr]f_\(h rwlpr]f_\(h rwlcm]f_\(h rwlud_\(h rwldd_\\(h rwspar_tu`8r0808 1 $  AFTERREPORTdfunction AfterReport return boolean is begin SRW.USER_EXIT('FND SRWEXIT'); return (TRUE); end;Rͫͫͫͫͫͫͫw SYSSTANDARD SRW $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"AFTERREPORT""n.$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08  o , AAeE"FUNCTION"AFTERREPORT"RETURN"BOOLEAN"SRW"USER_EXIT"FND SRWEXIT"TRUE"" #$(357<?CGHMQTXZ^`cfnh,WkneZOQc          dͫͫͫͫͫͫͫ0D //   &'%% hg!lD0 AFTERREPORT FND SRWEXIT )X h@@xxx0000v ddfunction AfterReport return boolean is begin SRW.USER_EXIT('FND SRWEXIT'); return (TRUE); end;g^paste_\\p3(h rwzmin_\p4(h rwzmot_\(h rwitd_\(h rwipn_\\(h rwlmg]f_\Y(h help_tuX0808VV@@s[9\\\ \ \q)(h rwlpl]_fg\q(h rwlpc]_fg\q*(h rwlpg]_fg\q8(h rwlpf]_fg\(h rwldr]f_\(h rwlpr]f_\(h rwlcm]f_\(h rwlud_\(h rwldd_\\(h rwspar_tupTrb0808` JJ1 $ JB_C_WITHHELD_AMOUNTFORMATTRIGGfunction B_c_withheld_amountFormatTrigg return boolean is begin /* if ((:c_withheld_amount = 0) or (:c_withheld_amount IS NULL)) then return (FALSE); end if;*/ null; return (TRUE); end;%Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08*"PKG INIT"B_C_WITHHELD_AMOUNTFORMATTRIGG""n$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08L >"FUNCTION"B_C_WITHHELD_AMOUNTFORMATTRIGG"RETURN"BOOLEAN"TRUE""6 #$(3579=@DFJh,OeZO  0     dͫͫͫͫͫͫͫ0D   % hg!pX0B_C_WITHHELD_AMOUNTFORMATTRIGG   l@@ $0808function B_c_withheld_amountFormatTrigg return boolean is begin /* if ((:c_withheld_amount = 0) or (:c_withheld_amount IS NULL)) then return (FALSE); end if;*/ null; return (TRUE); end;)pp "$%&'VG_COLORGREEN Np)pp "$%&'VG_COLORBLUE hxn)x'p (Transaction !x(TypeR_S#x!SE( Our 6&x$\ (Reference$x"( Your &x$ (Reference"x ( Date(%x# ( Amount%x# (CIS Tax %x# (Withheld"x ( Nett@& x$ Project ! xName\0 x.\A Carillion company% x#q  Project # x! Number xRof! x]VPageY xW(=Your bank account will be credited with the above amount by _' x% Total Nett* x( Less Discount$ x"Balance! xh dPage_ xfof6 x4h***** No Data Found *****% x#j Project # x!jNumber% x#k Project ! xkName% x#m CIS Tax % x#m Withheld% x#o  Amount# x!p Date$ x"q Your & x$q Reference# x!r Our & x$r Reference6 x4***** End of Report *****8 x6Carillion Remittance Advice0 x.A Carillion company% x# Project # x!Number% x# Project ! xName" x  Nett% x# CIS Tax l1 $" LM_REMITTANCE_ADVICE_REPORTFORMfunction M_Remittance_Advice_ReportForm return boolean is begin if :CS_Record_Count <0 then return (FALSE); elsif :P_CHECK_EXISTS=0 THEN return(FALSE); end if; return (TRUE); end;Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08*"PKG INIT"M_REMITTANCE_ADVICE_REPORTFORM""nr$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08,,,,L %A A p"FUNCTION"M_REMITTANCE_ADVICE_REPORTFORM"RETURN"BOOLEAN"CS_RECORD_COUNT""<"0"FALSE"ELSIF"P_CHECK_EXISTS"="TRUE"" #$(357:>CGHORTX[_chlmtwy}h,<.|QeZ.|QeZeZO  0     % $  * ( &   +  )'  ! " (  ) # &'"d'&ͫͫͫͫͫͫͫ0D ss Z t .!%C- .  %% hg!X0M_REMITTANCE_ADVICE_REPORTFORM%\tx$< @X*;Wbm lp @@entprocnameeventargnamefgcolorcompressbuttonspropertiesdataismappedmaprequestisdragsourcenumrowscellsvalueishorizselectedenableeanblesrctltgttl 0800~0@0800 P0800` 0800p$0800"%  0800cELD_AMOUNTFORMATTRIGG"RETURN"BOOLEAN"TRUE""6 #$(3579=@DFJh,OeZO  0     dͫͫͫͫͫͫͫ0D   % hg!pX0B_C_WITHHELD_AMOUNTFORMATTRIGG   l@@0808function B_c_withheld_amountFormatTrigg return boolean is begin /* if ((:c_withheld_amount = 0) or (:c_withheld_amount IS NULL)) then return (FALSE); end if;*/ null; return (TRUE); end;*>FFZ^(b flv(z(((( aSQL*ReportWriterxxREPORTXXCAAPRA_witoutFMTxxx isAPPSxi 97xxx APPSxj% bo ssKg208x* , . 0' 00r88g100b100Kg208x* , . 0' 00r100g100b100Kg pzy  qzy  qzyrwlotrb0808`JJ1 $ JBP_CIS_TAX_WITHHELD1FORMATTRIGfunction bp_CIS_Tax_Withheld1FormatTrig return boolean is begin /* if ((:c_withheld_amount = 0) or (:c_withheld_amount IS NULL)) then return (FALSE); end if;*/ null; return (TRUE); end;%Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08*"PKG INIT"BP_CIS_TAX_WITHHELD1FORMATTRIG""n$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08L >"FUNCTION"BP_CIS_TAX_WITHHELD1FORMATTRIG"RETURN"BOOLEAN"TRUE""6 #$(3579=@DFJh,OeZO  0     dͫͫͫͫͫͫͫ0D   % hg!pX0BP_CIS_TAX_WITHHELD1FORMATTRIG   l@@" 0808function bp_CIS_Tax_Withheld1FormatTrig return boolean is begin /* if ((:c_withheld_amount = 0) or (:c_withheld_amount IS NULL)) then return (FALSE); end if;*/ null; return (TRUE); end;$ &0800 L00x "$ &(r75g0b75_C*00x "$ &(r88g0b75,00x $& (* r100g0b75(00x!" $&r0g0b88*00x "$ &(xr25g0b88@nc*00x "$ &(r50g0b88*00x "$ &(r75g0b88*00x "$ &(atr88g0b88,00x $& (* r100g0b88(00x"# $& r0g0b100,00x $& (*! r25g0b100@,00x $& (*" r50g0b100,00x $& (*# r75g0b100,00x $& (*\$ r88g0b100,00x $& (*x% r100g0b100&00x  "$&gray*00x " $ &('darkgray&00x "$(cyanr*00x" $ &(ac)darkcyanit(00x " $&y *gray80333333(00x " $&Ne+gray76=p=p=p(00x " $&is,gray72GGG(00x " $&la-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@h)00x " $&'**0r50g25b0@)00x " $&'1r75g25b0@x)00x " $&'2r88g25b0@k+00x $ &()3 r100g25b0@*00x" $ &(x4r0g25b50@x ,00x $ & (*5 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (* 8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(:r0g25b750@,00x $ & (*; r25g25b75@@,00x $ & (*< r50g25b75@,00x $ & (*ce= r75g25b75@,00x $ & (*ll> r88g25b75@,00x $ & (*oj? r100g25b75@*00x" $ &(@r0g25b885@x,00x $ & (*A r25g25b88@@,00x $ & (*B r50g25b88@,00x $ & (*xC r75g25b88@ l1 $" M_NO_DATA_FOUND_GRPFRFORMATTRI5function M_No_Data_Found_GRPFRFormatTri return boolean is begin if :P_check_exists<>0 then if :CS_RECORD_COUNT>0 then return(false); elsif :p_check_exists=0 then return(TRUE); end if; elsif :P_CHECKRUN_NAME IS NULL AND :P_CHECK_ID IS NULL THEN return (FALSE); end if; return (TRUE); end; -Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08*"PKG INIT"M_NO_DATA_FOUND_GRPFRFORMATTRI""n$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08!MMMM74 A MA A  u eeA"FUNCTION"M_NO_DATA_FOUND_GRPFRFORMATTRI"RETURN"BOOLEAN"P_CHECK_EXISTS""!="0"CS_RECORD_COUNT">"FALSE"ELSIF"="TRUE"P_CHECKRUN_NAME"IS NULL"P_CHECK_ID""> #$(357:>CGHORTW[`deloqux| $'*23456h,<.|Q<.|QeZ.|QeZ.| .|eZeZOcQ    0    &&&&:   & &<% ;  H A=  I  B > $  ! J A= &$' )3 *./+,KC ?01LG @ (5 36 8 9A B C G EDF2 "*-02 7: ("#%-24=>?@"#-2.d@?=>ͫͫͫͫͫͫͫ0D   0t.00j `  .8 8! %t-.@@ %G1 $ ((%% hg! X0M_NO_DATA_FOUND_GRPFRFORMATTRI<0 8(@,H` d|2(*FWs    lp @@stringjhrwbwolwindowKIrwbwdowindow,*!rwbwfewindow*(Yrwbwetwindow)'rwbwtpwindow%#lrwbhrewindow#!rwbwtrwindow" rwbwfi1windowrwbwcmwindowrwbwdiwindow#rwbwmrwindowrwbwrgwindowrwbwcnwindow  rwbwsrwindow  rwbwgiwindow  HyperlinksWWboxMatrixCellbox rwbwmfwindow vgmitx_helpstringvgmirt_helpstringvgmigr_helpstringrwlo l1 $"aB_4FORMATTRIGGERfunction B_4FormatTrigger return boolean is begin if :p_checkrun_name is null and :P_CHECK_ID is null then return(FALSE); end if; return (TRUE); end;eAͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08"PKG INIT"B_4FORMATTRIGGER""nI$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 ****D  u eeAZ"FUNCTION"B_4FORMATTRIGGER"RETURN"BOOLEAN"P_CHECKRUN_NAME""IS NULL"P_CHECK_ID"FALSE"TRUE"" #$(357:>CHLMTY]^egknrvy}h,<.| .|eZeZOcQ "####7  ##    ( # !) ' "    # '  %$& 2  !""d"!ͫͫͫͫͫͫͫ0D JJ  |d $ %% hg!H0B_4FORMATTRIGGER \2`x.9D\` @@0800 M0808K55function M_No_Data_Found_GRPFRFormatTri return boolean is begin if :P_check_exists<>0 then if :CS_RECORD_COUNT>0 then return(false); elsif :p_check_exists=0 then return(TRUE); end if; elsif :P_CHECKRUN_NAME IS NULL AND :P_CHECK_ID IS NULL THEN return (FALSE); end if; return (TRUE); end;0800a0808function B_4FormatTrigger return boolean is begin if :p_checkrun_name is null and :P_CHECK_ID is null then return(FALSE); end if; return (TRUE); end;D0808B,,1  $",P_CHECK_EXISTSFORMULAfunction P_CHECK_EXISTSFormula return Number is l_check_exists number; begin IF (:P_CHECKRUN_NAME IS NOT NULL AND :P_CHECK_ID IS NOT NULL) THEN select count(1) into l_check_exists from ap_checks ac where ac.checkrun_name =:P_CHECKRUN_NAME AND ac.check_id = :P_CHECK_ID; ELSIF (:P_CHECKRUN_NAME IS NULL AND :P_CHECK_ID IS NULL) THEN l_check_exists:=0; END IF; IF l_check_exists <=0 then return 0; else return 1; end if; end; @@0808function P_CHECK_EXISTSFormula return Number is l_check_exists number; begin IF (:P_CHECKRUN_NAME IS NOT NULL AND :P_CHECK_ID IS NOT NULL) THEN select count(1) into l_check_exists from ap_checks ac where ac.checkrun_name =:P_CHECKRUN_NAME AND ac.check_id = :P_CHECK_ID; ELSIF (:P_CHECKRUN_NAME IS NULL AND :P_CHECK_ID IS NULL) THEN l_check_exists:=0; END IF; IF l_check_exists <=0 then return 0; else return 1; end if; end;0800 *>FFZ^(b flv(z(((( aSQL*ReportWriterxxREPORTXXCAAPRA_witoutFMTxxx isAPPSxi 97xxx APPSxj% bo ssrt_helpstringvgmigr_helpstringrwlol1 $" BP_NO_INPUT_PARAMETERS1FORMATTfunction bp_no_input_parameters1FormatT return boolean is begin if :p_checkrun_name is not null and :P_CHECK_ID is not null and :CS_RECORD_COUNT<=0 then return(FALSE); end if; return (TRUE); end;Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08*"PKG INIT"BP_NO_INPUT_PARAMETERS1FORMATT""n$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ084444\   9A eeA"FUNCTION"BP_NO_INPUT_PARAMETERS1FORMATT"RETURN"BOOLEAN"P_CHECKRUN_NAME""IS NOT NULL"P_CHECK_ID"CS_RECORD_COUNT"<="0"FALSE"TRUE"" #$(357:>CHMPQX]`ahmqry|~h,<.~ .~ .|QeZeZOcQ 0''''SSSCUW  'C'S' &  1 + (2 / )3 0 *  ! # $ + /  0 -,.2 "% ()*(d)(*ͫͫͫͫͫͫͫ0D   t  &' 0$B0` X  &' 8$K85 - (.@(@%% hg!X0BP_NO_INPUT_PARAMETERS1FORMATT308@ H2 (lp @@88d@0 88>@ 88ͫͫP 88 88 88 88 88 880j` 888 8 88tP 88@  881 $ ((%% hg! X0M_NO_DATA_FOUND_GRPFRFORMATTRI<0 8(@,H` d|2(*FWs    lp @@stringjhrwbwolwindowKIrwbwdowindow,*!rwbwfewindow*(Yrwbwetwindow)'rwbwtpwindow%#lrwbhrewindow#!rwbwtrwindow" rwbwfi1windowrwbwcmwindowrwbwdiwindow#rwbwmrwindowrwbwrgwindowrwbwcnwindow  rwbwsrwindow  rwbwgiwindow  HyperlinksWWboxMatrixCellbox rwbwmfwindow vgmitx_helpstringvgmirt_helpstringvgmigr_helpstringrwlor0808function M_Remittance_Advice_ReportForm return boolean is begin if :CS_Record_Count <0 then return (FALSE); elsif :P_CHECK_EXISTS=0 THEN return(FALSE); end if; return (TRUE); end;A0800 M0808K55function M_No_Data_Found_GRPFRFormatTri return boolean is begin if :P_check_exists<>0 then if :CS_RECORD_COUNT>0 then return(false); elsif :p_check_exists=0 then return(TRUE); end if; elsif :P_CHECKRUN_NAME IS NULL AND :P_CHECK_ID IS NULL THEN return (FALSE); end if; return (TRUE); end;Q0R0800a0808function B_4FormatTrigger return boolean is begin if :p_checkrun_name is null and :P_CHECK_ID is null then return(FALSE); end if; return (TRUE); end;ypD0808B,,1  $",P_CHECK_EXISTSFORMULAfunction P_CHECK_EXISTSFormula return Number is l_check_exists number; begin IF (:P_CHECKRUN_NAME IS NOT NULL AND :P_CHECK_ID IS NOT NULL) THEN select count(1) into l_check_exists from ap_checks ac where ac.checkrun_name =:P_CHECKRUN_NAME AND ac.check_id = :P_CHECK_ID; ELSIF (:P_CHECKRUN_NAME IS NULL AND :P_CHECK_ID IS NULL) THEN l_check_exists:=0; END IF; IF l_check_exists <=0 then return 0; else return 1; end if; end; @@ODE ( aid.line_type_lookup_code , 'AWT' , aid.amount * - 1 , 0 ) )C_WITHHELD_AMOUNT&gF pp(p2;<=0>0?@ABCDc_amountip.amountC_AMOUNTg8^ pp0pBSTU0V0WXYZ[\c_discount_takenip.discount_takenC_DISCOUNT_TAKENgC p p(p089:0;0<=>?@A'Dummy''Dummy''DUMMY'g` FpGXYZ[ \^0_`a0bcd0efghixj8j@n8r8t vxpypyppphg_detail_sectiong^paste_\\p3(h rwzmin_\p4(h rwzmot_\(h rwitd_\(h rwipn_\\(h rwlmg]f_\Y(h help_tuX0808VV@@s[9\\\ \ \q)(h rwlpl]_fg\q(h rwlpc]_fg\q*(h rwlpg]_fg\q8(h rwlpf]_fg\(h rwldr]f_\(h rwlpr]f_\(h rwlcm]f_\(h rwlud_\(h rwldd_\\(h rwspar_tul1 $" M_NO_INPUT_PARAMETERS1FORMATTRfunction M_No_Input_Parameters1FormatTr return boolean is begin if NOT(:P_CHECKRUN_NAME IS NULL AND :P_CHECK_ID IS NULL) THEN return(FALSE); END IF; return (TRUE); end;Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08*"PKG INIT"M_NO_INPUT_PARAMETERS1FORMATTR""nO$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 ////P   u eeAl"FUNCTION"M_NO_INPUT_PARAMETERS1FORMATTR"RETURN"BOOLEAN"P_CHECKRUN_NAME""IS NULL"P_CHECK_ID"NOT"FALSE"TRUE""& #$(357:>CGHKPUYZafjkrtx{h,<.|Z.| .|eZeZOcQ 0 ''''<   ' '$ #  .  , ' %- + &   ! ' + )(*2 " %&"d&%ͫͫͫͫͫͫͫ0D PP  |t  %% hg!X0M_NO_INPUT_PARAMETERS1FORMATTR \2`x4?Jlp @@  MS Sans Serif generate_to_web checkbox  MS Sans Serif( N8808L66RESFILE___st p88headerfield 88ameternt 889FieldsboxDatabox TypeboxSectionsboxTemplatesboxFinishedQueryboxrwwt_Expresswizardvgmisq_helpstringrwbwvpulmenurwlfs_helpstring|zrwlbstringqorwdqe_helpstringjhrwbwolwindowKIrwbwdowindow,*!rwbwfewindow*(Yrwbwetwindow)'rwbwtpwindow%#lrwbhrewindow#!rwbwtrwindow" rwbwfi1windowrwbwcmwindowrwbwdiwindow#rwbwmrwindowrwbwrgwindowrwbwcnwindow  rwbwsrwindow  rwbwgiwindow  HyperlinksWWboxMatrixCellbox rwbwmfwindow vgmitx_helpstringvgmirt_helpstringvgmigr_helpstringrwlol1 $"CF_AMOUNTFORMULAfunction CF_amountFormula return Character is begin /* SRW.REFERENCE(:C_AMOUNT); SRW.USER_EXIT('FND FORMAT_CURRENCY CODE=":C_BASE_CURRENCY_CODE" DISPLAY_WIDTH="17" AMOUNT=":C_AMOUNT" DISPLAY=":CF_AMOUNT_FMT" MINIMUM_PRECISION=":P_MIN_PRECISION" '); */ RETURN(:CF_AMOUNT_FMT); /*EXCEPTION WHEN OTHERS THEN RETURN NULL;*/ end;Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08!"PKG INIT"CF_AMOUNTFORMULA""v%$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08feeA<"FUNCTION"CF_AMOUNTFORMULA"RETURN"CHARACTER"CF_AMOUNT_FMT""" #$(357;>EGKMT\`ch,eZOcQ   "    dͫͫͫͫͫͫͫ0D &&  8\$ hg!tH0CF_AMOUNTFORMULA`4  @@cspringscspringcnticonfileautoskipcanreordercontentwdcontenthtenablednitemsidhiddentearoffhelpsubmenuacceleratorstandardkeykeyvalmodifierscsstatestartgroupiconcantitlevtatypehtatypestatustypestatusclassstatushtaclasshtavtaclassvtamenuiconsizeshowlabelscanvasmovablewdhtviewclasscasefoldsplitmodestringpageresourcecurrentcanapplyeventprocnameeventargnamefgcolorcompressbuttonspropertiesdataismappedmaprequestisdragsourcenumrowscellsvalueishorizselectedenableeanblesrctltgttl); 0800~0@0800 P0800` 0800p$0800"%  0800c DISPLAY=":CF_AMOUNT_FMT" MINIMUM_PRECISION=":P_MIN_PRECISION" '); */ RETURN(:CF_AMOUNT_FMT); /*EXCEPTION WHEN OTHERS THEN RETURN NULL;*/ end;*>FFZ^(b flv(z(((( aSQL*ReportWriterxxREPORTXXCAAPRA_witoutFMTxxx isAPPSxi 97xxx APPSxj% bo ssTS_ALL WHERE PROJECT_ID = :b1"@@`  d $%bac&2'(357:?k)=*"iACE  M[="'.169<CHJNWRSUY^_.169ljCHRS*d_^ ͫͫͫͫͫͫͫ0D Tj   &' 0$B0j b  &' 8$K8? 7q{t @w@(@ @ t@(+      .(.H(H!.%.% hg!`28@TdP_CHECK_EXISTSFORMULA r0808function P_CHECK_EXISTSFormula return Number is l_check_exists number; begin IF (:P_CHECKRUN_NAME IS NOT NULL AND :P_CHECK_ID IS NOT NULL) THEN select count(1) into l_check_exists from ap_checks ac where ac.checkrun_name =:P_CHECKRUN_NAME AND ac.check_id = :P_CHECK_ID; ELSIF (:P_CHECKRUN_NAME IS NULL AND :P_CHECK_ID IS NULL) THEN l_check_exists:=0; END IF; IF l_check_exists <=0 then return 0; else return 1; end if; end; e0800 0808function bp_no_input_parameters1FormatT return boolean is begin if :p_checkrun_name is not null and :P_CHECK_ID is not null and :CS_RECORD_COUNT<=0 then return(FALSE); end if; return (TRUE); end;0800 0808function M_No_Input_Parameters1FormatTr return boolean is begin if NOT(:P_CHECKRUN_NAME IS NULL AND :P_CHECK_ID IS NULL) THEN return(FALSE); END IF; return (TRUE); end;08000808function CF_amountFormula return Character is begin /* SRW.REFERENCE(:C_AMOUNT); SRW.USER_EXIT('FND FORMAT_CURRENCY CODE=":C_BASE_CURRENCY_CODE" DISPLAY_WIDTH="17" AMOUNT=":C_AMOUNT" DISPLAY=":CF_AMOUNT_FMT" MINIMUM_PRECISION=":P_MIN_PRECISION" '); */ RETURN(:CF_AMOUNT_FMT); /*EXCEPTION WHEN OTHERS THEN RETURN NULL;*/ end;UNTg8^ pp0pBSTU0V0WXYZ[\c_discount_takenip.discount_takenC_DISCOUNT_TAKENgC p p(p089:0;0<=>?@A'Dummy''Dummy''DUMMY'g` FpGXYZ[ \^0_`a0bcd0efghixj8j@n8r8t vxpypyppphg_detail_sectiong^paste_\\p3(h rwzmin_\p4(h rwzmot_\(h rwitd_\(h rwipn_\\(h rwlmg]f_\Y(h help_tuX0808VV@@s[9\\\ \ \q)(h rwlpl]_fg\q(h rwlpc]_fg\q*(h rwlpg]_fg\q8(h rwlpf]_fg\(h rwldr]f_\(h rwlpr]f_\(h rwlcm]f_\(h rwlud_\(h rwldd_\\(h rwspar_tul1 $"CF_INVOICE_AMOUNT_FMTFORMULA&function CF_Invoice_Amount_FMTFormula return Char is begin /*SRW.REFERENCE(:C_INVOICE_AMOUNT); SRW.USER_EXIT('FND FORMAT_CURRENCY CODE=":C_BASE_CURRENCY_CODE" DISPLAY_WIDTH="17" AMOUNT=":C_INVOICE_AMOUNT" DISPLAY=":CF_Invoice_Amount_FMT" MINIMUM_PRECISION=":P_MIN_PRECISION" '); */ RETURN(:CF_Invoice_Amount_FMT); EXCEPTION WHEN OTHERS THEN RETURN NULL; end; IAͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08!("PKG INIT"CF_INVOICE_AMOUNT_FMTFORMULA""v>$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08seeAR"FUNCTION"CF_INVOICE_AMOUNT_FMTFORMULA"RETURN"CHAR"CF_INVOICE_AMOUNT_FMT""OTHERS"" #$(357;>EINOQUVXZaimph,eZ SeMOcQ   .         dͫͫͫͫͫͫͫ0D ??  \h$$$kkhg!T0CF_INVOICE_AMOUNT_FMTFORMULA`LX,H  & 2%&@@gerwdpc_helpstringb`rwbf_outlinerFontsPNrwbf_pf_dfltFontsHFrwbf_dfltFontsFDrwbfd_labelFontsECrwbfd_statusFontsDBrwbf_pf_nameFontsA?rwbf_formulaFonts><rwbf_columnFonts<:rwbf_queryFonts:8vgmipg_helpstringvgmiss_helpstringrwdqstringecrwlfsstring{yrwdqestringig;rwbf_parameterFonts;9FieldsboxDatabox TypeboxSectionsboxTemplatesboxFinishedQueryboxrwwt_Expresswizardvgmisq_helpstringrwbwvpulmenurwlfs_helpstring|zrwlbstringqorwdqe_helpstringjhrwbwolwindowKIrwbwdowindow,*!rwbwfewindow*(Yrwbwetwindow)'rwbwtpwindow%#lrwbhrewindow#!rwbwtrwindow" rwbwfi1windowrwbwcmwindowrwbwdiwindow#rwbwmrwindowrwbwrgwindowrwbwcnwindow  rwbwsrwindow  rwbwgiwindow  HyperlinksWWboxMatrixCellbox rwbwmfwindow vgmitx_helpstringvgmirt_helpstringvgmigr_helpstringrwlo TrP0808N881  $$8GET_BASE_CURR_DATAFUNCTION get_base_curr_data RETURN BOOLEAN IS base_curr ap_system_parameters.base_currency_code%TYPE; -- Base currency code prec fnd_currencies_vl.precision%TYPE; -- Precision of base currency min_au fnd_currencies_vl.minimum_accountable_unit%TYPE;-- Min AU of base curr descr fnd_currencies_vl.description%TYPE; -- Description of base currency BEGIN /* base_curr := ''; prec := 0; min_au := 0; descr := ''; SELECT p.base_currency_code, c.precision, c.minimum_accountable_unit, c.description INTO base_curr, prec, min_au, descr FROM ap_system_parameters p, fnd_currencies_vl c WHERE p.base_currency_code = c.currency_code; :c_base_currency_code := base_curr; :c_base_precision := prec; :c_base_min_acct_unit := min_au; :c_base_description := descr;*/ RETURN (TRUE); RETURN NULL; EXCEPTION WHEN OTHERS THEN RETURN (FALSE); END; @@/* SRW.REFERENCE(:C_AMOUNT); SRW.USER_EXIT('FND FORMAT_CURRENCY CODE=":C_BASE_CURRENCY_CODE" DISPLAY_WIDTH="17" AMOUNT=":C_AMOUNT" DISPLAY=":CF_AMOUNT_FMT" MINIMUM_PRECISION=":P_MIN_PRECISION" '); */ RETURN(:CF_AMOUNT_FMT); /*EXCEPTION WHEN OTHERS THEN RETURN NULL;*/ end;UNTg8^ pp0pBSTU0V0WXYZ[\c_discount_takenip.discount_takenC_DISCOUNT_TAKENgC p p(p089:0;0<=>?@A'Dummy''Dummy''DUMMY'g` FpGXYZ[ \^0_`a0bcd0efghixj8j@n8r8t vxpypyppphg_detail_sectiong^paste_\\p3(h rwzmin_\p4(h rwzmot_\(h rwitd_\(h rwipn_\\(h rwlmg]f_\Y(h help_tuX0808VV@@s[9\\\ \ \q)(h rwlpl]_fg\q(h rwlpc]_fg\q*(h rwlpg]_fg\q8(h rwlpf]_fg\(h rwldr]f_\(h rwlpr]f_\(h rwlcm]f_\(h rwlud_\(h rwldd_\\(h rwspar_tu0l1 $";CF_WITHHELD_AMOUNT_FMTFORMULA+function CF_Withheld_Amount_FMTFormula return Char is begin /*SRW.REFERENCE(:CS_Withheld_amount); SRW.USER_EXIT('FND FORMAT_CURRENCY CODE=":C_BASE_CURRENCY_CODE" DISPLAY_WIDTH="17" AMOUNT=":CS_Withheld_amount" DISPLAY=":CF_Withheld_Amount_FMT" MINIMUM_PRECISION=":P_MIN_PRECISION" '); */ RETURN(:CF_Withheld_Amount_FMT); /*EXCEPTION WHEN OTHERS THEN RETURN NULL;*/ end; Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08!)"PKG INIT"CF_WITHHELD_AMOUNT_FMTFORMULA""v%$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08feeAM"FUNCTION"CF_WITHHELD_AMOUNT_FMTFORMULA"RETURN"CHAR"CF_WITHHELD_AMOUNT_FMT""" #$(357;>EGKMT\`ch,eZOcQ   /      dͫͫͫͫͫͫͫ0D &&  8l$ hg!X0CF_WITHHELD_AMOUNT_FMTFORMULA`4  @@ bp_line_no_data_found#@0Z*Z \pmnr(vpvpv@z@~88x000000p0 bp_no_data_foundAnd0U::UD*Z \pt vz(~p~p~0@@0x000000p0 bp_line_no_data_found1#B0:*Z \plmn(rprpr8t8v8x8z{|x000000p0 bp_report_titleC0>U0:>U*Z \ph jn(rprpr8v@z0|8~x000000p0  bp_line_16i#DC0* ***Z \ph jn(rprpr8v@z0|8~x000000p0  bp_line_10i#EC0J JJ                                   y  y  y   y   y  Ry  Vy  y  y  y  y  dzy  fzy  hzy  jzy  jzy  kzy  kzy  mzy  mzy  ozy  pzy  qzy  qzyvgmigr_helpstringrwlo@l1 $"CF_BALANCE_FMTFORMULAfunction CF_Balance_FMTFormula return Char is begin /* SRW.REFERENCE(:CS_BALANCE); SRW.USER_EXIT('FND FORMAT_CURRENCY CODE=":C_BASE_CURRENCY_CODE" DISPLAY_WIDTH="17" AMOUNT=":CS_BALANCE" DISPLAY=":CF_Balance_FMT" MINIMUM_PRECISION=":P_MIN_PRECISION" '); */ RETURN(:CF_Balance_FMT); EXCEPTION WHEN OTHERS THEN RETURN NULL; end; 1Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08!!"PKG INIT"CF_BALANCE_FMTFORMULA""v>$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08seeAD"FUNCTION"CF_BALANCE_FMTFORMULA"RETURN"CHAR"CF_BALANCE_FMT""OTHERS"" #$(357;>EINOQUVXZaimph,eZ SeMOcQ   '         dͫͫͫͫͫͫͫ0D ??  \d$$$kkhg!P0CF_BALANCE_FMTFORMULA`LX,H  & 2%&@@*Z \ph jn(rprpr@v@z0|8~x000000p0  bp_line_17i#JC0 *Z \ph jn(rprpr@v@z0|8~x000000p0  bp_line_18i#KC0B BB*Z \popv(zpzpz@~888x000000p0 bp_Account_Number1N0B0"B"*Z \pmnr(vpvpv@z8|8~8x000000p0 bp_Payment_Date1QN00*Z \p` bf(jpjpj@n8p0r8tuvzx000000p0 B_1#Rent00                                   y  y  y   y   y  Ry  Vy  y  y  y  y  dzy  fzy  hzy  jzy  jzy  kzy  kzy  mzy  mzy  ozy  pzy  qzy  qzyvgmirt_helpstringvgmigr_helpstringrwloPr0808 FUNCTION get_base_curr_data RETURN BOOLEAN IS base_curr ap_system_parameters.base_currency_code%TYPE; -- Base currency code prec fnd_currencies_vl.precision%TYPE; -- Precision of base currency min_au fnd_currencies_vl.minimum_accountable_unit%TYPE;-- Min AU of base curr descr fnd_currencies_vl.description%TYPE; -- Description of base currency BEGIN /* base_curr := ''; prec := 0; min_au := 0; descr := ''; SELECT p.base_currency_code, c.precision, c.minimum_accountable_unit, c.description INTO base_curr, prec, min_au, descr FROM ap_system_parameters p, fnd_currencies_vl c WHERE p.base_currency_code = c.currency_code; :c_base_currency_code := base_curr; :c_base_precision := prec; :c_base_min_acct_unit := min_au; :c_base_description := descr;*/ RETURN (TRUE); RETURN NULL; EXCEPTION WHEN OTHERS THEN RETURN (FALSE); END;0800!>0808<"&&function CF_Invoice_Amount_FMTFormula return Char is begin /*SRW.REFERENCE(:C_INVOICE_AMOUNT); SRW.USER_EXIT('FND FORMAT_CURRENCY CODE=":C_BASE_CURRENCY_CODE" DISPLAY_WIDTH="17" AMOUNT=":C_INVOICE_AMOUNT" DISPLAY=":CF_Invoice_Amount_FMT" MINIMUM_PRECISION=":P_MIN_PRECISION" '); */ RETURN(:CF_Invoice_Amount_FMT); EXCEPTION WHEN OTHERS THEN RETURN NULL; end; on0800#;0 0p0pL bp_Page2`bDDD* Zp\pq(rpvpv8v@z@~8x000000p0 bp_hardcoded_text_2_0TldTDp* Zp\ `b(fpjpj8j@n@r0vwxyxz000000p0 B_4#dcod0txT                        pL  t  0~   f_     R  VpL  t  0~  f_    dz  fz/  hzpx  jz  jzS   kzmo  kz  mzI  mzpa  oz_a  pzmo  qz(2  qz^_`papaab Wc_invoice_amount c_invoice_amountJ 4&DuP_#JpK \^(bpfpf@f8j8l8npqrstuvwx0y0z0{p|p~0~F_Org_FaxNumber J 4,Dxp#JpK df(jpnpn@n8r8t8vxyz{|}~000pp0F_Organization_Unit_Name 4 4Dp{#JpK ^`(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0F__Org_Addr_line_1 me 4DT#JpK ^`(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0F__Org_Addr_line_2 me 4Dx * , .0 00r88g100b10000r75g75b100008x ( * ,. $ 00r88g75b100@`"l1 $"CF_LESSDISCOUNT_FMTFORMULAfunction CF_LessDiscount_FMTFormula return Char is begin /* SRW.REFERENCE(:CS_LESSDISCOUNT); SRW.USER_EXIT('FND FORMAT_CURRENCY CODE=":C_BASE_CURRENCY_CODE" DISPLAY_WIDTH="17" AMOUNT=":CS_LESSDISCOUNT" DISPLAY=":CF_LessDiscount_FMT" MINIMUM_PRECISION=":P_MIN_PRECISION" '); */ RETURN(:CF_LessDiscount_FMT); EXCEPTION WHEN OTHERS THEN RETURN NULL; end;AAͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08!&"PKG INIT"CF_LESSDISCOUNT_FMTFORMULA""v>$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08seeAN"FUNCTION"CF_LESSDISCOUNT_FMTFORMULA"RETURN"CHAR"CF_LESSDISCOUNT_FMT""OTHERS"" #$(357;>EINOQUVXZaimph,eZ SeMOcQ   ,         dͫͫͫͫͫͫͫ0D ??  \h$$$kkhg!T0CF_LESSDISCOUNT_FMTFORMULA`LX,H  & 2%&@@ \p` bf(jpjpj8n@r@v0wxyzx000000p0 B_4#dcod0t_txT                                   y  y  y   y   y  Ry  Vy  y  y  y  y  dzy  fzy  hzy  jzy  jzy  kzy  kzy  mzy  mzy  ozy  pzy  qzy  qzylfs_helpstring|zrwlbstringqorwdqe_helpstringjhrwbwolwindowKIrwbwdowindow,*!rwbwfewindow*(Yrwbwetwindow)'rwbwtpwindow%#lrwbhrewindow#!rwbwtrwindow" rwbwfi1windowrwbwcmwindowrwbwdiwindow#rwbwmrwindowrwbwrgwindowrwbwcnwindow  rwbwsrwindow  rwbwgiwindow  HyperlinksWWboxMatrixCellbox rwbwmfwindow vgmitx_helpstringvgmirt_helpstringvgmigr_helpstringrwlopl1 $"CF_TOTALNETT_FMTFORMULA function CF_TotalNett_FMTFormula return Char is begin /* SRW.REFERENCE(:CF_TOTALNETT); SRW.USER_EXIT('FND FORMAT_CURRENCY CODE=":C_BASE_CURRENCY_CODE" DISPLAY_WIDTH="17" AMOUNT=":CF_TOTALNETT" DISPLAY=":CF_TotalNett_FMT" MINIMUM_PRECISION=":P_MIN_PRECISION" '); */ RETURN(:CF_TotalNett_FMT); EXCEPTION WHEN OTHERS THEN RETURN NULL; end;5Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08!#"PKG INIT"CF_TOTALNETT_FMTFORMULA""v>$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08seeAH"FUNCTION"CF_TOTALNETT_FMTFORMULA"RETURN"CHAR"CF_TOTALNETT_FMT""OTHERS"" #$(357;>EINOQUVXZaimph,eZ SeMOcQ   )           dͫͫͫͫͫͫͫ0D ??  \d $$$kkhg!P0CF_TOTALNETT_FMTFORMULA`LX,H  & 2%& @@ (Reference "x ( Datec%x# ( Amount %x# (CIS Tax %x# (Withheld "x ( Nettd& x$ Project ! xNamet 0 x.A Carillion company% x#  Project n # x! Number xRof! xVPageY xW=Your bank account will be credited with the above amount by ' x% Total Nett* x(Less Discountn$ x"Balance! xdPagee xfof6 x4h***** No Data Found *****r% x#j Project at# x!jNumber% x#k Project at! xkNamet % x#m CIS Tax at% x#m Withheldat% x#o  Amountat# x!p Date$ x"q Your & x$q Referencet# x!r Our & x$r Referencet6 x4***** End of Report *****r8 x6Carillion Remittance Advice0 x.A Carillion company% x# Project n # x!Number% x# Project n ! xNamet " x  Nett % x# CIS Tax n % x# Withheldn rwlorC0808A$++function CF_Withheld_Amount_FMTFormula return Char is begin /*SRW.REFERENCE(:CS_Withheld_amount); SRW.USER_EXIT('FND FORMAT_CURRENCY CODE=":C_BASE_CURRENCY_CODE" DISPLAY_WIDTH="17" AMOUNT=":CS_Withheld_amount" DISPLAY=":CF_Withheld_Amount_FMT" MINIMUM_PRECISION=":P_MIN_PRECISION" '); */ RETURN(:CF_Withheld_Amount_FMT); /*EXCEPTION WHEN OTHERS THEN RETURN NULL;*/ end; 0800%@0808&function CF_Balance_FMTFormula return Char is begin /* SRW.REFERENCE(:CS_BALANCE); SRW.USER_EXIT('FND FORMAT_CURRENCY CODE=":C_BASE_CURRENCY_CODE" DISPLAY_WIDTH="17" AMOUNT=":CS_BALANCE" DISPLAY=":CF_Balance_FMT" MINIMUM_PRECISION=":P_MIN_PRECISION" '); */ RETURN(:CF_Balance_FMT); EXCEPTION WHEN OTHERS THEN RETURN NULL; end; 0800'`408082(function CF_LessDiscount_FMTFormula return Char is begin /* SRW.REFERENCE(:CS_LESSDISCOUNT); SRW.USER_EXIT('FND FORMAT_CURRENCY CODE=":C_BASE_CURRENCY_CODE" DISPLAY_WIDTH="17" AMOUNT=":CS_LESSDISCOUNT" DISPLAY=":CF_LessDiscount_FMT" MINIMUM_PRECISION=":P_MIN_PRECISION" '); */ RETURN(:CF_LessDiscount_FMT); EXCEPTION WHEN OTHERS THEN RETURN NULL; end;0800)pr0g0b75*00x "$ &(E)r25g0b75@; *00x "$ &(r50g0b75_C*00x "$ &(r75g0b75_C*00x "$ &(r88g0b75,00x $& (* r100g0b75(00x!" $&r0g0b88*00x "$ &(xr25g0b88@nc*00x "$ &(r50g0b88*00x "$ &(r75g0b88*00x "$ &(atr88g0b88,00x $& (* r100g0b88(00x"# $& r0g0b100,00x $& (*! r25g0b100@,00x $& (*" r50g0b100,00x $& (*# r75g0b100,00x $& (*\$ r88g0b100,00x $& (*x% r100g0b100&00x  "$&gray*00x " $ &('darkgray&00x "$(cyanr*00x" $ &(ac)darkcyanit(00x " $&y *gray80333333(00x " $&Ne+gray76=p=p=p(00x " $&is,gray72GGG(00x " $&la-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@h)00x " $&'**0r50g25b0@)00x " $&'1r75g25b0@x)00x " $&'2r88g25b0@k+00x $ &()3 r100g25b0@*00x" $ &(x4r0g25b50@x ,00x $ & (*5 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (* 8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(:r0g25b750@,00x $ & (*; r25g25b75@@,00x $ & (*< r50g25b75@,00x $ & (*ce= r75g25b75@,00x $ & (*ll> r88g25b75@,00x $ & (*oj? r100g25b75@*00x" $ &(@r0g25b885@x,00x $ & (*A r25g25b88@@,00x $ & (*B r50g25b88@,00x $ & (*xC r75g25b88@ l1 $"BP_END_OF_REPORT1FORMATTRIGGERfunction bp_end_of_report1FormatTrigger return boolean is begin if :CS_RECORD_COUNT <=0 then return(FALSE); end if; return (TRUE); end;Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08*"PKG INIT"BP_END_OF_REPORT1FORMATTRIGGER""nE$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08  0 9A Z"FUNCTION"BP_END_OF_REPORT1FORMATTRIGGER"RETURN"BOOLEAN"CS_RECORD_COUNT""<="0"FALSE"TRUE""" #$(357:>CGHORTX[_cfjlpryh,<.|QeZeZO 0               dͫͫͫͫͫͫͫ0D FF  Lt .  %% hg!X0BP_END_OF_REPORT1FORMATTRIGGER 0H,*5@lp @@*00x" $& ('r88g0b75,00x$ &( *' r100g0b75(00x!"$ &'r0g0b88*00x" $& ('r25g0b88@*00x" $& ('r50g0b88*00x" $& ('r75g0b88*00x" $& ('r88g0b88,00x$ &( *' r100g0b88(00x"#$ &' r0g0b100,00x$ &( *'! r25g0b100@,00x$ &( *'" r50g0b100,00x$ &( *'# r75g0b100,00x$ &( *'$ r88g0b100,00x$ &( *'% r100g0b100&00x " $'&gray*00x" $ & (''darkgray&00x " $'(cyanr*00x"$ & (')darkcyan(00x " $ &'*gray80333333(00x " $ &'+gray76p=p=p=(00x " $ &',gray72GGG(00x " $ &'-gray68QQQ'00x!" $%'.r0g25b0@Q)00x" $ &''/r25g25b0@@)00x" $ &''0r50g25b0@)00x" $ &''1r75g25b0@)00x" $ &''2r88g25b0@+00x$ & ()'3 r100g25b0@*00x"$ & ('4r0g25b50@,00x$ & ( *'5 r25g25b50@@,00x$ & ( *'6 r50g25b50@,00x$ & ( *'7 r75g25b50@,00x$ & ( *'8 r88g25b50@,00x$ & ( *'9 r100g25b50@*00x"$ & (':r0g25b750@,00x$ & ( *'; r25g25b75@@,00x$ & ( *'< r50g25b75@,00x$ & ( *'= r75g25b75@,00x$ & ( *'> r88g25b75@,00x$ & ( *'? r100g25b75@*00x"$ & ('@r0g25b885@,00x$ & ( *'A r25g25b88@@,00x$ & ( *'B r50g25b88@,00x$ & ( *'C r75g25b88@,00x$ & ( *'D r88g25b88@rwlo r"0808 *  function CF_TotalNett_FMTFormula return Char is begin /* SRW.REFERENCE(:CF_TOTALNETT); SRW.USER_EXIT('FND FORMAT_CURRENCY CODE=":C_BASE_CURRENCY_CODE" DISPLAY_WIDTH="17" AMOUNT=":CF_TOTALNETT" DISPLAY=":CF_TotalNett_FMT" MINIMUM_PRECISION=":P_MIN_PRECISION" '); */ RETURN(:CF_TotalNett_FMT); EXCEPTION WHEN OTHERS THEN RETURN NULL; end;TA0808+1  $"CF_PROJECT_NUMBER3function CF_Project_Number return Char is l_proj_number pa_projects.segment1%type; BEGIN SELECT segment1 INTO l_proj_number FROM pa_projects_all WHERE project_id=:project_id; RETURN(l_proj_number); Exception When NO_DATA_FOUND then return(null); When Others then return(null); end;@@K0808I,33function CF_Project_Number return Char is l_proj_number pa_projects.segment1%type; BEGIN SELECT segment1 INTO l_proj_number FROM pa_projects_all WHERE project_id=:project_id; RETURN(l_proj_number); Exception When NO_DATA_FOUND then return(null); When Others then return(null); end;0808-1  $"CF_PROJECT_NAMEFORMULA/function CF_Project_NameFormula return Char is l_project_name pa_projects.name%type; BEGIN SELECT NAME INTO l_project_name FROM PA_PROJECTS WHERE project_id = :project_id; return (l_project_name); EXCEPTION WHEN NO_DATA_FOUND THEN return null; WHEN OTHERS THEN return null; end;@@eG0808E.//function CF_Project_NameFormula return Char is l_project_name pa_projects.name%type; BEGIN SELECT NAME INTO l_project_name FROM PA_PROJECTS WHERE project_id = :project_id; return (l_project_name); EXCEPTION WHEN NO_DATA_FOUND THEN return null; WHEN OTHERS THEN return null; end;0800/08080function bp_end_of_report1FormatTrigger return boolean is begin if :CS_RECORD_COUNT <=0 then return(FALSE); end if; return (TRUE); end;08001 . 0808 2function F_Invoice_Amount1FormatTrigger return boolean is begin -- Automatically Generated from Report Builder. if ((:c_invoice_amount IS NULL) or (:c_invoice_amount = '0')) then return (FALSE); end if; return (TRUE); end;,08003 <*>FFN(R VZ`(jnt(~(((SQL*ReportWriterxxREPORTOrafaqEng APPSxi 97ere APPSxj%3xxx ss*00x" $ &(ac)darkcyanit(00x " $&y *gray80333333(00x " $&Ne+gray76=p=p=p(00x " $&is,gray72GGG(00x " $&la-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@h)00x " $&'**0r50g25b0@)00x " $&'1r75g25b0@x)00x " $&'2r88g25b0@k+00x $ &()3 r100g25b0@*00x" $ &(x4r0g25b50@x ,00x $ & (*5 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (* 8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(:r0g25b750@,00x $ & (*; r25g25b75@@,00x $ & (*< r50g25b75@,00x $ & (*ce= r75g25b75@,00x $ & (*ll> r88g25b75@,00x $ & (*oj? r100g25b75@*00x" $ &(@r0g25b885@x,00x $ & (*A r25g25b88@@,00x $ & (*B r50g25b88@,00x $ & (*xC r75g25b88@ l1 $" .F_INVOICE_AMOUNT1FORMATTRIGGERfunction F_Invoice_Amount1FormatTrigger return boolean is begin -- Automatically Generated from Report Builder. if ((:c_invoice_amount IS NULL) or (:c_invoice_amount = '0')) then return (FALSE); end if; return (TRUE); end;Aͫͫͫͫͫͫͫw SYSSTANDARD $ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08*"PKG INIT"F_INVOICE_AMOUNT1FORMATTRIGGER""n[$ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ08 ,,,,T u  AAeb"FUNCTION"F_INVOICE_AMOUNT1FORMATTRIGGER"RETURN"BOOLEAN"C_INVOICE_AMOUNT""IS NULL"="0"FALSE"TRUE"" #$(357:>AFINRSZ]bfgnsuy|h,<ZZ.|RZ.|neZeZOQc  0  $ #  ' &%+ &% *    ! & ()) " %d%ͫͫͫͫͫͫͫ0D \\%( = L|"(   % % hg!X0F_INVOICE_AMOUNT1FORMATTRIGGER0 0H,@K V lt x@@C G EDF2 "*-02 7: ("#%-24=>?@"#-2.d@?=>ͫͫͫͫͫͫͫ0D   0t.00j `  .8 8! %t-.@@ %G1 $ ((%% hg! X0M_NO_DATA_FOUND_GRPFRFORMATTRI<0 8(@,H` d|2(*FWs    lp @@stringjhrwbwolwindowKIrwbwdowindow,*!rwbwfewindow*(Yrwbwetwindow)'rwbwtpwindow%#lrwbhrewindow#!rwbwtrwindow" rwbwfi1windowrwbwcmwindowrwbwdiwindow#rwbwmrwindowrwbwrgwindowrwbwcnwindow  rwbwsrwindow  rwbwgiwindow  HyperlinksWWboxMatrixCellbox rwbwmfwindow vgmitx_helpstringvgmirt_helpstringvgmigr_helpstringrwlorY pp-p@NOP0Q0RSTUVWsaddress_line3pvsa.address_line3ADDRESS_LINE3gN pp+p7CDE0F0GHIJKLv'Telephone''Telephone''TELEPHONE' g`f< pp%p+12304056789:y'Fax''Fax''FAX'g`H pp(p4=>?0@0ABCDEF|segment1pv.segment1SEGMENT1gZ pp0p>OPQ0R0STUVWXPayment_Run_Dateac.check_datePAYMENT_RUN_DATE g CI= pp$p-2340506789:;namehou.nameNAME gT);Z pp.p@OPQ0R0STUVWXaddress_line_1hl.address_line_1ADDRESS_LINE_1 gZ pp.p@OPQ0R0STUVWXaddress_line_2hl.address_line_2ADDRESS_LINE_2 gl_Z pp.p@OPQ0R0STUVWXaddress_line_3hl.address_line_3ADDRESS_LINE_3 g ph pp0pL]^_0`0abcdefTransaction_typeiv.invoice_type_lookup_codeTRANSACTION_TYPE gY pp/p>NOP0Q0RSTUVWc_our_referenceiv.voucher_numC_OUR_REFERENCE2g[ pp0p?PQR0S0TUVWXYc_your_referenceiv.invoice_numC_YOUR_REFERENCE2ggN pp*p8CDE0F0GHIJKLproject_idiv.project_idPROJECT_IDgl X pp.p>MNO0P0QRSTUVc_invoice_dateiv.invoice_dateC_INVOICE_DATE g ^ pp0pBSTU0V0WXYZ[\c_invoice_amountiv.invoice_amountC_INVOICE_AMOUNTg  pp1py00c_withheld_amount( DECODE ( aid.line_type_lookup_code , 'AWT' , aid.amount * - 1 , 0 ) )C_WITHHELD_AMOUNT&gINF pp(p2;<=0>0?@ABCDc_amountip.amountC_AMOUNTg; ^ pp0pBSTU0V0WXYZ[\c_discount_takenip.discount_takenC_DISCOUNT_TAKENgreC p p(p089:0;0<=>?@A'Dummy''Dummy''DUMMY'g`/Z&p'ABFpJpJpJJKL8N8P8R8TVWXgQ_RAP_01_RemittanceAdvice3_^U:UfGI FpGXYZ[ \^0_`a0bcd0efghixj8j@n8r8t vxpypypppechg_detail_sectiong^t_FFN(R VZ`(jnt(~(((SQL*ReportWriterxxREPORTOrafaqEng APPSxi 97ere APPSxj%3xxx ss*00x" $ &(ac)darkcyanit(00x " $&y *gray80333333(00x " $&Ne+gray76=p=p=p(00x " $&is,gray72GGG(00x " $&la-gray68QQQ'00x! "$%.r0g25b0@)00x " $&'/r25g25b0@@h)00x " $&'**0r50g25b0@)00x " $&'1r75g25b0@x)00x " $&'2r88g25b0@k+00x $ &()3 r100g25b0@*00x" $ &(x4r0g25b50@x ,00x $ & (*5 r25g25b50@@,00x $ & (*6 r50g25b50@,00x $ & (*7 r75g25b50@,00x $ & (* 8 r88g25b50@,00x $ & (*9 r100g25b50@*00x" $ &(:r0g25b750@,00x $ & (*; r25g25b75@@,00x $ & (*< r50g25b75@,00x $ & (*ce= r75g25b75@,00x $ & (*ll> r88g25b75@,00x $ & (*oj? r100g25b75@*00x" $ &(@r0g25b885@x,00x $ & (*A r25g25b88@@,00x $ & (*B r50g25b88@,00x $ & (*xC r75g25b88@ lSELECT pv.vendor_name, -- Supplier Name pvsa.address_line1, -- Supplier Address pvsa.address_line2, -- Supplier Address pvsa.address_line3, -- Supplier Address 'Telephone', 'Fax', pv.segment1, -- Account Number ac.check_date Payment_Run_Date, -- Payment run date hou.name, -- Organization Name hl.address_line_1, -- Organization Address hl.address_line_2, -- Organization Address hl.address_line_3, -- Organization Address iv.invoice_type_lookup_code Transaction_type, -- Transaction Type iv.voucher_num c_our_reference, -- Our Reference iv.invoice_num c_your_reference, -- Your Reference iv.project_id, -- Project ID iv.invoice_date c_invoice_date, -- Invoice/Doc date iv.invoice_amount c_invoice_amount, -- Original Invoice Amount (DECODE (aid.line_type_lookup_code, 'AWT', aid.amount * -1, 0)) c_withheld_amount,-- Withheld amount ip.amount c_amount, -- NETT Amount/Payment amounr ip.discount_taken c_discount_taken, 'Dummy' FROM ap_invoice_payments ip, ap_invoices iv, ap_invoice_distributions aid, ap_checks ac, po_vendors pv, po_vendor_sites_all pvsa, hr_organization_units hou, hr_locations hl WHERE ip.invoice_id = iv.invoice_id AND ip.invoice_id = aid.invoice_id AND ip.check_id = ac.check_id AND pv.vendor_id = ac.VENDOR_ID AND pv.vendor_id = pvsa.vendor_id AND pvsa.vendor_site_id = iv.vendor_Site_id AND pvsa.org_id = hou.organization_id AND hou.location_id = hl.location_id AND ip.amount >0 &LP_PAYMENT_BATCH >ͫͫͫͫͫͫͫ0D   0t.00j `  .8 8! %t-.@@ %G1 $ ((%% hg! X0M_NO_DATA_FOUND_GRPFRFORMATTRI<0 8(@,H` d|2(*FWs    lp @@stringjhrwbwolwindowKIrwbwdowindow,*!rwbwfewindow*(Yrwbwetwindow)'rwbwtpwindow%#lrwbhrewindow#!rwbwtrwindow" rwbwfi1windowrwbwcmwindowrwbwdiwindow#rwbwmrwindowrwbwrgwindowrwbwcnwindow  rwbwsrwindow  rwbwgiwindow  HyperlinksWWboxMatrixCellbox rwbwmfwindow vgmitx_helpstringvgmirt_helpstringvgmigr_helpstringrwlor/ bpdz{|}~ppp000000pppppppCF_Invoice_Amount_FMT h CF_INVOICE_AMOUNT_FMT/ bpd{|}~ppp000000pppppppCF_Withheld_Amount_FMT h CF_WITHHELD_AMOUNT_FMT/ bpdxyz{|}p~~pp000000p( ppppppCF_LessDiscount_FMT Cf Lessdiscount Fmt'ELD_CF_LESSDISCOUNT_FMT/ bpduvwxyzp~~pp000000p( ppppppCF_TotalNett_FMT Cf Totalnett Fmtmt 'ELD_CF_TOTALNETT_FMTg/ bpdwxyz{|ppp000000ppppppp.CS_Withheld_amounthh 'mtCS_WITHHELD_AMOUNT100/ bpdvwxyz{p~~pp000000pppppppCF_Project_Number h CF_PROJECT_NUMBER/ bpdtuvwxypzzp{p{{|}~000000ppppppp +CF_Project_Name h CF_PROJECT_NAME*Zp[op(vpzpz8z8|8~8x000000p0bp_Transaction_Typestem_0>&  x>& D*Zp[mn(rpvpv8v8x8z8|~x000000p0ENB_c_our_references00>   0> Dg*Zp[no(rpvpv8v8x8z8|~x000000p000B_c_your_references N>   N> D,00x $ & (*TAn r50g50b100,00x $ & (*co r75g50b100,00x $ & (*dep r88g50b100.00x & ( *,ADq r100g50b100DE'00x "$%D_ryellow +00x $ &() s darkyellow;*00x "$ &(tmagenta8.00x &( *,oiu darkmagentar (00x " $& -vgray48(00x " $&dewgray44\\\(00x " $& xgray40(00x " $&etygray36ףף'00x! "$%ndzr0g75b0)00x " $&'{r25g75b0@`(j)00x " $&'Re|r50g75b0ORT)00x " $&'xi}r75g75b0Sxj)00x " $&'~r88g75b0(ac+00x $ &() r100g75b0 .08x& ( *,000r0g75b50ay008x ( * ,.  00r25g75b50@008x ( * ,.la 00r50g75b50008x ( * ,.g2 00r75g75b50008x ( * ,.@ 00r88g75b50008x ( * ,. 00r100g75b50.08x& ( *,00r0g75b750008x ( * ,. 00r25g75b75@008x ( * ,.0 00r50g75b75008x ( * ,. 00r75g75b75008x ( * ,. $ 00r88g75b75008x ( * ,. ( 00r100g75b75.08x& ( *, 00r0g75b885008x ( * ,.  00r25g75b88@008x ( * ,.g2 00r50g75b88008x ( * ,.b7 00r75g75b88008x ( * ,. 00r88g75b88008x ( * ,. 00r100g75b88.08x' ( *, 00r0g75b100oj008x ( * ,. 00r25g75b100@008x ( * ,.0 00r50g75b100008x ( * ,. 00r75g75b100008x ( * ,. $ 00r88g75b100@r*Zp[ij(nprpr@r8v8x8z|}~x000000p0stbp_check_datece0>  > D0*Zp[mn(rpvpv@v8z8|8~x000000p0bp_Invoice_Amount00> >  0*Zp[op(vpzpz@z8~88x000000p000bp_CIS_Tax_Withheld00 @4 @4  0*Zp[jk(nprpr@r8v8x8z|}~x000000p000bp_Nett_Amountld0N@(@4N@(4  ݦ* Zp\lm(nprpr@r8v8x8z|}~x000000p0 ,bp_project_name0>$ @4>$ 4D (* Zp\qr(vpzpz@z8~88x000000p08bp_Carillion_Company 24*>24** Zp\no(rpvpv8v8x8z8|~x000000p0 bp_Project_Number0n> *n> D* Zp\ fh(nprpr8r8t0v8xz{|x000000p0 %bp_line_2#mber0.>n *.>.X * Zp\ fh(nprpr@r8v0x8z|}~x000000p0 00&bp_line_8#mber0>*>X  ]r25g88b100@008x ( * ,. 00r50g88b100008x ( * ,.re 00r75g88b100008x ( * ,. 00r88g88b100208x * , .00 00r100g88b100b1.08x & ( *, $00custom5.08x & ( *, (00custom6.08x & ( *,AD00custom7DE.08x & ( *,D_00custom8,08x $ & (*rk00gray16 ,08x $ & (*ge00gray12GGG,08x $ & (*rk00gray8,08x $ & (*00gray4-08x& (*+ay00r0g100b0/08x ( *,- 00r25g100b0@$/08x ( *,- 00r50g100b0/08x ( *,- 00r75g100b00/08x ( *,- " 00r88g100b0/08x ( *,-& 00r100g100b0j.08x' ( *, 00r0g100b50008x ( * ,.  00r25g100b50@008x ( * ,.00 00r50g100b50008x ( * ,.00 00r75g100b50008x ( * ,.00 00r88g100b50208x * , .000 00r100g100b508.08x' ( *,8g 00r0g100b758008x ( * ,.00 00r25g100b75@008x ( * ,.g7 00r50g100b75008x ( * ,.5g 00r75g100b75008x ( * ,.0g 00r88g100b75208x * , .05g 00r100g100b75.08x' ( *,b7 00r0g100b88008x ( * ,.5b 00r25g100b88@008x ( * ,.88 00r50g100b88008x ( * ,.b8 00r75g100b88008x ( * ,.b8 00r88g100b88208x * , .0b8 00r100g100b88 (008x( * ,. 00r0g100b100208x * , .0 00r25g100b100@ *208x * , .0oj 00r50g100b100208x * , .0 00r75g100b100208x * , .0 00r88g100b10000r75g75b100008x ( * ,. $ 00r88g75b100@r* Zp\ fh(nprpr@r8v0x8z|}~x000000p0 M(bp_line_9#mber0>>*>>>X  ]* Zp\ fh(nprpr@r8v0x8z|}~x000000p0 K)bp_line_7#mber0>*>X  ]* Zp\ fh(nprpr@r8v0x8z|}~x000000p0 E*bp_line_6#mber0>*>X  ]* Zp\ fh(nprpr@r8v0x8z|}~x000000p0 p@+bp_line_5#mber0>*>X  ]* Zp\ fh(nprpr8r8t0v8xz{|x000000p0 ,bp_line_4#mber0j>>*j>jX  ]* Zp\ bd(jpnpn8n8p0r8tvwxx~000000p0 -B_10n##m0L>jL>LXX* Zp\ fh(nprpr8r8t0v8xz{|x000000p0.bp_line_1# m00>L>T* Zp\pq(rpvpv8v8x8z8|~x000000p0gbp_hardcoded_text_1)0txtxu* Zp\jk(nprpr@r@v8z8|~x000000p0bp_Total Nett(t_0,U,Ug* Zp\mn(rpvpv@v8z8|8~x000000p0bp_Less Discount'00z,Uz,UGm_no_data_found_grpfrformattric.= p* .06:;b_4formattriggerrpfrfi( *= p* .06:;p_check_existsformulaiustI p6 :BCcf_withheld_amount_fmtformula#c$ 00= p* .06:;cf_balance_fmtformula%#&E p2 68>BCcf_lessdiscount_fmtformula'c(( *A p. 24:>?cf_totalnett_fmtformulala)*00b9 p& *,267cf_project_number+a),A p. 24:>? ,cf_project_nameformulaa- +.* ,I p6 :,x>xTr* Zp\ vx(~pp8808x000000p0 vbp_Summary_Calc_Divider1#,,0rTr* Zp\mn(rpvpv8v@z8~8x000000p0bp_Report_Title1.ide pBrB* Zp\rs(vpzpz@z@~88x000000p0pbp_Carillion_Company1/ 0**p* Zp\op(vpzpz8z@~88x000000p0bp_Project_Number18/ 0nca n D{* Zp\mn(rpvpv@v@z8~8x000000p0Sybp_project_name1780   D* Zp\lm(nprpr@r@v8z8|~x000000p0/bp_Nett_Amount160f  f  MATdfltDestination Format/bpcklmnoppvvpwpwwxy z|0}0~0000pppppppbDESNAME Destination Name/bpcklmnoppvvpwp~~000000pppppppcDESTYPE ScreenPDestination Typem_/bpcopqrstpzzp{p{{|}~000000p( ppppppivendor_namejScr'ypeVENDOR_NAME /bpcqrstuvpzzp{p{{|}~000000p( ppppppladdress_line1mcr'ypeADDRESS_LINE1/bpcqrstuvpzzp{p000000p( ppppppoaddress_line2pcrAddress Line 2ype'1ADDRESS_LINE2/bpcqrstuvpzzp{p000000p( ppppppraddress_line3scrAddress Line 3ype'1ADDRESS_LINE3/bpcmnopqrpvvpwpwwxyz{0|0}0~000p( ppppppuTelephonevs _`'TELEPHONE/bpcghijklprrpspsstuvw0x0y0z0{0|0}p~ ~ ppppppxFaxyvu0`'FAXa./bpclmnopqprrpspsstuvw0x0y0z0{0|0}p~(~ pppppp{segment1|'SEGMENT1/bpctuvwxypzzp{p{{|}~000000p( pppppp~Payment_Run_Date _ 'SEGMPAYMENT_RUN_DATE0/bpchijklmpnnpopoopqrs0t0u0v0w0x0ypz(z~ ppppppname' 'NAME 00r75g100b100208x * , .0 00r88g100b10000r75g75b100008x ( * ,. $ 00r88g75b100@ ,r* Zp\qr(vpzpz@z@~88x000000p0pbp_CIS_Tax_Withheld15f0" "  w* Zp\op(vpzpz@z@~88x000000p02bp_Invoice_Amount145f0   s* Zp\kl(rpvpv@v@z8~8x000000p0ssbp_check_date13140D* Zp\op(vpzpz8z@~88x000000p0B_c_our_reference1200. . D/* Zp\qr(vpzpz8z@~88x000000p0bp_Transaction_Type1100  c* Zp\pq(rpvpv8v@z8~8x000000p0_yB_c_your_reference190R  R Dc* Zp\ef(jpnpn@n@r8v8xz{|x000000p0robp_Page1>fer0 Ds* Zp\hi(jpnpn@n@r8v8xz{|x000000p0oibp_Page_of1<0 D/* Zp\pq(rpvpv8v@z@~8x000000p0bp_hardcoded_text_3:0ZZD/bpcuv xz{|ppp000000p( pppppp֟c_withheld_amount-00.00!&C Withheld Amount_'E_AMC_WITHHELD_AMOUNT/bpclmnopqprrpspxxyz{|0}0~0000p  ppppppc_amounth0.00!C AmountN 'eld C_AMOUNTD/bpctuvwxypzzp{p{{|}~000000p  ppppppc_discount_takenh!C Discount TakenN 'OUNTC_DISCOUNT_TAKEN/ bpdopqrstpzzp{p{{|}~000000p( pppppp4CS_Balance hBalance'CS_BALANCEDDR/ bpdtuvwxypzzp{p000000p( pppppp7CS_LessDiscount 0.00 Lessdiscount'ALANCS_LESSDISCOUNTS_/ bpdqrstuvpzzp{p000000p( pppppp8CF_TotalNett0.00 Totalnettnt!'ALANCF_TOTALNETT_/ bpduvwxyzp~~pp 008888pppppppLP_PAYMENT_BATCH.0 QW;'"!'LP_PAYMENT_BATCHc/ bpdtuvwxypzzp{p000000ppppppp P_CHECKRUN_NAMECheque100_Batch2 P_CHECKRUN_NAME0z/ bpdopqrstpzzp{p{{|}~000000pppppppP_CHECK_ID P_CHECK_IDp/ bpdtuvwxypzzp{p{{|}~008888ppppppp6CS_Record_Counti U;V CS_RECORD_COUNTpz(z~ ppppppname' 'NAME 00r75g100b100208x * , .0 00r88g100b10000r75g75b100008x ( * ,. $ 00r88g75b100@0 r* Zp\`a(bpfpf@f@j8n8prstxz000000p0pB_3?60Z6ZD* Zp\ rt(zp~p~0~@@0x000000p0bp_line_no_data_found#@0Zr* Zp\mn(rpvpv@v@z8~8x000000p0bp_no_data_foundAnd0:U:UD* Zp\ tv(zp~p~0~@@0x000000p0bp_line_no_data_found1#B0:* Zp\lm(nprpr8r8t8v8xz{|x000000p0_Abp_report_titleC0>U0:>U* Zp\ hj(nprpr8r@v0z8|~x000000p0 bp_line_16i#DC0*p *** Zp\ hj(nprpr8r@v0z8|~x000000p0 zbp_line_10i#EC0J0 JJ* Zp\ hj(nprpr8r@v0z8|~x000000p0 zbp_line_12i#FC0j8 jj* Zp\ hj(nprpr@r@v0z8|~x000000p0 xbp_line_13i#GC0  Cf Balance Fmt'ESCRCF_BALANCE_FMTp( pppppp֟c_withheld_amount-00.00!&C Withheld Amount_'E_AMC_WITHHELD_AMOUNT/bpclmnopqprrpspxxyz{|0}0~0000p  ppppppc_amounth0.00!C AmountN 'eld C_AMOUNTD/bpctuvwxypzzp{p{{|}~000000p  ppppppc_discount_takenh!C Discount TakenN 'OUNTC_DISCOUNT_TAKEN/ bpdopqrstpzzp{p{{|}~000000p( pppppp4CS_Balance hBalance'CS_BALANCEDDR/ bpdtuvwxypzzp{p000000p( pppppp7CS_LessDiscount 0.00 Lessdiscount'ALANCS_LESSDISCOUNTS_/ bpdqrstuvpzzp{p000000p( pppppp8CF_TotalNett0.00 Totalnettnt!'ALANCF_TOTALNETT_/ bpduvwxyzp~~pp 008888pppppppLP_PAYMENT_BATCH.0 QW;'"!'LP_PAYMENT_BATCHc/ bpdtuvwxypzzp{p000000ppppppp P_CHECKRUN_NAMECheque100_Batch2 P_CHECKRUN_NAME0z/ bpdopqrstpzzp{p{{|}~000000pppppppP_CHECK_ID P_CHECK_IDp/ bpdtuvwxypzzp{p{{|}~008888ppppppp6CS_Record_Counti U;V CS_RECORD_COUNTpz(z~ ppppppname' 'NAME 00r75g100b100208x * , .0 00r88g100b10000r75g75b100008x ( * ,. $ 00r88g75b100@@r* Zp\ hj(nprpr@r@v0z8|~x000000p0 pbp_line_14i#HC0 * Zp\ hj(nprpr@r@v0z8|~x000000p0 bp_line_15i#IC0 * Zp\ hj(nprpr@r@v0z8|~x000000p0 bp_line_17i#JC0 * Zp\ hj(nprpr@r@v0z8|~x000000p0 bp_line_18i#KC0B BB* Zp\op(vpzpz@z8~88x000000p0bp_Account_Number1N0B0"B"x* Zp\mn(rpvpv@v8z8|8~x000000p0bp_Payment_Date1QN00* Zp\ `b(fpjpj@j8n0p8rtuvxz000000p0B_1#Rent00f* Zp\ `b(fpjpj@j8n0p8rtuvxz000000p0B_2#Sent00 m* Zp\tu(vpzpz0z@~@8x000000p0vbp_no_input_parameters1U0  D* Zp\ np(vpzpz8z8|0~8x000000p0RRbp_line_header_1eVs1U0.>  .>.J |}~M_AccountNumber_FR_#LFR Vm BpD VX(^pbpb@b8f8h8jlmno0p0q0r0s0t0uv0w0xyz{|}~M_Payment_Date_FR#OLFR V' BpD[\(bpfpf0f@j@n8rtuvw0x0y0z0{0|0}~00M_No_Input_Parameters1T 0Vt_ BpD RT(Zp^p^8^8`@b8fh jlm0n0o0p0q0r0st0u0vwxyz{|}~R_Dummy_GRPRFoters1 JrV BpD \^(bpfpf8f8h@j8npqrs0t0u0v0w0x0yz0{0|}~ ]R_Detail_Section_GRPRF1 oeJLr hDR#JpK Z\(bpfpf8f8h8j8lnopqrstuv0w0x0ypzpz0z{|}~f_Vendor_NameF eJ ^i #JpK \^(bpfpf8f8h8j8lnopqrstuv0w0x0ypzpz0z{|}~f_address_line1J ^l#JpK \^(bpfpf8f8h8j8lnopqrstuv0w0x0ypzpz0z{|}~f_address_line2J ^ov#JpK \^(bpfpf8f8h8j8lnopqrstuv0w0x0ypzpz0z{|}~f_address_line3J  ^r#JpK \^(bpfpf@f8j8l8npqrstuvwx0y0z0{p|p~0~F_Org_TelephoneJ 4&DuP_#JpK \^(bpfpf@f8j8l8npqrstuvwx0y0z0{p|p~0~F_Org_FaxNumber J 4,Dxp#JpK df(jpnpn@n8r8t8vxyz{|}~000pp0F_Organization_Unit_Name 4 4Dp{#JpK ^`(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0F__Org_Addr_line_1 me 4DT#JpK ^`(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0F__Org_Addr_line_2 me 4Dx * , .0 00r88g100b10000r75g75b100008x ( * ,. $ 00r88g75b100@P r* Zp\ np(vpzpz8z8|0~8x000000p0in{bp_line_header_2eWs1U0L>  L>LJ |* Zp\ np(vpzpz8z8|0~8x000000p0bp|bp_line_header_3eXs1U0j>  j>jJ * Zp\ np(vpzpz@z8~08x000000p00~}bp_line_header_4eYs1U0>  >J b* Zp\ np(vpzpz@z8~08x000000p0~bp_line_header_5eZs1U0>  >J a* Zp\ np(vpzpz@z8~08x000000p0vbp_line_header_6e[s1U0>  >J * Zp\ np(vpzpz@z8~08x000000p01bp_line_header_7e\s1U0>  >J * Zp\ np(vpzpz@z8~08x000000p0bp_line_header_8e]s1U0>>  >>>J 2* Zp\no(rpvpv@v@z8~8x000000p0z bp_end_of_report1^]s0D D DL* Zp\hi(jpnpn@n@r8v8xz{|x000000p0 bp_Page_of2bDDD~* Zp\ef(jpnpn@n@r8v8xz{|x000000p0pL bp_Page2`bDDD* Zp\pq(rpvpv8v@z@~8x000000p0 bp_hardcoded_text_2_0TldTDp* Zp\ `b(fpjpj8j@n@r0vwxyxz000000p0 B_4#dcod0txT                        pL  t  0~   f_     R  VpL  t  0~  f_    dz  fz/  hzpx  jz  jzS   kzmo  kz  mzI  mzpa  oz_a  pzmo  qz(2  qz^_`papaab Wc_invoice_amount c_invoice_amountJ 4&DuP_#JpK \^(bpfpf@f8j8l8npqrstuvwx0y0z0{p|p~0~F_Org_FaxNumber J 4,Dxp#JpK df(jpnpn@n8r8t8vxyz{|}~000pp0F_Organization_Unit_Name 4 4Dp{#JpK ^`(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0F__Org_Addr_line_1 me 4DT#JpK ^`(fpjpj@j8n8p8rtuvwxyz{|0}0~0pp0F__Org_Addr_line_2 me 4Dx * , .0 00r88g100b10000r75g75b100008x ( * ,. $ 00r88g75b100@