ROS.60050(&Š’’’’r  ē  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ”¢£¤„¦§Ø©Ŗ«¬­®Æ°±²³“µ¶·ø¹ŗ»¼½¾æĄĮĀĆÄÅĘĒČÉŹĖĢĶĪĻŠŃŅÓŌÕÖ×ŲŁŚŪÜŻŽßąįāćäåęēčéźėģķīļšńņóōõö÷ųłśūüżž0Ø5&Help’’’’,0Ø*8Find and Replace’’’’'0Ø%8 Fi&nd What:’’’’*0Ø(8Re&place With:e’’’’/0Ø-8Regular &Expression’’’’+0Ø)8&Case Sensitive’’’’&0Ø$8 &Find Nextt’’’’$0Ø"8&Replace’’’’(0Ø&8 Replace &All’’’’"0Ø 8Cancel ’’’’!0Ø8 &Help ’’’’,0Ø*9Find and Replace’’’’'0Ø%9 Fi&nd What:’’’’*0Ø(9Re&place With:e’’’’/0Ø-9Regular &Expression’’’’+0Ø)9&Case Sensitive’’’’&0Ø$9 &Find Nextt’’’’$0Ø"9&Replace’’’’(0Ø&9 Replace &All’’’’"0Ø 9Cancel ’’’’!0Ø9 &Help ’’’’Q0ØO:5No matches found. Continue search from the beginning?’’’’$0Ø":Continue’’’’<0Ø:; No matches found. End of Search.’’’’0Ø;OKm’’’’W0ØU<;No matches found. Continue search on the next program unit?’’’’$0Ø"<Continue’’’’'0Ø%= PL/SQL Step’’’’"0Ø =&Mode:S’’’’!0Ø=&IntoS’’’’!0Ø=O&verS’’’’ 0Ø=O&ut’’’’ 0Ø=&To:’’’’*0Ø(=&Program Unit:’’’’"0Ø =&Line:m’’’’#0Ø!=&Count:’’’’"0Ø = &Apply’’’’0Ø= OKp’’’’"0Ø = Cancel’’’’!0Ø= &Help’’’’'0Ø%> PL/SQL Step’’’’"0Ø >&Mode:S’’’’!0Ø>&IntoS’’’’!0Ø>O&verS’’’’ 0Ø>O&ut’’’’ 0Ø>&To:’’’’*0Ø(>&Program Unit:’’’’"0Ø >&Line:m’’’’#0Ø!>&Count:’’’’"0Ø > &Apply’’’’0Ø> OKp’’’’"0Ø > Cancel’’’’!0Ø> &Help’’’’=0Ø;?!PL/SQL Stored Program Unit Editor’’’’60Ø4?Stored Program Unit EditorE’’’’$0Ø"?&Program’’’’$0Ø"?&Compile’’’’(0Ø&? &Incremental’’’’ 0Ø?&All’’’’30Ø1?&Program Unit Editor...’’’’20Ø0?PL/SQL &Interpreter...’’’’:0Ø8?&Stored Program Unit Editor...o’’’’70Ø5? Database &Trigger Editor...’’’’.0Ø,? Synta&x Palette...d’’’’A0Ø?? %&Find and Replace in Program Units...’’’’ 0Ø? &New’’’’!0Ø? &Savean’’’’#0Ø!?&Revert’’’’!0Ø?&Dropt’’’’"0Ø ?&Close’’’’!0Ø?He&lp’’’’"0Ø ?Owner:’’’’!0Ø?Name:’’’’(0Ø&? Not Modified’’’’10Ø/?Successfully Compiledro’’’’0800Ø (0’’’’0800Ø ‰@’’’’0800Ø ŠP’’’’(0000Ø&FG’’’’ 0800Ø4`p1DE@Ąr0 x!…,¢Ą08LETTER rurŠ08*CURSOR  IP08 PARA_VAE `08UE_NUM) F_€08M PM_COM PA 08RE PARA_DEš00 M_DTLSAVAR08 BEGIN F  00HEN LOSp08F; OPENC108INTO M_D!SAP 08E ,DP_`&00x $VALUE_NUD r88g25b88NU€I >p@p@p@0FG ='BANK_CD' ; COMMIT; RETURN (M_DTLSA); */ ..Arial ISpY p p6pBVW REF_LETTER FR*G"Q_2_COMP_BANK_ADD_2"B.BANK_ADD2Q_2_COMP_BANK_ADD_2SA €sbpcnopqRNO VARCHAR2(2000); BEGIN IF C1%ISOPEN THEN CLOSE C1; END IF; OPEN C1; FE”P_TITLE_11JTw bpdrstuT PARA_TYPE = TO_NUMBER(PARA_TYPE)+1 UPDATE PM_COMP_PARAMETER SET PARA_VALUE = TO_‡CP_BANK_ADDR2+ t bpdopqr'BANK_CD' ; COMMIT; M_DTLSA := 'MAT/L'||LPAD(M_LTRNO,4,'0')||'/'||TO_CHAR(SYSDATEÖCP_TO_LOCN°w bpdrstu ’’’’ 0800Ø"ĀP`’’’’–0808Ø”#~~function CF_LETTCP_BANK_AC_NO//Ą~ bpdwx z|CT PARA_VALUE || (PARA_TYPE) REF_LETTER FROM PM_COMP_PARAMETER WHERE PARA_CODE *JQ_2_EMP_BANK_NAME1*9ISŠp bpdklmn FROM PM_COMP_PARAMETER WHERE PARA_CODE ='BANK_CD'; M_DTLSA VARCHAR2(2000); M_-rP_DATEZ°x bpdrs tv C1%ISOPEN THEN CLOSE C1; END IF; OPEN C1; FETCH C1 INTO M_LTRNO; CLOSE C1.>CF_REF_LETTERóĄl Zp\ `b(fpj+1 UPDATE PM_COMP_PARAMETER SET PARA_VALUE = TO_NUMBER(PARA_VALUE) + 1 WHE-œB_9+(! 0ąd BpD VX(^pb M_DTLSA := 'MAT/L'||LPAD(M_LTRNO,4,'0')||'/'||TO_CH-1R_EMP_BANK_LEVEL1YP*ā0šh JpL Z\(bpf’0808ؐ$zzselect BANKC_COMP_CODE "Q_1_COMP_CO-ćF_2_EMP_NAME4.' fÅ0 ME", BANK_ADD1 "Q_1_BANK_ADD1", BANK_ADD2 "Q_1_BANK_ADD2", BANK_ADD3 "Q_1_BANK_ADD3", BANKC_CODE "Q_1_BANK_CODE", BANKC_ACNT_NO "Q_1_BANKC_ACNT" from PM_BANK ,PM_BANK_COMP WHERE BANKC_COMP_CODE = :CP_COMP_CODE AND BANKC_CODE = BANK_CODE AND NVL(BANKC_ACNT_NO,'0') != '0'C_’’’’0800Ø%  ’’’’œ€*€>€F€R[(^ b€fąo(v€ząƒ(Š€Ž€Ž(Ž(’(–š_ESQL*ReportWriters REPORTPAYUSER ouPR007CRAc.} PAYROLLwÅP@PAYUSERxl˜v˜™’’’’ pInsrepplDE’’’’S N¢(¦0Ŗ«¬@²@¶0ŗ0»@¾@Ā@Ę@Ź@Ī@Ņ0Ö0×ŲŁ0Ś0Ū8Ü8Žąpįpįpāāćäåęēč ź0ģ0ķīļ8š8ņ0ōõö ųśūüż@žA11A AAAAA1"1#A&A*1.1/A2A6A:A>ABAF1J1KLMNOPQidpś‘„Ē† ­°PB==@!@`@`8Śs «ījj.v† ­°PBW2@`@`@`† ­°PB@`@`@` ’’’’ 00 )’’’’ 00P_MOUNT , 0 ) ) ) )Q_2_FP_FC_AMOUNT&Iy’’’’a p p5pATUV0W0X Z\]^_*A"Q_2_COMP_BANK_NAME"B.BANK_NAMEQ_2_COMP_BANK_NAME I ’’’’s p p;pMfgh0i0j lnopq*C"Q_2_COMP_BANK_SHORT_NAME"B.BANK_SHORT_NAMEQ_2_COMP_BANK_SHORT_NAMETIP’’’’c p p6pBVWX0Y0Z \^_`a*E"Q_2_COMP_BANK_ADD_1"B.BANK_ADD1Q_2_COMP_BANK_ADD_1SI’(0Ø&? &Incremental’’’’ 0Ø?&All’’’’30Ø1?&Program Unit Editor...’’’’20Ø0?PL/SQL &Interpreter...’’’’:0Ø8?&Stored Program Unit Editor...o’’’’70Ø5? Database &Trigger Editor...’’’’.0Ø,? Synta&x Palette...d’’’’A0Ø?? %&Find and Replace in Program Units...’’’’ 0Ø? &New’’’’!0Ø? &Savean’’’’#0Ø!?&Revert’’’’!0Ø?&Dropt’’’’"0Ø ?&Close’’’’!0Ø?He&lp’’’’"0Ø ?Owner:’’’’!0Ø?Name:’’’’(0Ø&? Not Modified’’’’10Ø/?Successfully Compiledro’’’’0800Ø (0’’’’0800Ø ‰@’’’’0800Ø ŠP’’’’(0000Ø&FG’’’’ 0800Ø4`p1DEž’’’’’’’šx0’’’’ r’’’’ x ‘,¢/’’’’’’ xŽ2,ģtPlease arrange to transfer the following funds to various Banks/Branches telegraphically as per following details .’’’’& x$_I,ļ Dear Sir, ’’’’` x^AR-7DThe proceeds of the above transfers may be debited to our Current a’’’’* x((V-eThanking You,’’’’3 x1š-g(Authorised Signature)c’’’’, x* r-hYour Faithfully’’’’* x( -lThanking You,E,’’’’3 x1OM-m(Authorised Signatory):’’’’/ x-NV-nYours faithfully, ’’’’’6 x4-nfor Al Ghandi Investmentsnc’’’’; x9et-(NO OF EMPLOYEES .......&F_3 )R’’’’„ x‚LE-½hThe proceeds of the above transfers may be debited to our current account &F_1_COMP_BANK_Ac_no with you’’’’ˆ x† A-ĪlThe proceeds of the above transfers may be debited to our Current Account No.&F_1_COMP_BANK_Ac_no with you.),'Mon-YYYY')NK_’’’’ 0800Ø 6!ž@; ELSIF M_ITEM_NAME = 'CP_BANK_NAME' THEN :CP_BANK_NAME := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_BANK_NAME1' THEN :CP_BANK_NAME1 := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_EMP_CODE' THEN :CP_EMP_CODE := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_EMP_NAME' THEN :CP_EMP_NAME := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_FP_LC_AMOUNT' THEN :CP_FP_LC_AMOUNT := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_END_OF_REP' THEN :CP_END_OF_REP := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_TOTAL' THEN :CP_TOTAL := M_BP_VALUE; END IF; END LOOP; CLOSE C1; END;L> &IntoS’’’’!0Ø=O&verS’’’’ 0Ø=O&ut’’’’ 0Ø=&To:’’’’*0Ø(=&Program Unit:’’’’"0Ø =&Line:m’’’’#0Ø!=&Count:’’’’"0Ø = &Apply’’’’0Ø= OKp’’’’"0Ø = Cancel’’’’!0Ø= &Help’’’’'0Ø%> PL/SQL Step’’’’"0Ø >&Mode:S’’’’!0Ø>&IntoS’’’’!0Ø>O&verS’’’’ 0Ø>O&ut’’’’ 0Ø>&To:’’’’*0Ø(>&Program Unit:’’’’"0Ø >&Line:m’’’’#0Ø!>&Count:’’’’"0Ø > &Apply’’’’0Ø> OKp’’’’"0Ø > Cancel’’’’!0Ø> &Help’’’’=0Ø;?!PL/SQL Stored Program Unit Editor’’’’60Ø4?Stored Program Unit EditorE’’’’$0Ø"?&Program’’’’$0Ø"?&Compile’’’’(0Ø&? &Incremental’’’’ 0Ø?&All’’’’30Ø1?&Program Unit Editor...’’’’20Ø0?PL/SQL &Interpreter...’’’’:0Ø8?&Stored Program Unit Editor...o’’’’70Ø5? Database &Trigger Editor...’’’’.0Ø,? Synta&x Palette...d’’’’A0Ø?? %&Find and Replace in Program Units...’’’’ 0Ø? &New’’’’!0Ø? &Savean’’’’#0Ø!?&Revert’’’’!0Ø?&Dropt’’’’"0Ø ?&Close’’’’!0Ø?He&lp’’’’"0Ø ?Owner:’’’’!0Ø?Name:’’’’(0Ø&? Not Modified’’’’10Ø/?Successfully Compiledro’’’’0800Ø (0’’’’0800Ø ‰@’’’’0800Ø ŠP’’’’(0000Ø&FG’’’’ 0800Ø4`p1DE@’’’’pr’’’’.hh,vROSATTRIBSclass attributes0‰’’’’+hh)p•ROSLFDESCros lf descrip°’’’’)hh'RROSOBJMAPros name->id’’’’+hh)ROSSTRINGStk2 uiStringsd’’’’*hh(p{ROSSTRUCTSstruct types‹’’’’*hh(“ROSTK2RESVtk2 reservedCF’’’’hhSRW2_ANCHOR’’’’&h!"h#$SRW2_BODY_LOCATION p\’’’’$h h!"rSRW2_BOILERPLATE’’’’hh0ŖSRW2_BUTTON!²’’’’hhR(SRW2_COLUMN’’’’#hh !ÖSRW2_DATA_MODEL ’’’’$h h!"SRW2_DISPLAY_TAG’’’’%h !h"#rSRW2_DISTRIBUTION'•–’’’’ hhŖSRW2_ELEMENT’’’’hhß SRW2_FIELDIø’’’’)h$%h&'SRW2_FORMAT_EXCEPTION&’’’’hhdSRW2_FRAMEv’’’’hh0šSRW2_GROUP¦’’’’#hh !¶SRW2_GROUP_NODE#’’’’"hh āSRW2_HYPERLINK"U’’’’$h h!"SRW2_JAVA_APPLET$’’’’(h#$h%&bSRW2_JAVA_PROPERTIES%’’’’hh–SRW2_LAYOUT Ø’’’’%h !h"#ANSRW2_LAYOUT_GROUP į.’’’’hhVćSRW2_LINK’’’’hhSRW2_LISTS *’’’’hh8rSRW2_MATRIX–’’’’'h"#h$%0 SRW2_OGD_COLUMN_MAP¶’’’’$h h!" SRW2_OG_DOCUMENT’’’’#hh !USRW2_PARAM_FORM’’’’hhSRW2_QUERYp\’’’’%h !h"#vSRW2_TEXT_SEGMENT›œ’’’’hh°TOOL_ACCESSø’’’’ hhTOOL_COMMENT’’’’ hhUTOOL_LIBRARY ’’’’hhTOOL_MODULE*’’’’hh8rTOOL_PLSQL0–’’’’$pp"0 VG_COLORVG_COLOR’’’’+pp $&'()VG_COLORITEMID)@ć’’’’+pp $&'()VG_COLORCELLID)@’’’’-pp &()*+VG_COLORNAME_SET@ zŠ’’’’/pp (*+,-VG_COLORNAME_LENGTH “’’’’/pp (*+,-VG_COLORCOLOR_NAMExU’’’’'pp "#$%VG_COLORRED B’’’’)pp "$%&'VG_COLORGREEN P ’’’’)pp "$%&'VG_COLORBLUE ’’’’' x% = APTH_CR_DT ’’’’2 x0) ™===================++ ’’’’ x€Rž=(v’’’’. x,SQ_Q 1 Apth Txn CodePA’’’’. x,aQ 1 Apth Ref FromPA’’’’. x,cQ 1 Tt Short DescE’’’’2 x00ŗeQ 1 Apth Cont Sign Dtą’’’’. x,0ģuQ 1 Apth Emp Code@ž’’’’, x*A&yQ 1 Apth Amd No’’’’2 x0}Q 1 Apth Amd Res Code`’’’’# x! Ė======’’’’É xĒ@ ­============================================================================================================================================================================TU’’’’ x_C ž==M’’’’Ā xĄP_ ¦=====================================================================================================================================================================_’’’’  xDD ===’’’’Į xæ1 „====================================================================================================================================================================’’’’ x…=’’’’' x%to*\ ATTENTION i’’’’ x*\:’’’’% x#Ed*\ MANAGER’’’’† x„nt*wjPlease credit the payee's account without any deductions and debit our account with any charges of your ’’’’M xK*w1correspondent banks related to these transfers. Rev’’’’- x+Ø*{Sincerely Yours "’’’’4 x2*†Authorized Signatories ’’’’ x*Ų1.’’’’ x’’*Ś2.’’’’ x+of’’’’E xCt + )Total No of Pages Including this Page : lly’’’’% x#8+# Page : 0’’’’# x! ‰,Ref :0800Ø ŠP’’’’(0000Ø&FG’’’’ 0800Ø4`p1DEP’’’’¼r’’’’ 08»,D„’’’’ 2jk0l8n0p8r8t v x0z0{|}8~€ąˆ‰Š‹ŒppŽpŽpŽpŽpŽp¾pĪr(rKrKr`r`r`r`r`rbbrcrfšfrjrrrsrtrŠŠ‹FOe*—ūi’N€ “



PR007CR’’’’¬B(F0JK@N@R@V@Z0^0_8`0b8d8f h0j0klm8n8p0rstuvpwp‰p©©Ŗfr`rś‘`rœ@œ@€€PnMrņeījj’iReport ParametersEnter values for the parameters’’’’$00x !"Oblack’’’’(00x " $&white’’’’’’’’’’%00x "#green’’’’’’)00x# $&' darkgreen€€’’’’(00x " $&gray96 = = =’’’’(00x " $&gray92zzz’’’’(00x " $&gray88øøø’’’’(00x " $&gray84(õ(õ(õ’’’’%00x !"#r0g0b0’’’’(00x "$%& r25g0b0@’’’’(00x "$%& r50g0b0€’’’’(00x "$%&AT r75g0b0Ą’’’’(00x "$%& r88g0b0ą’’’’(00x "$%& r100g0b0’’’’’’(00x!" $&onr0g0b50’€’’’’*00x "$ &(inr25g0b50@€€ET’’’’*00x "$ &(UEr50g0b50€€€8’’’’*00x "$ &()r75g0b50Ą€€@’’’’*00x "$ &(+r88g0b50ą€€@’’’’,00x $& (*+ r100g0b50’’€€’’’’(00x!" $& (r0g0b75Ą’’’’*00x "$ &(r25g0b75@ĄĄ_C’’’’*00x "$ &(r50g0b75€ĄĄOR’’’’*00x "$ &(r75g0b75ĄĄĄOR’’’’*00x "$ &(r88g0b75ąĄĄ’’’’,00x $& (* r100g0b75’’ĄĄ’’’’(00x!" $&r0g0b88ą’’’’*00x "$ &(r25g0b88@ąą1 ’’’’*00x "$ &(r50g0b88€ąą’’’’*00x "$ &(r75g0b88Ąąą’’’’*00x "$ &(’’r88g0b88ąąą0ŗ’’’’,00x $& (* D r100g0b88’’ąą’’’’(00x"# $&mp r0g0b100’’’’’’,00x $& (*1 ! r25g0b100@ą’’’’’’,00x $& (*1 " r50g0b100€ą’’’’’’,00x $& (*# r75g0b100Ąą’’’’’’,00x $& (*==$ r88g0b100ąą’’’’’’,00x $& (*==% r100g0b100’’ą’’’’’’&00x  "$==&grayĄĄĄ==’’’’*00x " $ &(=='darkgray€€€==’’’’&00x "$(cyanr’’’’’’’’*00x" $ &(P_)darkcyan’€€==’’’’(00x " $&==*gray80333333’’’’(00x " $&==+gray76=p=p=p’’’’(00x " $&==,gray72G®G®G®’’’’(00x " $&’’-gray68QėQėQė’’’’'00x! "$%.r0g25b0@’’’’)00x " $&'==/r25g25b0@@===’’’’)00x " $&'==0r50g25b0€@===’’’’)00x " $&'==1r75g25b0Ą@===’’’’)00x " $&'2r88g25b0ą@x’’’’+00x $ &()3 r100g25b0’’@’’’’*00x" $ &(4r0g25b50@€’’’’,00x $ & (*5 r25g25b50@@€’’’’,00x $ & (*6 r50g25b50€@€’’’’,00x $ & (*de7 r75g25b50Ą@€’’’’,00x $ & (*s 8 r88g25b50ą@€’’’’,00x $ & (*rr9 r100g25b50’’@€’’’’*00x" $ &(ev:r0g25b750@Ąx’’’’,00x $ & (*s ; r25g25b75@@Ą’’’’,00x $ & (* S< r50g25b75€@Ą’’’’,00x $ & (*= r75g25b75Ą@Ą’’’’,00x $ & (*> r88g25b75ą@Ą’’’’,00x $ & (*t ? r100g25b75’’@Ą’’’’*00x" $ &(: @r0g25b885@ą’’’’,00x $ & (*0A r25g25b88@@ą’’’’,00x $ & (*0B r50g25b88€@ą’’’’,00x $ & (*C r75g25b88Ą@ą0800Ø4`p1DE`’’’’ąr’’’’,00x $ & (*„D r88g25b88ą@ą’’’’,00x $ & (*‹E r100g25b88’’@ą’’’’*00x# $ &(rjF r0g25b100@’’*’’’’h>p?p?p?0KLMNOPQRSTUV XZ[\]^_`abcdefiCourier Newq č ’’’’h >p@p@p@0LMNOPQRSTUVW XZ[\]^_`abcdefeCourier Newč’’’’b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_` ĒArialčin’’’’] >p@p@pB0BCDEFGHIJKLMNOPQRSTUVWXYZ[Yr’’ tr>’’’’b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`'ņArialč$l ’’’’b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`(Arial’’č$ `r’’’’b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`(ĘArial’’„ 0’’’’b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`*—Arial„’’’’] >p@p@pB0BCDEFGHIJKLMNOPQRSTUVWXYZ[+(r’ 6 =’’’’b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`+eArialč0’’’’b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`+nArialq’’č$ ’’’’b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`-:Arialč’’’’b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`-VArialč’’’’b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`-`ArialčUE’’’’b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`-pArial’’č 8g’’’’b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`.Arial’’„ Ą’’’’b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`.Arial’’č ’’’’b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`. Arial ’’„ x $& (* r100g0b75’’ĄĄ’’’’(00x!" $&r0g0b88ą’’’’*00x "$ &(r25g0b88@ąą1 ’’’’*00x "$ &(r50g0b88€ąą’’’’*00x "$ &(r75g0b88Ąąą’’’’*00x "$ &(’’r88g0b88ąąą0ŗ’’’’,00x $& (* D r100g0b88’’ąą’’’’(00x"# $&mp r0g0b100’’’’’’,00x $& (*1 ! r25g0b100@ą’’’’’’,00x $& (*1 " r50g0b100€ą’’’’’’,00x $& (*# r75g0b100Ąą’’’’’’,00x $& (*==$ r88g0b100ąą’’’’’’,00x $& (*==% r100g0b100’’ą’’’’’’&00x  "$==&grayĄĄĄ==’’’’*00x " $ &(=='darkgray€€€==’’’’&00x "$(cyanr’’’’’’’’*00x" $ &(P_)darkcyan’€€==’’’’(00x " $&==*gray80333333’’’’(00x " $&==+gray76=p=p=p’’’’(00x " $&==,gray72G®G®G®’’’’(00x " $&’’-gray68QėQėQė’’’’'00x! "$%.r0g25b0@’’’’)00x " $&'==/r25g25b0@@===’’’’)00x " $&'==0r50g25b0€@===’’’’)00x " $&'==1r75g25b0Ą@===’’’’)00x " $&'2r88g25b0ą@x’’’’+00x $ &()3 r100g25b0’’@’’’’*00x" $ &(4r0g25b50@€’’’’,00x $ & (*5 r25g25b50@@€’’’’,00x $ & (*6 r50g25b50€@€’’’’,00x $ & (*de7 r75g25b50Ą@€’’’’,00x $ & (*s 8 r88g25b50ą@€’’’’,00x $ & (*rr9 r100g25b50’’@€’’’’*00x" $ &(ev:r0g25b750@Ąx’’’’,00x $ & (*s ; r25g25b75@@Ą’’’’,00x $ & (* S< r50g25b75€@Ą’’’’,00x $ & (*= r75g25b75Ą@Ą’’’’,00x $ & (*> r88g25b75ą@Ą’’’’,00x $ & (*t ? r100g25b75’’@Ą’’’’*00x" $ &(: @r0g25b885@ą’’’’,00x $ & (*0A r25g25b88@@ą’’’’,00x $ & (*0B r50g25b88€@ą’’’’,00x $ & (*C r75g25b88Ą@ą0800Ø4`p1DEp’’’’€r’’’’c p p6pBVWX0Y0Z \^_`a*G"Q_2_COMP_BANK_ADD_2"B.BANK_ADD2Q_2_COMP_BANK_ADD_2SI’’’’c p p6pBVWX0Y0Z \^_`a*I"Q_2_COMP_BANK_ADD_3"B.BANK_ADD3Q_2_COMP_BANK_ADD_3SId’’’’“ p p4pt†‡ˆ0‰0Š ŒŽ‘*K"Q_2_EMP_BANK_NAME"DECODE ( : P_LANG_CODE , 'ENG' , A.BANK_NAME , A.BANK_BL_NAME )Q_2_EMP_BANK_NAME CI’’’’« p p:p†žŸ 0”0¢ ¤¦§Ø©*M"Q_2_EMP_BANK_SHORT_NAME"DECODE ( : P_LANG_CODE , 'ENG' , A.BANK_SHORT_NAME , A.BANK_BL_SHORT_NAME )Q_2_EMP_BANK_SHORT_NAME _Ir’’’’a p p5pATUV0W0X Z\]^_*O"Q_2_EMP_BANK_ADD_1"A.BANK_ADD1Q_2_EMP_BANK_ADD_1,Ial’’’’a p p5pATUV0W0X Z\]^_*Q"Q_2_EMP_BANK_ADD_2"A.BANK_ADD2Q_2_EMP_BANK_ADD_2,Ial’’’’a p p5pATUV0W0X Z\]^_*S"Q_2_EMP_BANK_ADD_3"A.BANK_ADD3Q_2_EMP_BANK_ADD_3,Ial’’’’_ p p4pASTU0V0W XZ[\]*Ō"Q_2_EMP_CURR_CODE"FP_CURR_CODEQ_2_EMP_CURR_CODE Ir’’’’‡ p p/pn{|}0~0 €‚ƒ„…-t"Q_2_EMP_NAME"DECODE ( : P_LANG_CODE , 'ENG' , EMP_LONG_NAME , EMP_BL_NAME )Q_2_EMP_NAME <I’’’’B &p(,-˜.p2p2p223486888:8<>?@ņQ_1$B+0aff’’’’B &p(,-˜.p2p2p223486888:8<>?@IQ_2*%oE/dV’’’’} FpHLMN PRS0TUV0WXY0Z[\]^xb8b8d8f8h jlpmpmpqqprp{{GóG_1 ņ EM52H 0y?G_1LIST_G_1al’’’’„ FpHXYZ \ ^`0abc0def0ghijkxn8n@r8v8x z|p}p}ppŽp££VJG_EMP_SAL_LEVEL-I*9GiVČD9Ž.˜€G_EMP_SAL_LEVELLIST_G_EMP_SAL_LEVELPQ’’’’Ø FpHZ[\ ^`a0bcd0efg0hijklxr8r8t8v8xz{p|p|pŽŽpp¦¦p@*,G_COMP_BANK_LEVEL+IGVihŹ0®:öIšG_COMP_BANK_LEVELLIST_G_COMP_BANK_LEVEL’’’’§ FpHYZ[ \ ^`0abc0def0ghijkxn8n@r8v8x z|p}p}pŽŽpp„„*9G_EMP_BANK_LEVEL,I*,Gk3G„„6«9ˆ€G_EMP_BANK_LEVELLIST_G_EMP_BANK_LEVELr’’’’£/bpclmnopqprrpspwwxyz{0|0}0~00€0p‚‚ƒ„…†‡ˆp‰p‰‰Š‹Œpp’’“”•p–pŸŸ ”YPRINTJOBHYesP€LISPRINTJOB’’’’Ÿ/bpchijklmpnnpopwwxyz{0|0}0~00€0p‚‚ƒ„…†‡ˆp‰p‰‰Š‹Œpp’’“”•p–p››œZMODEGDefaultP€LISMODE&’’’’­/bpcnopqrspvvpwpzz{|}~00€00‚0ƒ0„pŠŠ‹ŒŽp‘p‘‘’“”p•pšš›œpžp©©Ŗ«[BACKGROUNDFtNoP€MODEBACKGROUND’’’’²/bpcopqrstpzzp{pƒƒ„…†‡0ˆ0‰0Š0‹0Œ0pŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p®®Æ°\ORIENTATIONENoDefaultP€ORIENTATION’’’’¢/bpcklmnoppvvpwpwwxyz{0|0}0~00€0p‚‚ƒ„…†‡ˆp‰p‰‰Š‹Œpp’’“”•p–pžžŸ ]DECIMALD€DECIMALan’’’’¤/bpcmnopqrpvvpwpwwxyz{0|0}0~00€0p‚‚ƒ„…†‡ˆp‰p‰‰Š‹Œpp’’“”•p–p  ”¢^THOUSANDSC€THOUSANDS’’’’£/bpclmnopqprrpspsstu vx0y0z0{0|0}0~p‚‚ƒ„…†‡ˆp‰p‰‰Š‹Œpp’’“”•p–pŸŸ ”_CURRENCYB€CURRENCY’’’’”/bpcjklmnoprrpspuuvwxy0z0{0|0}0~0p‚‚ƒ„…†‡ˆp‰p‰‰Š‹Œpp’’“”•p–pžŸ`COPIESA1€COPIES100’’’’°/bpcmnopqrpvvpwp||}~ €‚0ƒ0„0…0†0‡0ˆpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p¬¬­®aDESFORMAT@dflt€ESDESFORMAT’’’’¦/bpcklmnoppvvpwpwwxy z|0}0~00€00‚p††‡ˆ‰Š‹ŒppŽp‘p––—˜™pšp¢¢£¤bDESNAME?DESNAME’’’’’’®/bpcklmnoppvvpwp~~€‚0ƒ0„0…0†0‡0ˆpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢pŖŖ«¬cDESTYPE>ScreenPDESNDESTYPEb7’’’’·/bpctuvwxypzzp{p{{|}~0€00‚0ƒ0„@ŠpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p³³“µ“P_BASE_NO_OF_DECI DESNP_BASE_NO_OF_DECg25b88€@ą’’’’,00x $ & (*C r75g25b88Ą@ą0800Ø4`p1DE€’’’’¤r’’’’µ/bpcnopqrspvvpwp‚‚ƒ„…†0‡0ˆ0‰0Š0‹0Œp’’“”•–—˜p™p™™š›œpp¢¢£¤„p¦p±±²³”P_TITLE_11JI1234567891< uP_TITLE_11_CU’’’’±/bpcnopqrspvvpwp‚ƒ„…0†0‡0ˆ0‰0Š0‹pŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p­­®Æ•P_TITLE_12KI134226327Č P_TITLE_12ECT’’’’±/bpcnopqrspvvpwp‚ƒ„…0†0‡0ˆ0‰0Š0‹pŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p­­®Æ–P_TITLE_13LI434143834 P_TITLE_13' M’’’’±/bpcnopqrspvvpwp‚ƒ„…0†0‡0ˆ0‰0Š0‹pŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p­­®Æ—P_TITLE_14MI252183989 P_TITLE_14, ’’’’µ/bpcnopqrspvvpwp‚‚ƒ„…†0‡0ˆ0‰0Š0‹0Œp’’“”•–—˜p™p™™š›œpp¢¢£¤„p¦p±±²³˜P_TITLE_21NI3467321874 P_TITLE_21C-8’’’’„/bpcnopqrspvvpwpwwxyz{0|0}0~00€0p‚‚ƒ„…†‡ˆp‰p‰‰Š‹Œpp’’“”•p–p””¢£™P_TITLE_23OIČ P_TITLE_23ER(’’’’±/bpcnopqrspvvpwp‚ƒ„…0†0‡0ˆ0‰0Š0‹pŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p­­®ÆšP_TITLE_24PI122133266 TLE_P_TITLE_24 ’’’’„/bpcnopqrspvvpwpwwxyz{0|0}0~00€0p‚‚ƒ„…†‡ˆp‰p‰‰Š‹Œpp’’“”•p–p””¢£›P_TITLE_31QIČ P_TITLE_31ion’’’’§/bpclmnopqprrpspxxyz{|0}0~00€00‚p††‡ˆ‰Š‹ŒppŽp‘p––—˜™pšp££¤„œR_KEY_NOR2526 R_KEY_NO0’’’’®/bpcopqrstpzzp{p€‚ƒ0„0…0†0‡0ˆ0‰pŠŠ‹ŒŽp‘p‘‘’“”p•pšš›œpžpŖŖ«¬P_LANG_CODES6ENG( #P_LANG_CODE:C’’’’Č/ bpdrstuvwpzzp{p{{|}~0€00‚0ƒ8„8†pˆ(ž¢£ ¤¦§Øp©p©©Ŗ«¬p­p²²³“µp¶pÄÄÅĘ­CP_END_OF_REPPUfCp End Of Report€:'1CP_END_OF_REP’’’’©/ bpdopqrstpzzp{p{{|}~0€00‚0ƒ0„0…p††‡ˆ‰Š‹ŒppŽp‘p––—˜™pšp„„¦§±P_TITLE_33TČ RepoP_TITLE_33’’’’©/ bpdopqrstpzzp{p{{|}~0€00‚0ƒ0„0…p††‡ˆ‰Š‹ŒppŽp‘p––—˜™pšp„„¦§ŗP_TITLE_32UČ RepoP_TITLE_32’’’’Ć/ bpdqrstuvpzzp{p€‚ƒ0„0…0†8ˆ8Š8ŒpŽ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pææĄĮÅCP_COMP_CODE001P¹DfCp Cmp Cd€'CP_COMP_CODEE’’’’Ä/ bpdrstuvwpzzp{p{{|}~0€08‚0„8†8ˆpŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pĄĄĮĀ7CP_COMP_ADD_1PVUfCp Comp Add 1€G'CP_COMP_ADD_1’’’’Ä/ bpdrstuvwpzzp{p{{|}~0€08‚8„8†8ˆpŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pĄĄĮĀ8CP_COMP_ADD_2P«™fCp Comp Add 2€H'CP_COMP_ADD_2’’’’Ä/ bpdrstuvwpzzp{p{{|}~0€08‚8„8†8ˆpŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pĄĄĮĀ9CP_COMP_ADD_3P« «™fCp Comp Add 3€ 'CP_COMP_ADD_3’’’’·/ bpdmnopqrpvvpwpwwxyz{0|0}8~8€8‚8„p†(’–— ˜š›œppžŸ p”p¦¦§Ø©pŖp³³“µ:CP_CR_DT ««™fCp Cr Dtmp † F'CP_CR_DT®’’’’æ/ bpdqrstuvpzzp{p{{|}~0€08‚8„8†8ˆpŠ(–š› œžŸ p”p””¢£¤p„pŖŖ«¬­p®p»»¼½„CP_BANK_NAMEPźZ˜™fCp Adp Dt€›'CP_BANK_NAME’’’’Ä/ bpdrstuvwpzzp{p{{|}~0€08‚8„8†8ˆpŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pĄĄĮĀ…CP_BANK_ADDR1Pźa=™fCp Adp Txn Code€`'CP_BANK_ADDR1DESNDESTYPEb7’’’’·/bpctuvwxypzzp{p{{|}~0€00‚0ƒ0„@ŠpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p³³“µ“P_BASE_NO_OF_DECI DESNP_BASE_NO_OF_DECg25b88€@ą’’’’,00x $ & (*C r75g25b88Ą@ą0800Ø4`p1DE’’’’ür’’’’Ä/ bpdrstuvwpzzp{p{{|}~0€08‚8„8†8ˆpŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pĄĄĮĀ‡CP_BANK_ADDR2Pdh™fCp Adp Ref From€\'CP_BANK_ADDR2’’’’¾/ bpdpqrstupvvpwpwwxyz{0|0}@~8‚8„8†pˆ(–š› œžŸ p”p””¢£¤p„pŖŖ«¬­p®pŗŗ»¼ˆCP_EMP_NAME P„ŗG«™fCp Adp Amd No€U'CP_EMP_NAMEs’’’’Ń/ bpdstuvwxp~~pp€‚ƒ0„0…@†8Š8Œ8Žp(¦Ŗ« ¬®Æ°p±p±±²³“pµpŗŗ»¼½p¾pĶĶĪĻ‰CP_FP_PROC_MTH PPÅ»GU™fCp Adp Amd Res Code€V'AMECP_FP_PROC_MTH‹pŽ’’’’Ä/ bpdrstuvwpzzp{p{{|}~0€0@‚8†8ˆ8ŠpŒ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pĄĄĮĀCP_BANK_NAME1 P„»N]™f Adp Emp Code€”'V'CP_BANK_NAME1’’’’Č/ bpdrstuvwpzzp{p{{|}~0€0@‚8†8ˆ8ŠpŒ(ž¢£ ¤¦§Øp©p©©Ŗ«¬p­p²²³“µp¶pÄÄÅĘ’CP_BANKC_CODE P„»[«™fCp Adp From Dt€Z'CP_BANKC_CODE’’’’į/ bpd€‚ƒ„pŠŠp‹p‹‹ŒŽ00‘@’8–8˜8špœ(Ŗ®Æ °²³“pµpµµ¶·øp¹p¾¾æĄĮpĀpŻŻŽß•CP_BANKC_GL_MAIN_ACNT_CODE «[™P„»bS™fCp Adp Ref No€'ANKCCP_BANKC_GL_MAIN_ACNT_CODE’’’’Ī/ bpdtuvwxypzzp{p{{|}~0€0@‚8†8ˆ8ŠpŒ(¢¦§ ØŖ«¬p­p­­®Æ°p±p¶¶·ø¹pŗpŹŹĖĢ–CP_FP_LC_AMOUNTP„ŗh’™fCp Adp Ref Txn Codedp€]'CP_FP_LC_AMOUNT’’’’’’Ļ/ bpduvwxyzp~~pp€‚ƒ0„0…@†8Š8Œ8Žp(¢¦§ ØŖ«¬p­p­­®Æ°p±p¶¶·ø¹pŗpĖĖĢĶ—CP_BANKC_ACNT_NOP„»p™fCp Adp Remarksdp€^'CP_BANKC_ACNT_NO„’’’’¼/ bpdnopqrspvvpwpwwxyz{0|0}0~8€8‚8„p†(–š› œžŸ p”p””¢£¤p„pŖŖ«¬­p®pøø¹ŗėCP_FM_EMPPU U™fCp From Dtp Adp† N'^'CP_FM_EMP’’’’ø/ bpdnopqrspvvpwpwwxyz{0|0}0~8€8‚8„p†(’–— ˜š›œppžŸ p”p¦¦§Ø©pŖp““µ¶ģCP_TO_EMPPU«™fCp To Dttp† O'CP_TO_EMP’’’’Å/ bpdopqrstpzzp{p{{|}~0€00‚8„8†8ˆpŠ(ž¢£ ¤¦§Øp©p©©Ŗ«¬p­p²²³“µp¶pĮĮĀĆķCP_FM_DIVNPU™fCp From Txn Code€J'O_EMCP_FM_DIVNŠ‹’’’’Å/ bpdopqrstpzzp{p{{|}~0€00‚8„8†8ˆpŠ(ž¢£ ¤¦§Øp©p©©Ŗ«¬p­p²²³“µp¶pĮĮĀĆīCP_TO_DIVNPU ™fCp To Txn Codee€K'O_EMCP_TO_DIVN±p²’’’’Į/ bpdopqrstpzzp{p{{|}~0€08‚8„8†8ˆpŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²p½½¾æļCP_FM_DEPTP«U™fCp From Noodee€L'CP_FM_DEPT±p²’’’’½/ bpdopqrstpzzp{p{{|}~0€08‚8„8†8ˆpŠ(–š› œžŸ p”p””¢£¤p„pŖŖ«¬­p®p¹¹ŗ»šCP_TO_DEPTP«"™fCp To Nooo€M'CP_TO_DEPTÆ°’’’’Ć/ bpdqrstuvpzzp{p{{|}~0€00‚8„8†8ˆpŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pææĄĮmCP_TITLE_11APU&U™fCp Title 11a€t'CP_TITLE_11A°’’’’Ć/ bpdqrstuvpzzp{p{{|}~0€08‚8„8†8ˆpŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pææĄĮyCP_BASE_CURRP@Sé™fCp Base Curr€'CP_BASE_CURRØ’’’’Ä/ bpdrstuvwpzzp{p{{|}~0€08‚8„8†8ˆpŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pĄĄĮĀzCF_LOCAL_CURR@M<™fCf Local Curr @'CF_LOCAL_CURR’’’’®/ bpdlmnopqprrpspsstuvw0x0y8z8|8~8€p‚(ŠŽ ’“”p•p••–—˜p™pžžŸ ”p¢pŖŖ«¬„CP_DEDNP«(«™fCp Dedn€v'@ CP_DEDN®’’’’Į/ bpdopqrstpzzp{p{{|}~0€08‚0„8†8ˆpŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²p½½¾æÕCP_FM_LOCNPP5YXD™fCp From Locn€~'CP_FM_LOCNŠpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p³³“µ“P_BASE_NO_OF_DECI DESNP_BASE_NO_OF_DECg25b88€@ą’’’’,00x $ & (*C r75g25b88Ą@ą0800Ø4`p1DE ’’’’°r’’’’Į/ bpdopqrstpzzp{p{{|}~0€08‚8„8†8ˆpŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²p½½¾æÖCP_TO_LOCNPP5UU™fCp To Locnn€'CP_TO_LOCNd’’’’»/ bpdmnopqrpvvpwpwwxyz{0|0}8~8€8‚8„p†(–š› œžŸ p”p””¢£¤p„pŖŖ«¬­p®p··ø¹×CP_FM_CCP5U «™fCp From Ccocnn€€'CP_FM_CCN’’’’·/ bpdmnopqrpvvpwpwwxyz{0|0}8~8€8‚8„p†(’–— ˜š›œppžŸ p”p¦¦§Ø©pŖp³³“µŲCP_TO_CCP5U™fCp To Ccco€'CP_TO_CC’’’’’Ź/ bpdtuvwxypzzp{p{{|}~0€08‚8„8†8ˆpŠ(ž¢£ ¤¦§Øp©p©©Ŗ«¬p­p²²³“µp¶pĘĘĒČŁCP_FM_CONT_TYPE P5T«™fCp From Cont Type€‚'O_CCCP_FM_CONT_TYPE’’’’’’Ę/ bpdtuvwxypzzp{p{{|}~0€08‚8„8†8ˆpŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pĀĀĆÄŚCP_TO_CONT_TYPE!P5U U™fCp To Cont Type€ƒ'CP_TO_CONT_TYPEEM’’’’¾/ bpdpqrstupvvpwpwwxyz{0|0}8~8€8‚8„p†(–š› œžŸ p”p””¢£¤p„pŖŖ«¬­p®pŗŗ»¼ŻCP_FM_CNTRY"PO« U™fCp From Cntry T€†'CP_FM_CNTRYLD’’’’ŗ/ bpdpqrstupvvpwpwwxyz{0|0}8~8€8‚8„p†(’–— ˜š›œppžŸ p”p¦¦§Ø©pŖp¶¶·øŽCP_TO_CNTRY#PO««™fCp To Cntry€‡'CP_TO_CNTRY’’’’Ä/ bpdrstuvwpzzp{p{{|}~0€0@‚8†8ˆ8ŠpŒ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pĄĄĮĀCP_PROC_MONTH$P„»xX™fCp Proc Month€Š'CP_TCP_PROC_MONTH’’’’Ę/ bpdpqrstupvvpwpwwxyz{0|0}@~8‚8„8†pˆ(ž¢£ ¤¦§Øp©p©©Ŗ«¬p­p²²³“µp¶pĀĀĆÄ‚CP_EMP_CODE%P„»U™fCp Empy Pay Mode€€‹'CP_EMP_CODEM_’’’’Č/ bpdrstuvwpzzp{p{{|}~0€08‚8„8†8ˆpŠ(ž¢£ ¤¦§Øp©p©©Ŗ«¬p­p²²³“µp¶pÄÄÅĘƒCP_BANK_ADDR3&P»n«™fCp Empy Pay Type€Œ'CP_BANK_ADDR3’’’’Į/ bpdopqrstpzzp{p{{|}~0€08‚8„8†8ˆpŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²p½½¾æŽCP_M_CPMTH'PO«U™fCp M Cpmth Type€'CP_M_CPMTH’’’’Į/ bpdopqrstpzzp{p{{|}~0€08‚8„8†8ˆpŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²p½½¾æžCP_EARNING(PO«!™fCp Earning Type€”'CP_EARNING’’’’Ć/ bpdqrstuvpzzp{p{{|}~0€08‚8„8†8ˆpŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pææĄĮŸCP_DEDUCTION)PO«'U™fCp Deductionype€“'CP_DEDUCTION’’’’Č/ bpdst vx z|p‚‚pƒpƒƒ„…†‡0ˆ0‰0Š0‹0Œ0pŽ(ž¢£ ¤¦§Øp©p©©Ŗ«¬p­p²²³“µp¶pÄÄÅĘ>Q_1_BANK_NAME1ó?PQ 1 Bank Name“ą'Q_1_BANK_NAME’’’’Ä/ bpdrs tv xzp~~pp€‚ƒ0„0…0†0‡0ˆ0‰pŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pĄĄĮĀ@Q_1_BANK_ADD4óAQ 1 Bank Add1am“ą'Q_1_BANK_ADD1’’’’Ä/ bpdrs tv xzp~~pp€‚ƒ0„0…0†0‡0ˆ0‰pŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pĄĄĮĀBQ_1_BANK_ADD1óCQ 1 Bank Add2am“ą'Q_1_BANK_ADD2’’’’Ä/ bpdrs tv xzp~~pp€‚ƒ0„0…0†0‡0ˆ0‰pŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pĄĄĮĀDQ_1_BANK_ADD2óEQ 1 Bank Add3am“ą'Q_1_BANK_ADD3’’’’Ä/ bpdst vx z|p‚‚pƒpƒƒ„…†‡0ˆ0‰0Š0‹0Œ0pŽ œžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pĄĄĮĀaQ_1_BANK_CODE1óbQ 1 Bank Codeź`'Q_1_BANK_CODE’’’’¢/ bpdlmnopqprrpspsstuvw0x0y8z8|8~8€p‚‚ƒ„…†‡ˆp‰p‰‰Š‹Œpp’’“”•p–pžžŸ õCP_BANK.P0O«¬™fšQ 1 CP_BANKPP5YXD™fCp From Locn€~'CP_FM_LOCNŠpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p³³“µ“P_BASE_NO_OF_DECI DESNP_BASE_NO_OF_DECg25b88€@ą’’’’,00x $ & (*C r75g25b88Ą@ą0800Ø4`p1DE°’’’’r’’’’°/ bpdrstuvwpzzp{p{{|}~0€08‚8„8†8ˆpŠŠ‹ŒŽp‘p‘‘’“”p•pšš›œpžp¬¬­®CP_BANK_AC_NO/P0GX™fCP_BCP_BANK_AC_NO’’’’Į/ bpdwxyz{|p‚‚pƒpƒƒ„…†‡0ˆ0‰@Š8Ž88’p––—˜™š›œppžŸ p”p¦¦§Ø©pŖp½½¾æ9CP_BANK_SHORT_NAME0P0P0„«@U™f «œANK_CP_BANK_SHORT_NAME’’’’«/ bpdmnopqrpvvpwpwwxyz{0|0}@~8‚8„8†pŠŠ‹ŒŽp‘p‘‘’“”p•pšš›œpžp§§Ø©!żCP_TOTAL1MEP0¦U™fœCP_TOTAL’’’’É/ bpdtu vx z|p‚‚pƒpƒƒ„…†‡0ˆ0‰0Š0‹0Œ0pŽ(ž¢£ ¤¦§Øp©p©©Ŗ«¬p­p²²³“µp¶pÅÅĘĒ(Q_1_BANKC_ACNT1ó(¦Q 1 Bankc Acnt1† 'ANK_Q_1_BANKC_ACNT_CC’’’’±/ bpdklmnoppvvpwp‡‡ˆ‰Š‹0Œ00Ž000‘p’’“”•–—˜p™p™™š›œpp¢¢£¤„p¦p­­®Æ(3P_desgV1General Manager  †P_DESGpe’’’’½/ bpdxy z| ~€p††p‡p‡‡ˆ‰Š‹0Œ00Ž000‘p’’“”•–—˜p™p™™š›œpp¢¢£¤„p¦p¹¹ŗ»(6Q_2_EMPY_BANK_CODE1*9l(7ager! †Q_2_EMPY_BANK_CODEntr’’’’­/ bpdopqrstpzzp{p{{|}~0€08‚8„8†8ˆpŠŠ‹ŒŽp‘p‘‘’“”p•pšš›œpžp©©Ŗ«(…CF_COMPANY21(0xy™™fCF_COMPANY««’’’’Ģ/ bpdst vx z|p‚‚pƒpƒƒ„…†‡0ˆ0‰0Š0‹0Œ0pŽ(¢¦§ ØŖ«¬p­p­­®Æ°p±p¶¶·ø¹pŗpČČÉŹ(‘Q_1_COMP_CODE1ó(’(0 Q 1 Comp Code1CF_C† 'K_COQ_1_COMP_CODE’’’’§/ bpdmnopqrpvvpwpwwxyz{0|0}0~8€8‚8„p††‡ˆ‰Š‹ŒppŽp‘p––—˜™pšp££¤„(ÉCF_CPMTH3 030?¼«CompCF_CPMTH’’’’Č/ bpd{| ~€ ‚„pŠŠp‹p‹‹Œ Ž0‘0’0“0”0•0–pšš›œžŸ p”p””¢£¤p„pŖŖ«¬­p®pÄÄÅĘ)ļQ_2_EMPY_BANK_REMARKS1J?)šŠ!'Q_2_EMPY_BANK_REMARKS’’’’“/ bpdst vx z|p‚‚pƒpƒƒ„…†‡0ˆ0‰0Š0‹0Œ0pŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p°°±²*"Q_2_EMPY_CODE1AJ1*#J?!ØQ_2_EMPY_CODE’’’’Ń/ bpdxy z| ~€p††p‡p‡‡ˆ‰Š‹0Œ00Ž000‘p’ ¦Ø© Ŗ¬­®pÆpÆÆ°±²p³p¶¶·ø¹pŗpĶĶĪĻ*(Q_2_COMP_BANK_CODE1*,*)Q 2 Comp Bank Code1ź`¦'PYQ_2_COMP_BANK_CODE(’’’’ä/ bpd{| ~€ ‚„pŠŠp‹p‹‹ŒŽ00‘0’0“0”0•p–(²¶· øŗ»¼p½p½½¾æĄpĮpĘĘĒČÉpŹpąąįā**Q_2_COMP_BANK_ACNT_NO1*,*+Q 2 Comp Bank Acnt No1† '_BANQ_2_COMP_BANK_ACNT_NO’’’’·/ bpdvw xz |~p‚‚pƒpƒƒ„…†‡0ˆ0‰0Š0‹0Œ0pŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p³³“µ*-Q_2_FP_FC_AMOUNT1J*.!&¢CompQ_2_FP_FC_AMOUNT’’’’Õ/ bpdxy z| ~€p††p‡p‡‡ˆ‰Š‹0Œ00Ž000‘p’(¦Ŗ« ¬®Æ°p±p±±²³“pµpŗŗ»¼½p¾pŃŃŅÓ*@Q_2_COMP_BANK_NAME1*,**AQ 2 Comp Bank Name1† ''Q_2_COMP_BANK_NAMEAdd’’’’ē/ bpd~ €‚ „†pŠŠp‹p‹‹ŒŽ00‘0’0“0”0•p–(²¶· øŗ»¼p½p½½¾æĄpĮpĘĘĒČÉpŹpććäå*BQ_2_COMP_BANK_SHORT_NAME1*,*CQ 2 Comp Bank Short Name1† 'COMPQ_2_COMP_BANK_SHORT_NAMEK’’’’Ö/ bpdxy z| ~€p††p‡p‡‡ˆ‰Š‹0Œ00Ž000‘p’(¦Ŗ« ¬®Æ°p±p±±²³“pµpŗŗ»¼½p¾pŅŅÓŌ*DQ_2_COMP_BANK_ADD_4*,*EC*Q 2 Comp Bank Add 4† ''Q_2_COMP_BANK_ADD_1pd’’’’Ö/ bpdxy z| ~€p††p‡p‡‡ˆ‰Š‹0Œ00Ž000‘p’(¦Ŗ« ¬®Æ°p±p±±²³“pµpŗŗ»¼½p¾pŅŅÓŌ*FQ_2_COMP_BANK_ADD_1*,*GC*Q 2 Comp Bank Add 1† ''Q_2_COMP_BANK_ADD_2ps’’’’Ö/ bpdxy z| ~€p††p‡p‡‡ˆ‰Š‹0Œ00Ž000‘p’(¦Ŗ« ¬®Æ°p±p±±²³“pµpŗŗ»¼½p¾pŅŅÓŌ*HQ_2_COMP_BANK_ADD_2*,*IC*Q 2 Comp Bank Add 2† ''Q_2_COMP_BANK_ADD_3‘’“”p•p••–—˜p™pžžŸ ”p¢p³³“µ“P_BASE_NO_OF_DECI DESNP_BASE_NO_OF_DECg25b88€@ą’’’’,00x $ & (*C r75g25b88Ą@ą0800Ø4`p1DEĄ’’’’ōr’’’’¼/ bpdwx z| ~€p††p‡p‡‡ˆ‰Š‹0Œ00Ž000‘p’’“”•–—˜p™p™™š›œpp¢¢£¤„p¦pøø¹ŗ*JQ_2_EMP_BANK_NAME1*9*KC*!k AdQ_2_EMP_BANK_NAME’’’’Ę/ bpd}~ €‚ „†pŠŠp‹p‹‹ŒŽ00‘0’0“0”0•p––—˜™š›œppžŸ p”p¦¦§Ø©pŖpĀĀĆÄ*LQ_2_EMP_BANK_SHORT_NAME1**9*M!Q_2_EMP_BANK_SHORT_NAME I’’’’½/ bpdwx z| ~€p††p‡p‡‡ˆ‰Š‹0Œ00Ž000‘p’’“”•–—˜p™p™™š›œpp¢¢£¤„p¦p¹¹ŗ»*NQ_2_EMP_BANK_ADD_4M*9*OM*!Q_2_EMP_BANK_ADD_1Ķ«Ķ’’’’½/ bpdwx z| ~€p††p‡p‡‡ˆ‰Š‹0Œ00Ž000‘p’’“”•–—˜p™p™™š›œpp¢¢£¤„p¦p¹¹ŗ»*PQ_2_EMP_BANK_ADD_1M*9*QM*!Q_2_EMP_BANK_ADD_2’’’’½/ bpdwx z| ~€p††p‡p‡‡ˆ‰Š‹0Œ00Ž000‘p’’“”•–—˜p™p™™š›œpp¢¢£¤„p¦p¹¹ŗ»*RQ_2_EMP_BANK_ADD_2M*9*SM*!Q_2_EMP_BANK_ADD_3’’’’ø/ bpdvw xz |~p‚‚pƒpƒƒ„…†‡0ˆ0‰0Š0‹0Œ0pŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p““µ¶*ŅCS_EMP_BANK_TOTAL*9**-((&¤CS_EMP_BANK_TOTAL’’’’¼/ bpdwx z| ~€p††p‡p‡‡ˆ‰Š‹0Œ00Ž000‘p’’“”•–—˜p™p™™š›œpp¢¢£¤„p¦pøø¹ŗ*ÓQ_2_EMP_CURR_CODE1*J**Ō !£Q_2_EMP_CURR_CODE’’’’Õ/ bpdwx z| ~€p† †pˆpˆˆ‰Š‹Œ00Ž000‘0’p“(¦Ŗ« ¬®Æ°p±p±±²³“pµpŗŗ»¼½p¾pŃŃŅÓ*ęCS_COMP_BANK_TOTAL**,**-*,(&Cs Comp Bank Total_„'ECS_COMP_BANK_TOTAL’’’’Ę/ bpdtu vxyzp~~pp€‚ƒ0„0…0†0‡0ˆ0‰pŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pĀĀĆÄ+xCF_AMT_IN_WORDS*,*śCf Amt In Words† '„'CF_AMT_IN_WORDSp„’’’’¦/ bpdpqrstupvvpwpwwxyz{0|0}0~00€0p‚‚ƒ„…†‡ˆp‰p‰‰Š‹Œpp’’“”•p–p¢¢£¤+zP_CURR_CODEW §mt IP_CURR_CODE0Œ’’’’Å/ bpd{|}~€p††p‡p‡‡ˆ‰Š‹0Œ08Ž88’8”p––—˜™š›œppžŸ p”p¦¦§Ø©pŖpĮĮĀĆ+łCP_FROM_COMP_BANK_CODE4§ 0U/¼™f©CP_FROM_COMP_BANK_CODE®pÆ’’’’æ/ bpdyz{|}~p‚‚pƒpƒƒ„…†‡0ˆ0‰8Š8Œ8Ž8p’’“”•–—˜p™p™™š›œpp¢¢£¤„p¦p»»¼½+śCP_TO_COMP_BANK_CODE5 03/¼™fŖCP_TO_COMP_BANK_CODE”’’’’°/ bpdrstuvwpzzp{p{{|}~0€08‚8„8†8ˆpŠŠ‹ŒŽp‘p‘‘’“”p•pšš›œpžp¬¬­®+ūCP_VALUE_DATE6 0U6«™f«CP_VALUE_DATE’’’’Ŗ/ bpdpqrstupvvpwpwwxyz{0|0}8~8€8‚8„p††‡ˆ‰Š‹ŒppŽp‘p––—˜™pšp¦¦§Ø+üCP_VALUE_DT7 0w6«™fCP_VALUE_DT_F’’’’±/ bpdopqrstpzzp{p{{|}~0€0@‚8†8ˆ8ŠpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p­­®Æ,ÉCF_BRACKET82 ¼««™fCP_VCF_BRACKETe1’’’’¶/ bpdtuvwxypzzp{p{{|}~0€0@‚8†8ˆ8ŠpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p²²³“,ĖCP_OPEN_BRACKET92 ĻU,«™fć¬CP_VCP_OPEN_BRACKET*C’’’’»/ bpduvwxyzp~~pp€‚ƒ0„0…@†8Š8Œ8Žp’’“”•–—˜p™p™™š›œpp¢¢£¤„p¦p··ø¹,ĢCP_CLOSE_BRACKET:2 Ō6U™fp’­CP_CLOSE_BRACKET¾’’’’­/ bpdopqrstpzzp{p{{|} ~€00‚0ƒ0„0…0†pŠŠ‹ŒŽp‘p‘‘’“”p•pšš›œpžp©©Ŗ«,ēP_TITLE_34X:Š ®P_TITLE_34‘p’’’’’³/ bpdqr tvwxp~~pp€ ‚„0…0†0‡0ˆ0‰0ŠpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢pÆÆ°±-LCF_BANK_DTLSJŠ CF_BANK_DTLS|’’’’±/ bpdopqrstpzzp{p€€‚ƒ„0…0†0‡0ˆ0‰0ŠpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p­­®Æ-SP_TITLE_35YBankš P_TITLE_35OMP_BANK_ADD_3‘’“”p•p••–—˜p™pžžŸ ”p¢p³³“µ“P_BASE_NO_OF_DECI DESNP_BASE_NO_OF_DECg25b88€@ą’’’’,00x $ & (*C r75g25b88Ą@ą0800Ø4`p1DEŠ’’’’pr’’’’”/ bpdklmnoppvvpwpwwxyz{0|0}0~00€0p‚‚ƒ„…†‡ˆp‰p‰‰Š‹Œpp’’“”•p–pžŸ-rP_DATEZš ÆP_DATE®’’’’Ć/ bpdqr tv xzp~~pp€‚ƒ0„0…0†0‡0ˆ0‰pŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pææĄĮ-sQ_2_EMP_NAMEJ-t <Q 2 Emp Name_DA† '35Q_2_EMP_NAMEC’’’’§/ bpdijkl nppvvpwpwwxyz{0|0}8~@‚8†8ˆpŠŠ‹ŒŽp‘p‘‘’“”p•pšš›œpžp££¤„-€CS_1;A*-J(&/D(žU!«f±_DACS_1R’’’’£/ bpdijklmnprrpspsstuvw0x0y8z@~8‚8„p††‡ˆ‰Š‹ŒppŽp‘p––—˜™pšpŸŸ ”-†CF_1<(&«›©U™f²CF_1A’’’’–/ bpdhijklmpnnpopoopqrs0t0u0v0w0x0ypzz{|}~€pp‚ƒ„p…pŠŠ‹ŒpŽp’’“”-‡P_1[( °²P_1™’’’’¹/ bpdopqrstpzzp{pˆˆ‰Š‹Œ00Ž000‘0’p––—˜™š›œppžŸ p”p¦¦§Ø©pŖpµµ¶·-‰P_TITLE_36\Total Amountš P_TITLE_36”p•’’’’Ÿ/ bpdij ln prpvvpwpwwxyz{0|0}0~00€0p‚‚ƒ„…†‡ˆp‰p‰‰Š‹Œpp’’“”•p–p››œ-CS_2_*9-s(&“CS_2Ž’’’’“/ bpdrstuvwpzzp{p{{|} ~€00‚8„@†8Š8ŒpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p°°±²-’CF_AMTINWORDS=Š&“U¼«*fCF_AMTINWORDS’’’’Ÿ/ bpdij lnoppvvpwpwwxyz{0|0}0~00€0p‚‚ƒ„…†‡ˆp‰p‰‰Š‹Œpp’’“”•p–p››œ-•CF_2N*9= CF_2_’’’’–/ bpdhijklmpnnpopoopqrs0t0u0v0w0x0ypzz{|}~€pp‚ƒ„p…pŠŠ‹ŒpŽp’’“”-–P_2] ³P_2’’’’­/ bpdopqrstpzzp{p€‚ƒ0„0…0†0‡0ˆ0‰pŠŠ‹ŒŽp‘p‘‘’“”p•pšš›œpžp©©Ŗ«-āP_TITLE_37^AED CF_2P_TITLE_37CODEW §mt IP_CURR_CODE0Œ’’’’Å/ bpd{|}~€p††p‡p‡‡ˆ‰Š‹0Œ08Ž88’8”p––—˜™š›œppžŸ p”p¦¦§Ø©pŖpĮĮĀĆ+łCP_FROM_COMP_BANK_CODE4§ 0U/¼™f©CP_FROM_COMP_BANK_CODE®pÆ’’’’æ/ bpdyz{|}~p‚‚pƒpƒƒ„…†‡0ˆ0‰8Š8Œ8Ž8p’’“”•–—˜p™p™™š›œpp¢¢£¤„p¦p»»¼½+śCP_TO_COMP_BANK_CODE5 03/¼™fŖCP_TO_COMP_BANK_CODE”’’’’°/ bpdrstuvwpzzp{p{{|}~0€08‚8„8†8ˆpŠŠ‹ŒŽp‘p‘‘’“”p•pšš›œpžp¬¬­®+ūCP_VALUE_DATE6 0U6«™f«CP_VALUE_DATE’’’’Ŗ/ bpdpqrstupvvpwpwwxyz{0|0}8~8€8‚8„p††‡ˆ‰Š‹ŒppŽp‘p––—˜™pšp¦¦§Ø+üCP_VALUE_DT7 0w6«™fCP_VALUE_DT_F’’’’±/ bpdopqrstpzzp{p{{|}~0€0@‚8†8ˆ8ŠpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p­­®Æ,ÉCF_BRACKET82 ¼««™fCP_VCF_BRACKETe1’’’’¶/ bpdtuvwxypzzp{p{{|}~0€0@‚8†8ˆ8ŠpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p²²³“,ĖCP_OPEN_BRACKET92 ĻU,«™fć¬CP_VCP_OPEN_BRACKET*C’’’’»/ bpduvwxyzp~~pp€‚ƒ0„0…@†8Š8Œ8Žp’’“”•–—˜p™p™™š›œpp¢¢£¤„p¦p··ø¹,ĢCP_CLOSE_BRACKET:2 Ō6U™fp’­CP_CLOSE_BRACKET¾’’’’­/ bpdopqrstpzzp{p{{|} ~€00‚0ƒ0„0…0†pŠŠ‹ŒŽp‘p‘‘’“”p•pšš›œpžp©©Ŗ«,ēP_TITLE_34X:Š ®P_TITLE_34‘p’’’’’³/ bpdqr tvwxp~~pp€ ‚„0…0†0‡0ˆ0‰0ŠpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢pÆÆ°±-LCF_BANK_DTLSJŠ CF_BANK_DTLS|’’’’±/ bpdopqrstpzzp{p€€‚ƒ„0…0†0‡0ˆ0‰0ŠpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p­­®Æ-SP_TITLE_35YBankš P_TITLE_35OMP_BANK_ADD_3‘’“”p•p••–—˜p™pžžŸ ”p¢p³³“µ“P_BASE_NO_OF_DECI DESNP_BASE_NO_OF_DECg25b88€@ą’’’’,00x $ & (*C r75g25b88Ą@ą0800Ø4`p1DEą’’’’čr’’’’† BpD VX(^pbpb8b8d@f@jn prs0t0u0v0w0x0yz0{0|}~€‚ƒ„-1R_EMP_BANK_LEVEL1YP*ā0žTäĮ¬*9’’’’r BpD HJ LpNpN8N@R@V8Z\]^_0`0a0b0c0d0ef0g0hijklmnop-iM_1YAäžÕUā-V’°’’’’v BpD HJ(NpRpR8R@V@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrst-ŠM_3Y$A  öĆ«écZ’j’’’’r BpD HJ(NpRpR8R8T@V8Z\]^_0`0a0b0c0d0ef0g0hijklmnop-źM_4YA  ķ`Wćø ’D(’’’’Ž# JpL `b(fpjpj8j8l8n8prstuv xz{|0}0~0p€p‚0‚ƒ„…†‡ˆ‰Š‹ŒjF_1_COMP_BANK_NAME.. »eJŽV*@’’’’’–# JpL TV(Zp^p^@^8b8d8fhijkl npqr0s0t0upvpŠ0Š‹ŒŽ‘’“”(1F_dateP.NK_ ·—F@mż-r ’MONTH DD, YYYY’’’’’Ž# JpL `b(fpjpj8j8l8n8prstuv xz{|0}0~0p€p‚0‚ƒ„…†‡ˆ‰Š‹Œ*WF_1_COMP_BANK_ADD1·(m@ »»JŻVO*D’YØ’’’’Ž# JpL `b(fpjpj8j8l8n8prstuv xz{|0}0~0p€p‚0‚ƒ„…†‡ˆ‰Š‹Œ*YF_1_COMP_BANK_ADD2·(m@ » JŽVO*F’Y0~’’’’Ž# JpL `b(fpjpj8j8l8n8prstuv xz{|0}0~0p€p‚0‚ƒ„…†‡ˆ‰Š‹Œ*ZF_1_COMP_BANK_ADD3·(m@ $»%fJŽVO*H’Yp{’’’’Ž# JpL `b(fpjpj8j8l8n8prstuv xz{|0}0~0p€p‚0‚ƒ„…†‡ˆ‰Š‹Œ*dF_1_COMP_BANK_Ac_no-p m@ $nĻ™%¼O**’YRD’’’’†# JpL VX(^pbpb8b8d8f8hjklmn prst0u0v0wpxpz0z{|}~€‚ƒ„+ F_TITLE_1+n,_Ac_n02Ģ¶x)V%9D’*’’’’’†# JpL VX(^pbpb8b8d8f8hjklmn prst0u0v0wpxpz0z{|}~€‚ƒ„+F_TITLE_2+n+_Ac_n02Ģ`x)V%8D’*’]’’’’†# JpL VX(^pbpb8b8d8f8hjklmn prst0u0v0wpxpz0z{|}~€‚ƒ„+F_TITLE_3+n*_Ac_n02Ģ x)V%7D’*’pž’’’’†# JpL VX(^pbpb8b8d8f8hjklmn prst0u0v0wpxpz0z{|}~€‚ƒ„+F_TITLE_4+n)_Ac_n02Ģ “x)V%mD’*’0Œ’’’’~# JpL PR(VpZpZ8Z8\@^8bdefgh jlmn0o0p0qprpr0rstuvwxyz{|,čF_1. _4  ,™AĮįU,ē’4’’’’Ž# JpL ^`(fpjpj@j8n8p8rtuvwx z|}~00€0p‚p‚0‚ƒ„…†‡ˆ‰Š‹Œ-F_BANKC_ACNT_NO1A-pU0¼ŒQt ©—’™’’’’Š# JpL \^(bpfpf@f8j8l8npqrst vxyz0{0|0}p~p~0~€‚ƒ„…†‡ˆ-F_FP_FC_AMOUNT1-p-0Ž Qt‡g– ’w’’’’†# JpL XZ(^pbpb8b8d8f8hjklmn prst0u0v0wpxpz0z{|}~€‚ƒ„-F_EMP_NAME1-pp-0\Qt,Lˆ’ ’’’’Ž# JpL `b(fpjpj@j8n8p8rtuvwx z|}~00€0p‚p‚0‚ƒ„…†‡ˆ‰Š‹Œ-F_2_BANKC_ACNT_NO1(ĘtQ  ¼ŒY ·g )ļ’’’’’Ž# JpL ^`(fpjpj@j8n8p8rtuvwx z|}~00€0p‚p‚0‚ƒ„…†‡ˆ‰Š‹Œ-F_2_FP_FC_AMOUNT1(Ę(tQ0Ž Y‡g *- ’Æ’’’’Š# JpL Z\(bpfpf8f8h8j8lnopqr tvwx0y0z0{p|p~0~€‚ƒ„…†‡ˆ-F_2_EMP_NAME1(ĘĘ((0 \YC<g-s’ ‘’’’’Š# JpL Z\(bpfpf8f8h8j8lnopqr tvwx0y0z0{p|p~0~€‚ƒ„…†‡ˆ-NF_2_EMP_NAME2(ĘĘ((0 _/Y]g-L’ x’’’’†# JpL XZ(^pbpb8b8d8f8hjklmn prst0u0v0wpxpz0z{|}~€‚ƒ„-PF_EMP_NAME2-p(0_/QU,L-S’’’’’–# JpL PR(VpZpZ@Z8^8`8bdefgh jlmn0o0p0qprpŠ0Š‹ŒŽ‘’“”-F_2. AME0 Ī—bV+°Ø-† ’99,999,999,999,999.99’’’’Š# JpL Z\(bpfpf8f8h8j8lnopqr tvwx0y0z0{p|p~0~€‚ƒ„…†‡ˆ-ŠF_2_EMP_NAME3.Vb°+0 ĄbV,ƒg9-‰’9ž’’’’~# JpL PR(VpZpZ8Z8\8^8`bcdef hjkl0m0n0opppr0rstuvwxyz{|-F_3-p_NA $vé ’ «-• ’’’’’‚# JpL PR(VpZpZ8Z@^@b8fhijkl npqr0s0t0upvpv0vwxyz{|}~€-ĢF_4-p&_NA0FÅfÜ«-’’TITLE_35OMP_BANK_ADD_3‘’“”p•p••–—˜p™pžžŸ ”p¢p³³“µ“P_BASE_NO_OF_DECI DESNP_BASE_NO_OF_DECg25b88€@ą’’’’,00x $ & (*C r75g25b88Ą@ą0800Ø4`p1DEš’’’’r’’’’Š# JpL Z\(bpfpf@f8j8l8npqrst vxyz0{0|0}p~p~0~€‚ƒ„…†‡ˆ-ćF_2_EMP_NAME4.' fÅ0 ³bVVg’-ā ’’’’’’’~# JpL PR(VpZpZ8Z8\8^8`bcdef hjkl0m0n0opppr0rstuvwxyz{|.zF_5.v(_NA «:U Ŗ³.G ’J(NpRpR8R@V@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrst-ŠM_3Y$A  öĆ«écZ’j’’’’r BpD HJ(NpRpR8R8T@V8Z\]^_0`0a0b0c0d0ef0g0hijklmnop-źM_4YA  ķ`Wćø ’D(’’’’Ž# JpL `b(fpjpj8j8l8n8prstuv xz{|0}0~0p€p‚0‚ƒ„…†‡ˆ‰Š‹ŒjF_1_COMP_BANK_NAME.. »eJŽV*@’’’’’–# JpL TV(Zp^p^@^8b8d8fhijkl npqr0s0t0upvpŠ0Š‹ŒŽ‘’“”(1F_dateP.NK_ ·—F@mż-r ’MONTH DD, YYYY’’’’’Ž# JpL `b(fpjpj8j8l8n8prstuv xz{|0}0~0p€p‚0‚ƒ„…†‡ˆ‰Š‹Œ*WF_1_COMP_BANK_ADD1·(m@ »»JŻVO*D’YØ’’’’Ž# JpL `b(fpjpj8j8l8n8prstuv xz{|0}0~0p€p‚0‚ƒ„…†‡ˆ‰Š‹Œ*YF_1_COMP_BANK_ADD2·(m@ » JŽVO*F’Y0~’’’’Ž# JpL `b(fpjpj8j8l8n8prstuv xz{|0}0~0p€p‚0‚ƒ„…†‡ˆ‰Š‹Œ*ZF_1_COMP_BANK_ADD3·(m@ $»%fJŽVO*H’Yp{’’’’Ž# JpL `b(fpjpj8j8l8n8prstuv xz{|0}0~0p€p‚0‚ƒ„…†‡ˆ‰Š‹Œ*dF_1_COMP_BANK_Ac_no-p m@ $nĻ™%¼O**’YRD’’’’†# JpL VX(^pbpb8b8d8f8hjklmn prst0u0v0wpxpz0z{|}~€‚ƒ„+ F_TITLE_1+n,_Ac_n02Ģ¶x)V%9D’*’’’’’†# JpL VX(^pbpb8b8d8f8hjklmn prst0u0v0wpxpz0z{|}~€‚ƒ„+F_TITLE_2+n+_Ac_n02Ģ`x)V%8D’*’]’’’’†# JpL VX(^pbpb8b8d8f8hjklmn prst0u0v0wpxpz0z{|}~€‚ƒ„+F_TITLE_3+n*_Ac_n02Ģ x)V%7D’*’pž’’’’†# JpL VX(^pbpb8b8d8f8hjklmn prst0u0v0wpxpz0z{|}~€‚ƒ„+F_TITLE_4+n)_Ac_n02Ģ “x)V%mD’*’0Œ’’’’~# JpL PR(VpZpZ8Z8\@^8bdefgh jlmn0o0p0qprpr0rstuvwxyz{|,čF_1. _4  ,™AĮįU,ē’4’’’’Ž# JpL ^`(fpjpj@j8n8p8rtuvwx z|}~00€0p‚p‚0‚ƒ„…†‡ˆ‰Š‹Œ-F_BANKC_ACNT_NO1A-pU0¼ŒQt ©—’™’’’’Š# JpL \^(bpfpf@f8j8l8npqrst vxyz0{0|0}p~p~0~€‚ƒ„…†‡ˆ-F_FP_FC_AMOUNT1-p-0Ž Qt‡g– ’w’’’’†# JpL XZ(^pbpb8b8d8f8hjklmn prst0u0v0wpxpz0z{|}~€‚ƒ„-F_EMP_NAME1-pp-0\Qt,Lˆ’ ’’’’Ž# JpL `b(fpjpj@j8n8p8rtuvwx z|}~00€0p‚p‚0‚ƒ„…†‡ˆ‰Š‹Œ-F_2_BANKC_ACNT_NO1(ĘtQ  ¼ŒY ·g )ļ’’’’’Ž# JpL ^`(fpjpj@j8n8p8rtuvwx z|}~00€0p‚p‚0‚ƒ„…†‡ˆ‰Š‹Œ-F_2_FP_FC_AMOUNT1(Ę(tQ0Ž Y‡g *- ’Æ’’’’Š# JpL Z\(bpfpf8f8h8j8lnopqr tvwx0y0z0{p|p~0~€‚ƒ„…†‡ˆ-F_2_EMP_NAME1(ĘĘ((0 \YC<g-s’ ‘’’’’Š# JpL Z\(bpfpf8f8h8j8lnopqr tvwx0y0z0{p|p~0~€‚ƒ„…†‡ˆ-NF_2_EMP_NAME2(ĘĘ((0 _/Y]g-L’ x’’’’†# JpL XZ(^pbpb8b8d8f8hjklmn prst0u0v0wpxpz0z{|}~€‚ƒ„-PF_EMP_NAME2-p(0_/QU,L-S’’’’’–# JpL PR(VpZpZ@Z8^8`8bdefgh jlmn0o0p0qprpŠ0Š‹ŒŽ‘’“”-F_2. AME0 Ī—bV+°Ø-† ’99,999,999,999,999.99’’’’Š# JpL Z\(bpfpf8f8h8j8lnopqr tvwx0y0z0{p|p~0~€‚ƒ„…†‡ˆ-ŠF_2_EMP_NAME3.Vb°+0 ĄbV,ƒg9-‰’9ž’’’’~# JpL PR(VpZpZ8Z8\8^8`bcdef hjkl0m0n0opppr0rstuvwxyz{|-F_3-p_NA $vé ’ «-• ’’’’’‚# JpL PR(VpZpZ8Z@^@b8fhijkl npqr0s0t0upvpv0vwxyz{|}~€-ĢF_4-p&_NA0FÅfÜ«-’’TITLE_35OMP_BANK_ADD_3‘’“”p•p••–—˜p™pžžŸ ”p¢p³³“µ“P_BASE_NO_OF_DECI DESNP_BASE_NO_OF_DECg25b88€@ą’’’’,00x $ & (*C r75g25b88Ą@ą0800Ø4`p1DE’’’Ōl1 °$"fĻ BEFOREREPORT function BeforeReport return boolean is LOGO_YN VARCHAR2(1); M_DT_FMT_MASK VARCHAR2(60); CR_UPD_DT VARCHAR2(20); F_DT VARCHAR2(20); T_DT VARCHAR2(20); HRS_DAY VARCHAR2(1); M_CURR_CODE PW_FS.CURR_CODE%TYPE ; CURSOR C_1 IS SELECT REP_VALUE_1, REP_VALUE_2, REP_VALUE_16, REP_VALUE_17, REP_VALUE_8, REP_VALUE_9, REP_VALUE_10, REP_VALUE_11, REP_VALUE_12, REP_VALUE_13, REP_VALUE_14, REP_VALUE_15, REP_VALUE_21, REP_VALUE_22, REP_VALUE_7, REP_VALUE_3, REP_VALUE_4 , REP_VALUE_5 , REP_VALUE_20 FROM PAY_REP_INFO WHERE REP_KEY_NO = :R_KEY_NO; CURSOR C1 IS SELECT GPARA_VALUE FROM PM_GUI_PARAMETER WHERE GPARA_CODE = 'REF_DT_FMT'; CURSOR C_COMP IS SELECT DECODE(:P_LANG_CODE,'ENG',COMP_ADD_1,COMP_BL_ADD_1), DECODE(:P_LANG_CODE,'ENG',COMP_ADD_2,COMP_BL_ADD_2), DECODE(:P_LANG_CODE,'ENG',COMP_ADD_3,COMP_BL_ADD_3) FROM FM_COMPANY WHERE COMP_CODE = :CP_COMP_CODE; CURSOR B1 IS SELECT PARA_VALUE FROM PM_COMP_PARAMETER WHERE PARA_CODE = 'CPMTH' AND PARA_COMP_CODE = :CP_COMP_CODE; -- commented an added by Yasharth on 18/10/2006 fo issue AJMALINT-129377 /* CURSOR C_GET_BANK_CURRENCY IS SELECT NVL(SUBSTR(BANK_CODE,4),'*') FROM PM_BANK WHERE BANK_CODE = :CP_FROM_COMP_BANK_CODE ;*/ CURSOR C_GET_BANK_CURRENCY IS SELECT PARA_VALUE FROM PM_PARAMETER WHERE PARA_CODE='BASECURR'; M_NOTE VARCHAR2(240); BEGIN STD_PRE_REPORT; OPEN C_1; FETCH C_1 INTO :CP_FM_EMP, :CP_TO_EMP, :CP_FM_CONT_TYPE, :CP_TO_CONT_TYPE, :CP_FM_DIVN, :CP_TO_DIVN, :CP_FM_DEPT, :CP_TO_DEPT, :CP_FM_LOCN, :CP_TO_LOCN, :CP_FM_CC, :CP_TO_CC, :CP_FM_CNTRY, :CP_TO_CNTRY, LOGO_YN, :CP_FROM_COMP_BANK_CODE , :CP_TO_COMP_BANK_CODE , :CP_VALUE_DATE , :CP_COMP_CODE; CLOSE C_1; OPEN C1; FETCH C1 INTO M_DT_FMT_MASK; CLOSE C1; IF NVL(LOGO_YN,'N') = 'Y' THEN OPEN C_COMP; FETCH C_COMP INTO :CP_COMP_ADD_1, :CP_COMP_ADD_2, :CP_COMP_ADD_3; IF C_COMP%NOTFOUND THEN :CP_COMP_ADD_1 := NULL; :CP_COMP_ADD_2 := NULL; :CP_COMP_ADD_3 := NULL; END IF; CLOSE C_COMP; END IF; IF NVL(LOGO_YN,'N') = 'Y' THEN :CP_TITLE_11A := :P_TITLE_11; ELSE :CP_TITLE_11A := NULL; END IF; OPEN B1; FETCH B1 INTO :CP_M_CPMTH; CLOSE B1; IF C_GET_BANK_CURRENCY%ISOPEN THEN CLOSE C_GET_BANK_CURRENCY ; END IF; OPEN C_GET_BANK_CURRENCY ; FETCH C_GET_BANK_CURRENCY INTO M_CURR_CODE ; CLOSE C_GET_BANK_CURRENCY ; :P_CURR_CODE := M_CURR_CODE ; M_NOTE := TO_CHAR(TO_DATE(:CP_VALUE_DATE),'MONTH YYYY'); :P_TITLE_34 := 'Salary Transfer for the Month of'||' '||M_NOTE ; SELECT INITCAP(TO_CHAR(TO_DATE(:CP_VALUE_DATE),'MONTH DD, YYYY')) INTO :P_DATE FROM DUAL; LOAD_BP; RETURN (TRUE); END; YĶ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«ĶwÄ SYSSTANDARD PW_FS xj  PAYUSERPW_FSxj  (PAYUSER PAY_REP_INFOxj   PAYUSERPM_GUI_PARAMETERxj 1-PAYUSER FM_COMPANYxj 2 ORION_LIVE FM_COMPANYxj  %PAYUSERPM_COMP_PARAMETERxj   PAYUSER PM_PARAMETER/LInsrepplSTD_PRE_REPORT“p <<PAYUSERDUAL xj  (PUBLICDUALxj  (SYSDUAL/Namespace0003/LOAD_BP$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08(ÉÉ!<µ"PKG INIT"BEFOREREPORT"LOGO_YN"M_DT_FMT_MASK"CR_UPD_DT"F_DT"T_DT"HRS_DAY"M_CURR_CODE"C_1""REP_VALUE_1"REP_VALUE_2"REP_VALUE_16"REP_VALUE_17"REP_VALUE_8"REP_VALUE_9"REP_VALUE_10"REP_VALUE_11"REP_VALUE_12"REP_VALUE_13"REP_VALUE_14"REP_VALUE_15"REP_VALUE_21"REP_VALUE_22"REP_VALUE_7"REP_VALUE_3"REP_VALUE_4"REP_VALUE_5"RE’’’ŌlP_VALUE_20"C1"GPARA_VALUE"C_COMP"DECODE"B1"PARA_VALUE"C_GET_BANK_CURRENCY"M_NOTE"""ā#&'-017:;ADEKNOUXY_bckqsy|}ƒ†‡‘—š›”¤„«®Ƶø¹æĀĆÉĢĶÓÖׯąįēźėńōõūž’ #&'-019?AGJKSY[adjmsv~„†Œ˜ž ¦©Ŗ°³“ŗ¼ĀÅĒÉĖĶĻŃÓÕףŪŻßįćåēéėķļńóõ÷łūż’   %-Ƶ  ¶ <·ø¹ŗ »! Ä $¼ &›('< *œ,+<.0/<2ž43<6Ÿ87<: <;<>”@?<B¢DC<F £HG<J ¤LK<N „PO<R ¦TS<V §XW<ZØ\[<^©`_<bŖdc<f«hg<j¬lk<n­po<Ås½ u®wv!Ę!z ¾"|Æ}"°€"‚±ƒ#Ē#† æ$ˆ²Š‰%Č% Ą!$³‘P&“ Į•”š'— Ā#™“š<<<x<“<š<,<h<¤<ą<<X<”<Š< <H<„<Ą<ü<8<PH\p„˜¬ĄŌÜäģōü"#)LjKµ*ß%)-159=AEIMQUY]aeimt{~‡Ž˜"qx„‹ #ry…Œ’–’’$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08EwČČČČ’ žp’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’eedAAeedAAeedAAeedAAeedAAeedAAee‹yys ƒ‹CKS[cks{«³;#+£ ų $ ec+kec3sec;{ $# $ $ $ eedAA $eŁ $eŁ eŗ Y eźeźeļeŗ Y   eeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeA‰‰‘‘IIQQYYaaiiqqyy±±¹¹AA!!))11©©AA‹e!!AA‹eAA‹eAA‹eeeeeeeAA‹e))AA‹e!!AA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eeeæ"FUNCTION"BEFOREREPORT"RETURN"BOOLEAN"LOGO_YN"VARCHAR2"1"M_DT_FMT_MASK"60"CR_UPD_DT"20"F_DT"T_DT"HRS_DAY"M_CURR_CODE"PW_FS"CURR_CODE"TYPE"CURSOR"C_1"REP_VALUE_1"REP_VALUE_2"REP_VALUE_16"REP_VALUE_17"REP_VALUE_8"REP_VALUE_9"REP_VALUE_10"REP_VALUE_11"REP_VALUE_12"REP_VALUE_13"REP_VALUE_14"REP_VALUE_15"REP_VALUE_21"REP_VALUE_22"REP_VALUE_7"REP_VALUE_3"REP_VALUE_4"REP_VALUE_5"REP ’’’Ōl_VALUE_20"PAY_REP_INFO"REP_KEY_NO"R_KEY_NO""="C1"GPARA_VALUE"PM_GUI_PARAMETER"GPARA_CODE"REF_DT_FMT"C_COMP"DECODE"P_LANG_CODE"ENG"COMP_ADD_1"COMP_BL_ADD_1"COMP_ADD_2"COMP_BL_ADD_2"COMP_ADD_3"COMP_BL_ADD_3"FM_COMPANY"COMP_CODE"CP_COMP_CODE"B1"PARA_VALUE"PM_COMP_PARAMETER"PARA_CODE"CPMTH"PARA_COMP_CODE"C_GET_BANK_CURRENCY"PM_PARAMETER"BASECURR"M_NOTE"240"STD_PRE_REPORT"OPEN"CP_FM_EMP"CP_TO_EMP"CP_FM_CONT_TYPE"CP_TO_CONT_TYPE"CP_FM_DIVN"CP_TO_DIVN"CP_FM_DEPT"CP_TO_DEPT"CP_FM_LOCN"CP_TO_LOCN"CP_FM_CC"CP_TO_CC"CP_FM_CNTRY"CP_TO_CNTRY"CP_FROM_COMP_BANK_CODE"CP_TO_COMP_BANK_CODE"CP_VALUE_DATE"CLOSE"NVL"N"Y"CP_COMP_ADD_1"CP_COMP_ADD_2"CP_COMP_ADD_3"NOTFOUND"CP_TITLE_11A"P_TITLE_11"CP_M_CPMTH"ISOPEN"P_CURR_CODE"TO_CHAR"TO_DATE"MONTH YYYY"P_TITLE_34"Salary Transfer for the Month of"||" "INITCAP"MONTH DD, YYYY"P_DATE"DUAL"LOAD_BP"TRUE""0 #$(359:AIMPSWX_gknquv}…‰Œ“”›£§Ŗ­±²¹ĮÅČĖĻŠ×ßćęéķīõż $()468=CGHLPTX\`dhlptx|€„ˆŒ”›œ „©Ŗ®µ¶ŗæĪŅÓŽąāēķńņöżž  .23>@BGMQRW[\chlpuyz†ŠŽ“—˜Ÿ¤Ø¬³“ø½ĮĀĘĶĪŅ×ęźėöųś’  $()-27;<@GHLQ`deprtyƒ„ˆ”™ž¢§Ø¬°±øĄÄĒŹĢŃÕÖŪßćäéķńõü &-4;BIPW[bipw|~‚‡‹•™”„Ŗ¬°³·¼ĄĮĘŹĖĻŌŁŪąäčéīņöś"$(/04;<@GHMOSVZ_cdimnrw|~‚‰”–š”¢§«Æ°µ¹½ĮČĶĻÓÖŚŽāęčķļóųü !%,048=@AFIJQVZafjkptuzƒˆŽ’“˜œ¢„¦«®Æ¶»ĀĆĒČÉŠÕŁŚŽįåēėķōū %,3:AHOV]dkry€‡Ž•œ£Ŗ±øĄČĢĻŅŚŽįäģšóöž"&),48;>FJMPX\_bjnqt|€ƒ†Ž’•˜ ¤§Ŗ²¶¹¼ÄČĖĪÖŚŻąčģļņśž      " % ( 0 4 7 : B F I L T X [ ^ f j m p x |  ‚ Š Ž ‘ ” œ   £ ¦ ® ² µ ø ¹ Į Å Ę Ķ Ń Ņ Ł Ż Ž å é ź ń õ ö ż       ! % & - 1 2 9 = > E I J Q U V ] a b i m n u y z  … †  ‘ ’ ™  ž „ Ø « ³ “ ¼ Ą Į Č É Ģ Ļ × Ų Ū Ž ę ē ź ķ õ ö ž        " % ( 0 1 2 : > ? F I L T U ] a b i j k l o r z { ~  ‰ Š ‹ Ž ‘ ™ š    Ø © Ŗ « ¬ Æ ² ŗ » ¾ Į É Ģ Ļ × Ų Ł Ś Ż ą č é ź ņ ö ÷ ž h,“ ±°£ cQ°£ cQ°£ cQ°£ cQ°£ cQ°£ cQ°£k   ½ōČ“±·é劬                   ī² .|“ ¼¬¤½ōČ“±·é劬 ī² .|“ n¬¤½ōČ“±·é劬. „¼n  . „¼n  . „¼n  ī² .|“ ¼¬¤½ōČ“±·é劬 ī² .|“ n .|“ ¼¬¤½ōČ“±·é劬 ī² .|“ n¬¤°£ cQ·W ³éŻ ³éÓ ¼¼¼¼¼¼¼¼¼¼¼¼¼¼ ¼¼¼¼éĮ éŻ ³éÓ  éĮ <.|“. „ nn·éŻ ³éÓ ¼¼¼<  · ¼M ¼M ¼MéĮ <.|“. „ nn· ¼¼· ¼M鯠³éÓ ¼éĮ <  ·éĮ éŻ ³éÓ  éĮ  ¼   .Ÿ„.Ÿ„¼n ¼.|“.|“nn é劬. „.Ÿ„.Ÿ„¼nī² ¬²¼W ³eZ O¤µóóóóóóóóóóóóóóóóóóóóóóóóóóóóóücQücQücQücQücQücQücQücQücQücQücQücQücQücQücQücQücQücQücQücQücQücQücQücQücQücQücQücQ¬`°£°£°£°£°£°£°£°£°£°£°£°£°£°£°£°£°£°£°£Qc¬`°£¬Qc¬Qc¬Qc¬`°£°£°£Qc¬¬`°£Qc¬`°£¬¬¬Qc¬Qc¬¬Qc¬Qc¬¬¬¬Qc¬QcQc¬¬¬Qc¬¬`°£¬   !!!"""""""#####!0’’’Ōl+++++++,,,,,---.....-+//////13335555666666666777778888899::;;;====>>>>???AAAAAAAAAAAABBBBCCCCCCCDDDDDDEEEFFFGGGIIILLLLLLLLLLLLMMMNNOOORRRRSSSSTTTVVVVVVWWWZZZZ[[[[\\\^^^__________aaaaaaaaaaacccccccccccccccccccccdddeeef16666677777888899:CCCMMS^ac"#.35=AABLLRZ__aacccd  " " ""  ,:H,:,         $/ $/$*5             #/AS -:G)7    !  *:    !      %   & "2<79> %5ZUZUM #/AS -:G)*: M     —ż’€ ߟ  €€€€€ €€ € € €<    € €€€ € "  "!#$€€$€%€ €')  )"*+€€+€,€ €.0 0#12€€2€3€€57 7$8 €!€"€9<#€:;$€%€&€>?A ?A>%’@BCd>=AAECF0G[!'€(€)€*€+€,€-€.€/€0€1€ 2€!3€"4€#5€$6€%7€&8€'9€\^cA5(:€_`;€/,<€7)=€*+¾”Afgi -gif&’hjkzfei:imknnoq<.>€rtyi>/?€uv@€m,A€@0B€1l1i|} 2}|'’~€¤|{Cƒ„…›E‡ˆC€v3D€I4+æ#¢5u56E€7F€ŽG€z3H€N4æ#¢5y58I€9J€•–K€~3L€S4æ#¢5}5:M€;N€œž£X<O€Ÿ P€r,Q€Z=R€>+Ć£¦§© ?§©¦(’ØŖ«Į¦„©]©­«®ŽƱ_@S€²“Ą©aAT€µŗ»U€¶·V€Œ,W€c@’’’ŌlBX€C‹C¼½Y€,Z€fD[€>Ć£©ĆÄĘ EÄĘĆ)’ÅĒČ×ĆĀĘiĘŹČĖ–ĢĪk@\€ĻŃÖĘmF]€ŅÓ^€•,_€oB`€G”GĘŁŪ rHŪ*ÜŻa€b€Żc€Žd€Ie€štįāšßJf€äßåę›>čßéź>ŒL+ĒN¤M+ĖO„N+Ļ‚¦O+Óƒ§P+×JØQ+ŪK©R+ßLŖS+ćM«T+ē~¬U+ė­V+ļ€®W+óÆX+÷†°Y+ū‡± Z+’©²[+Ŗ³\+«“>Ć£’ß>ßœ-fß-f  ß -f¢ß g€¤,h€¤i€ ^j€§ _Ÿ_`£`Ŗ„2| 2|Æa+ Gµb+H¶c+ ·³&)$'(k€2|dµ%+,)a Gµ./)bH¶12)c ·4 52|¹ ß8A69:l€­,m€¼<=n€©^o€æ _Ø_`¬`Ā7CD Ae+tøf+u¹F6ÄEHIFetøKßLM®?¦OßPQ?¦Ęg+ŗTßU?¦ČßX[VYZp€EĆhŹW][^EĆ`ßabÆEĆdßefEĆĢ6ißjEĆlmßi+#§»6opßHŚqrq€“jr€Ītus€°kt€Ń\«“l³lyzßm+'®¼{|u€¼ov€Ó~w€»ox€Ön·npŗpHŚ„߅–Ɔ’Łˆ‰y€Āqz€Ū‹Œ{€Įj|€ŻŽ}€½k~€ą\«“rĄr“•āt€äs++ƽ™šĒßu€€œߝ€v‚€*+¾4+æ#>+ĆL+ĒNM+ĖON+Ļ‚O+ÓƒP+×JQ+ŪK R+ßL S+ćM T+ē~ U+ė V+ļ€W+óX+÷†Y+ū‡Z+’©[+Ŗ\+«a+ Gb+Hc+ e+tf+ug+i+#§m+'®s++ƃ€„€…€†€ĮĄĀ‡€(ˆ€‰€ÅÄĘŠ€P‹€Œ€ÉČŹ€PŽ€€ĶĢĪ€P‘€’€ŃŠŅ“€P”€•€ÕŌÖ–€P—€˜€ŁŲŚ™€Pš€›€ŻÜŽœ€P€ž€įąāŸ€P €”€åäę¢€P£€¤€éčź„€P¦€§€ķģī؀P©€Ŗ€ńšņ«€P¬€­€õōö®€Pƀ°€łųś±€P²€³€żüž“€Pµ€¶€·€ ø€¹€ŗ€ »€¼€  ½€ ¾€æ€  Ą€PĮ€Ā€ƀPĀŀʀPĒ€Č€ɀPŹ€Ė€Ģ€<Ķ€Ī€! "Ļ€PŠ€Ń€%$&Ņ€ ӀŌ€)(*ՀŠր׀-,.Ų€šś-E2Ł€ųŚ€€H05Ū€ö܀€I08Ż€ōŽ€€J0;߀ņą€€K0>į€šā€€L0Ać€ī䀀M0Då€ģꀀN0Gē€źč€€O0Jé€čź€ €P0Mė€ęģ€ €Q 0Pķ€ī€ €R 0Sļ€ š€ €S 0Vń€!ņ€ €T 0Yó€!"ō€€U 0\õ€##ö€€V0_÷€%$ų€€W0bł€'%ś€€X0eū€)&ü€€Y0hż€+'ž€€Z01’€ jkkAFmpD.€pnH5sttK5 w x  xP5 {||U` ƒZ3†„\3‡^3”P’’’Ō lC‰ŠŠdgl ­j@€°ŽG’“ “ns Ź˜!q@"€Ķ–_#$ž%&žu`'”(¢)*¢x_+¦,§-.§{`/Ŗ0«12«~l3 ±4²56²ƒn7 µ8¶9:¶p;ø<¹=>¹†‰Œr?¾@æABæŽ‘• „ÅC“D‡Ć &-4=e{„ĀŲ !(/6DHIJKLMNOPQRSTUVWXYZ]ablpswx‚†”‰Š‹Œ‘’“—˜™š”¢¬°³ø¹¾æÉĶŠŌÕŚąćēž  6JNSV_chknxƒ˜›žėģķīļšńņóōõö÷ųłśūüż $3!"#%*-07E;@>?BGRW\gswv}‚€‡Š‘z”—NKHEB?<963ab”¢£¤„¦§Ø©Ŗ«¬­®Æ°±²³“µ¶·ø¹ŗ»¼½QTWZ]`cfi147:=@CFILORUX[^adgwxqo”¢‰Š‹Œ‘’“—˜™š‚…ˆ€ƒ†ø¹¾æ‘ŌÕ™—>?;@vsw€}‚‘ŠĘÄDl‚¬Éƒ¾’’Dd °’’­’’£’’>”’’EH/KiNWQZ¤’’T9<Ʊ’’³’’½’’36«’’`c™ ‘ f‚ … ˆ ]?qB»’’¬’’|®’’©’’ø’’²’’!Ś“’’6(Ŗ’’ŗ’’¢’’¦’’¦f¹’’µ’’¶’’Æ’’·’’„’’Ø’’¼’’ §’’«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0€ žžT€#Ljµß2 ”ä' $ # wŌ@wŌTwŌhwŌ|wŌwŌ¤wŌøwŌĢwŌąwŌ ōwŌ wŌ wŌ 0wŌ DwŌwŌ$wŌ8wŌLwŌ,uŌė@ŪN@TŪOThŪ‚h|Ūƒ|ŪJ¤ŪK¤øŪLøĢŪMĢąŪ~ąōŪōŪ€Ū0Ū†0DŪ‡DH$$XŪ©X88lŪŖlLL€Ū«€,Ū,sŌ#ywÜ\uÜ \sÜ&'H„Ó’`` $C`„¦ ›#>wä”wäØwä¼uä-”ŪG”ØŪHؼŪ ¼yä< 3t”ŪG”ˆØŪHØœ¼Ū ¼sä&'H„Ó’°° $C°„. #ŚuääŠŪtŠÄŠŪtŠ#’wģųuģųŪųsģxō  sō#‚wōŲuōŲŲĄsōĄ Ū§ Ś«€*€1„0ģģü;„H„` ; ü  Ū® q„{xŠw4׫tą‚4ŪÆ4'$„x% hg! r„{t,ghŌ×ghŌtghŌ €! r„{tšghÜtghÜ €! r„{x$ghä×ghä#×ghä#×ghä#×ghätghä €! r„ {xhghģ×ghģtghģ €! r„{xœghōtghō €!’Ų&ģ``````h:=tDÜ<<<<<<<<<<<<<<<<<<<šh:= $h:=<Thh:= €ˆœh:=P“¼PŠh:=čš( BEFOREREPORTNY MONTH YYYY Salary Transfer for the Month of [*H|ˆ*\ŒŌ<*pŲų*„ü*˜ @*¬DP*ĄTl  *Ōpt *Üx| *䀄 *ģˆŒ *ō”*ü˜”š*˜ą<*$ä,<*80x<*L|Ä<Ŗ`ČĢŃ*tŠÜ*ˆąģ`’’’Ō l*œšüŖ°Ń*Ä*ŲtPŖģx| *€ˆ *Œ(0(4h(…(,lČ…(@Ģ(N…(T,ˆO…(hŒč‚…(|ģHƒ…(LØJ…(¤¬K…(ø hL…(ĢlČM…(ąĢ(~…(ō,ˆ…*Œč€…*ģH …*0L Ø †…*D¬  ‡…*X ©…*l$ 8 Ŗ…*€< P «…*”T ° G…*Ø“  H…*¼ p  …*Št Š t*äŌ  <…*ų | …* € ˜ §…* œ x®…*4|xÆ356Ī;Ó=Ł>ń?öA,B2C€DEžF­G¼IĮL÷MO#R)SITNVXW]Zc[‚\‡^–_µa×c def+ =T=r=½ =ē,=SELECT REP_VALUE_1,REP_VALUE_2,REP_VALUE_16,REP_VALUE_17,REP_VALUE_8,REP_VALUE_9,REP_VALUE_10,REP_VALUE_11,REP_VALUE_12,REP_VALUE_13,REP_VALUE_14,REP_VALUE_15,REP_VALUE_21,REP_VALUE_22,REP_VALUE_7,REP_VALUE_3,REP_VALUE_4,REP_VALUE_5,REP_VALUE_20 FROM PAY_REP_INFO WHERE REP_KEY_NO = :b1"SELECT GPARA_VALUE FROM PM_GUI_PARAMETER WHERE GPARA_CODE = ''REF_DT_FMT''"SELECT DECODE(:b1,''ENG'',COMP_ADD_1,COMP_BL_ADD_1),DECODE(:b1,''ENG'',COMP_ADD_2,COMP_BL_ADD_2),DECODE(:b1,''ENG'',COMP_ADD_3,COMP_BL_ADD_3) FROM FM_COMPANY WHERE COMP_CODE = :b4"SELECT PARA_VALUE FROM PM_COMP_PARAMETER WHERE PARA_CODE = ''CPMTH'' AND PARA_COMP_CODE = :b1"SELECT PARA_VALUE FROM PM_PARAMETER WHERE PARA_CODE = ''BASECURR''"SELECT INITCAP(TO_CHAR(TO_DATE(:b1),''MONTH DD, YYYY'')) FROM DUAL"T(<D0L H\ `„xŒ#NO‚ƒJKLM~€†‡©Ŗ«GH tu§®Æ@@bwgrwindowrwbwctwindowrwbwcrwindow1rwbwaswindow rwbwrpwindow rwbwddwindow  rwbwipwindowrwbwoowindowOMrwbmxwindowLJrwbwsqwindow(&rwbwcdwindow!rwbwlovwindowrwbwdswindow-rwbwrowindow rwbwrnwindow  rwbwidwindowrwbwrrwindowrwbwnewindow rwbmfimenu-+rrwbwvpudpmenu†„out_search_toolmenuƒrwbmnrbtbtoolbarWU.rwbmntdmtbtoolbarRP rwbmndmtbtoolbarQOrwbf_lp_dfltFontsGErwbfd_hintFontsCArwbf_groupFonts?=rwbf_summaryFonts=;rwbf_parameterFonts;9Fieldsboxµ³Databox“² Typebox²°Sectionsbox±ÆTemplatesbox°®FinishedQueryboxئrwwt_Expresswizard£”vgmisq_helpstringžœrwbwvpulmenuˆ†rwlfs_helpstring|zrwlbstringqorwdqe_helpstringjhrwbwolwindowKIrwbwdowindow,*!rwbwfewindow*(Yrwbwetwindow)'rwbwtpwindow%#lrwbhrewindow#!rwbwtrwindow" rwbwfi1windowrwbwcmwindowrwbwdiwindow#rwbwmrwindowrwbwrgwindowrwbwcnwindow  rwbwsrwindow  rwbwgiwindow  HyperlinksWWbox½»MatrixCellbox¬Ŗ rwbwmfwindow”Ÿ vgmitx_helpstringŸvgmirt_helpstring—•vgmigr_helpstring“‘rwlop’’’Ōlfunction BeforeReport return boolean is LOGO_YN VARCHAR2(1); M_DT_FMT_MASK VARCHAR2(60); CR_UPD_DT VARCHAR2(20); F_DT VARCHAR2(20); T_DT VARCHAR2(20); HRS_DAY VARCHAR2(1); M_CURR_CODE PW_FS.CURR_CODE%TYPE ; CURSOR C_1 IS SELECT REP_VALUE_1, REP_VALUE_2, REP_VALUE_16, REP_VALUE_17, REP_VALUE_8, REP_VALUE_9, REP_VALUE_10, REP_VALUE_11, REP_VALUE_12, REP_VALUE_13, REP_VALUE_14, REP_VALUE_15, REP_VALUE_21, REP_VALUE_22, REP_VALUE_7, REP_VALUE_3, REP_VALUE_4 , REP_VALUE_5 , REP_VALUE_20 FROM PAY_REP_INFO WHERE REP_KEY_NO = :R_KEY_NO; CURSOR C1 IS SELECT GPARA_VALUE FROM PM_GUI_PARAMETER WHERE GPARA_CODE = 'REF_DT_FMT'; CURSOR C_COMP IS SELECT DECODE(:P_LANG_CODE,'ENG',COMP_ADD_1,COMP_BL_ADD_1), DECODE(:P_LANG_CODE,'ENG',COMP_ADD_2,COMP_BL_ADD_2), DECODE(:P_LANG_CODE,'ENG',COMP_ADD_3,COMP_BL_ADD_3) FROM FM_COMPANY WHERE COMP_CODE = :CP_COMP_CODE; CURSOR B1 IS SELECT PARA_VALUE FROM PM_COMP_PARAMETER WHERE PARA_CODE = 'CPMTH' AND PARA_COMP_CODE = :CP_COMP_CODE; -- commented an added by Yasharth on 18/10/2006 fo issue AJMALINT-129377 /* CURSOR C_GET_BANK_CURRENCY IS SELECT NVL(SUBSTR(BANK_CODE,4),'*') FROM PM_BANK WHERE BANK_CODE = :CP_FROM_COMP_BANK_CODE ;*/ CURSOR C_GET_BANK_CURRENCY IS SELECT PARA_VALUE FROM PM_PARAMETER WHERE PARA_CODE='BASECURR'; M_NOTE VARCHAR2(240); BEGIN STD_PRE_REPORT; OPEN C_1; FETCH C_1 INTO :CP_FM_EMP, :CP_TO_EMP, :CP_FM_CONT_TYPE, :CP_TO_CONT_TYPE, :CP_FM_DIVN, :CP_TO_DIVN, :CP_FM_DEPT, :CP_TO_DEPT, :CP_FM_LOCN, :CP_TO_LOCN, :CP_FM_CC, :CP_TO_CC, :CP_FM_CNTRY, :CP_TO_CNTRY, LOGO_YN, :CP_FROM_COMP_BANK_CODE , :CP_TO_COMP_BANK_CODE , :CP_VALUE_DATE , :CP_COMP_CODE; CLOSE C_1; OPEN C1; FETCH C1 INTO M_DT_FMT_MASK; CLOSE C1; IF NVL(LOGO_YN,'N') = 'Y' THEN OPEN C_COMP; FETCH C_COMP INTO :CP_COMP_ADD_1, :CP_COMP_ADD_2, :CP_COMP_ADD_3; IF C_COMP%NOTFOUND THEN :CP_COMP_ADD_1 := NULL; :CP_COMP_ADD_2 := NULL; :CP_COMP_ADD_3 := NULL; END IF; CLOSE C_COMP; END IF; IF NVL(LOGO_YN,'N') = 'Y' THEN :CP_TITLE_11A := :P_TITLE_11; ELSE :CP_TITLE_11A := NULL; END IF; OPEN B1; FETCH B1 INTO :CP_M_CPMTH; CLOSE B1; IF C_GET_BANK_CURRENCY%ISOPEN THEN CLOSE C_GET_BANK_CURRENCY ; END IF; OPEN C_GET_BANK_CURRENCY ; FETCH C_GET_BANK_CURRENCY INTO M_CURR_CODE ; CLOSE C_GET_BANK_CURRENCY ; :P_CURR_CODE := M_CURR_CODE ; M_NOTE := TO_CHAR(TO_DATE(:CP_VALUE_DATE),'MONTH YYYY'); :P_TITLE_34 := 'Salary Transfer for the Month of'||' '||M_NOTE ; SELECT INITCAP(TO_CHAR(TO_DATE(:CP_VALUE_DATE),'MONTH DD, YYYY')) INTO :P_DATE FROM DUAL; LOAD_BP; RETURN (TRUE); END; xئrwwt_Expresswizard£”vgmisq_helpstringžœrwbwvpulmenuˆ†rwlfs_helpstring|zrwlbstringqorwdqe_helpstringjhrwbwolwindowKIrwbwdowindow,*!rwbwfewindow*(Yrwbwetwindow)'rwbwtpwindow%#lrwbhrewindow#!rwbwtrwindow" rwbwfi1windowrwbwcmwindowrwbwdiwindow#rwbwmrwindowrwbwrgwindowrwbwcnwindow  rwbwsrwindow  rwbwgiwindow  HyperlinksWWbox½»MatrixCellbox¬Ŗ rwbwmfwindow”Ÿ vgmitx_helpstringŸvgmirt_helpstring—•vgmigr_helpstring“‘rwlo€’’’Ōl1 €°$"/ŌLOAD_BPBPROCEDURE LOAD_BP IS M_ITEM_NAME VARCHAR2(100); M_MODULE_NAME VARCHAR2(60); M_BP_VALUE VARCHAR2(100); CURSOR C1 IS SELECT BT_ITEM_NAME,DECODE(:P_LANG_CODE,'ENG',BT_ENG_TEXT,BT_FOR_TEXT) FROM PR_BOILERPLATE_TEXT WHERE BT_MODULE_NAME = 'PR007'; BEGIN OPEN C1; LOOP FETCH C1 INTO M_ITEM_NAME,M_BP_VALUE ; EXIT WHEN C1%NOTFOUND; IF M_ITEM_NAME = 'CP_BANK' THEN :CP_BANK := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_BANKC_ACNT_NO' THEN :CP_BANKC_ACNT_NO := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_BANKC_CODE' THEN :CP_BANKC_CODE := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_BANK_ADDR1' THEN :CP_BANK_ADDR1 := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_BANK_ADDR2' THEN :CP_BANK_ADDR2 := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_BANK_ADDR3' THEN :CP_BANK_ADDR3 := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_BANK_NAME' THEN :CP_BANK_NAME := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_BANK_NAME1' THEN :CP_BANK_NAME1 := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_EMP_CODE' THEN :CP_EMP_CODE := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_EMP_NAME' THEN :CP_EMP_NAME := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_FP_LC_AMOUNT' THEN :CP_FP_LC_AMOUNT := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_END_OF_REP' THEN :CP_END_OF_REP := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_TOTAL' THEN :CP_TOTAL := M_BP_VALUE; END IF; END LOOP; CLOSE C1; END;'Żi«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«ĶwÄ SYSSTANDARD xj  <PAYUSERPR_BOILERPLATE_TEXT$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08 ""g\"PKG INIT"LOAD_BP"M_ITEM_NAME"M_MODULE_NAME"M_BP_VALUE"C1""BT_ITEM_NAME"DECODE""x &)*034<BDJMNTWY[]_ace  d  < d!  0DX-.) ’’$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08ž(____Ė怒’’’eedAAeedAAeedAA ec $ $ $ $ $ $ $ $ $ $ $ $ $ $eeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAeeAAA‹eAA‹eeeAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹e€"LOAD_BP"M_ITEM_NAME"VARCHAR2"100"M_MODULE_NAME"60"M_BP_VALUE"CURSOR"C1"BT_ITEM_NAME"DECODE"P_LANG_CODE""ENG"BT_ENG_TEXT"BT_FOR_TEXT"PR_BOILERPLATE_TEXT"BT_MODULE_NAME"="PR007"OPEN"LOOP"EXIT"NOTFOUND"CP_BANK"ELSIF"CP_BANKC_ACNT_NO"CP_BANKC_CODE"CP_BANK_ADDR1"CP_BANK_ADDR2"CP_BANK_ADDR3"CP_BANK_NAME"CP_BANK_NAME1"CP_EMP_CODE"CP_EMP_NAME"CP_FP_LC_AMOUNT"CP_END_OF_REP"CP_TOTAL"CLOSE""  #$/156=EILOST[cgjmqry…ˆ‹Ÿ£¤Æ±³ø¾ĀĆĒĢŠŃŲŻįåģķńöśū’   "'+/37;AEIMPTY]^bgimtx|…†Š‘•œ ¤©­®²·¹½Ä’’’ŌlČĢŃÕÖŚßįåģšōłżž  !%&*/15<@DIMNRWY]dhlquvz…Œ”™ž¢§©­“ø¼ĮÅĘŹĻŃÕÜąäéķīņ÷łż !%,049=>BGIMTX]_ceikry€‡Ž•œ£Ŗ±øæĘĶÕŁÜßēėīńłż !$'/369AEHKSWZ]eilow{~‰“›Ÿ¢„­±“·æĆĘÉĢĻ×ŲŪŽęēļóōū’ %&),458;CDGJRSVYabehpqtw€ƒ†Ž’•ž”¤¬­°³»¼æĀŹhšU“±°£ cQ°£ cQ°£ cQ½ōČ“±·é劬 . „¼n  ī² .|“ n¬¤·éŻ ³G·éÓ   +  <.|“ n· ¼ .|“ n· ¼ .|“ n· ¼ .|“ n· ¼ .|“ n· ¼ .|“ n· ¼ .|“ n· ¼ .|“ n· ¼ .|“ n· ¼ .|“ n· ¼ .|“ n· ¼ .|“ n· ¼ .|“ n· ¼ éĮ O¤µóóóóóóóóóóóóóóücQücQücQücQücQücQücQücQücQücQücQücQücQücQQc¬Qc¬`°£°£¬Qc¬Qc¬Qc¬Qc¬Qc¬Qc¬Qc¬Qc¬Qc¬Qc¬Qc¬Qc¬Qc¬  !!!""""""###$$$$$$%%%&&&&&&'''(((((()))---. !#%')  "$&(   $17C !     # 7)7 8)7 8)7 8)7 8)7 8)7 8)7 8)7 8)7 8)7 8)75%70 $ Ō½|’;Ó   €€€€€d €€€ € €<  € € €€€d " "’!#$:""&$'#(1 €+,€" € ć#Õ!€€249"€56€€€"=;>?* A#;"@CADE & I@@AJK€ )ANS@LOP€.€7 -:MUVS ēšÖX]@LYZ€2€< 1?W_` ] ė^×bg@Lcd€6€A 5Daij g ļZŲlq@Lmn €:!€F 9Ikstq ó`Łv{@Lwx"€>#€K =Nu}~{ ÷\Ś€…@L‚$€B%€P AS‡ˆ… ūŒŪŠ@L‹Œ&€F'€U E X‰‘’ ’›Ü”™@L•–(€J)€Z !I!]“›œ™! ”Żž£@LŸ *€N+€_ "M"b„¦£" ‹ŽØ­@L©Ŗ,€R-€d #Q#g§Æ°­# Uß²·@L³“. ’’’Ōl€V/€i $U$l±¹ŗ·$ ]ą¼Į@L½¾0€Z1€n %Y%q»ĆÄĮ% :įĘĖ@LĒČ2€^3€s &]&vÅĶĪ Ė& āŠ#;Ń # ć# ēš ė^ ļZ ó` ÷\ ūŒ ’›! ”" ‹ # U $ ] % : &  4€5€åäę6€(7€8€éčź9€P:€;€ķģī<€P=€>€ńšņ?€P@€A€õōöB€PC€D€łųśE€PF€G€żüžH€PI€J€K€PL€M€N€PO€P€  Q€PR€S€  T€PU€V€W€PX€Y€Z€P[€\€]€P^€_€`€a€‹b€c€ d€e€ Ž“&%f€z g€€)#(h€x i€*#j€+k€,l€m€,–n€/o€0p€q€0™r€ 3s€4t€u€4œv€ 7w€8x€y€8Ÿz€ ;{€<|€}€<¢~€ ?€@€€€@„ ‚€ Cƒ€D„€…€DØ!†€ G‡€Hˆ€‰€H«"Š€ K‹€LŒ€€L®#Ž€ O€P€‘€P±$’€S“€T”€•€T“%–€ W—€X˜€™€X·&š€[›€\œ€€\ŗ  %)*-./0378<@ĻŅBHLFG MWaku‰“§±»ÅQRT[\^efhopryz|ƒ„†Ž—˜š”¢¤«¬®µ¶øæĄĀÉŹĢ)&ÕÖ×ŲŁŚŪÜŻŽßąįā78-./0$'QR[\efopyzƒ„Ž—˜”¢«¬µ¶æĄÉŹ%”’’dÜ’’ ß’’)ā’’ą’’&Ż’’Õ’’Ł’’Ś’’Ū’’Ž’’į’’Ö’’Ų’’×’’«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0P WW»8\., “ä€# wXwXDuXDyX  Ž„$ DŪš“„$ D,Ū^,„0$ D@ŪZ@l„H$ DTŪ`TH„`$ DhŪ\h$„x$ D|ŪŒ|„$ DŪ›Ü„Ø$ D¤Ū”¤ø„Ą$ DøŪ‹ø”„Ų$ DĢŪUĢp„š$ DąŪ]ąLˆ% DōŪ:ō'ˆ ! DŪņż’’sX! r„{t ghX×ghX#tghX €!T’„T"D`h:= 8H\|lLOAD_BPCP_BANKCP_BANKC_ACNT_NO CP_BANKC_CODE CP_BANK_ADDR1 CP_BANK_ADDR2 CP_BANK_ADDR3 CP_BANK_NAME CP_BANK_NAME1 CP_EMP_CODE CP_EMP_NAMECP_FP_LC_AMOUNT CP_END_OF_REPCP_TOTALÄ*xčd*0ģ4<*D8Ød *X¬°(`”(…(˜ōš…(,ųT^…(@X“Z…(Tø`…(ht\…(|xŌŒ…(Ų4›…(¤8””…(ø˜ō‹…(ĢųTU…(ąX“]…(ōø:…*t  ;Pat…˜©¼Ķąń(9L]p !”"„#ø$É%Ü&ī'()"(--.6=SELECT BT_ITEM_NAME,DECODE(:b1,''ENG'',BT_ENG_TEXT,BT_FOR_TEXT) FROM PR_BOILERPLATE_TEXT WHERE BT_MODULE_NAME = ''PR007''"»Œ˜0° HÄ `Ų xģ  Ø Ą( Ų8 šH\  p#š^Z`\Œ›”‹U]:@@°’’’Ōl0ØE `0ØL Nap0ØPT L  0Ø jum0Øs pa/@0Øes €0Ør ba# °0Ø/ Ba,0Ø&fil- p0Ø jum3ą0Ø new= 0Øm.re@p0Øent.H  Ą0ØenamK0ØeextO 8ØfuncSacŠ0Øare X Ą08 if (ju_iŠ08 jump_ deŠ08age(formju 08} } /*  f008age */ f!ctP08form) { "* š08t in las%pa00ump_inde& < 08{ jump7nd008page(for8 jŠ08 } } /*9o P00e */ fun num_pages) { form.reqpage.value = num_pages; } jump_index = form.reqpage.value; new_page(form, jump_index); }
’’’’ 0800ØĖZžP’’’’ 0800ØŽ(ž`€’’’’0800Ø[ ’’’’0800Ø  ’’’’0800Ø°’’’’ 0800ØĶ0žĄš’’’’0800ØA ’’’’N0808ØL 661 °$ 6F_DATEFORMATTRIGGERķA«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«ĶwÄ SYSSTANDARD $«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08"PKG INIT"F_DATEFORMATTRIGGER""n’’$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08J 3"FUNCTION"F_DATEFORMATTRIGGER"RETURN"BOOLEAN"TRUE""( #$(357;>BDHh,“ ±·eZ O¤µ % ’€   €€ ’’d«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0D    „% hg!t’tdL0F_DATEFORMATTRIGGER `@@’’’’0800Ø  ’’’’x*€*€6€6€?B(F J€JąV(Z€Ząf(j€j€j(n(r(vf RUNONLY trPR007CRy }.itur Cu@Pnt No˜v˜™’’’’ pInsreppląV(’’’’S N¢¦(Ŗ0«¬²@¶@ŗ0»0¾@Ā@Ę@Ź@Ī@Ņ@Ö0×0ŲŁŚ0Ū0Ü8Ž8ąįpįpāpāćäåęēčź ģ0ķ0īļš8ņ8ō0õöų śūüżž@A11 AAAAAA"1#1&A*A.1/12A6A:A>ABAFAJ1K1LMNOPQdp‘ś<Ģ †°­PB==@!@`@`8Śs  «ījjv. †°­PBW2@`@`@` †°­PB@`@`@` ’’’’ 00 N’’’’ 00 NUĄ’’’’dr’’’’]0808Ø[EE Oracle HTML Navigator
&IntoS’’’’!0Ø=O&verS’’’’ 0Ø=O&ut’’’’ 0Ø=&To:’’’’*0Ø(=&Program Unit:’’’’"0Ø =&Line:m’’’’#0Ø!=&Count:’’’’"0Ø = &Apply’’’’0Ø= OKp’’’’"0Ø = Cancel’’’’!0Ø= &Help’’’’'0Ø%> PL/SQL Step’’’’"0Ø >&Mode:S’’’’!0Ø>&IntoS’’’’!0Ø>O&verS’’’’ 0Ø>O&ut’’’’ 0Ø>&To:’’’’*0Ø(>&Program Unit:’’’’"0Ø >&Line:m’’’’#0Ø!>&Count:’’’’"0Ø > &Apply’’’’0Ø> OKp’’’’"0Ø > Cancel’’’’!0Ø> &Help’’’’=0Ø;?!PL/SQL Stored Program Unit Editor’’’’60Ø4?Stored Program Unit EditorE’’’’$0Ø"?&Program’’’’$0Ø"?&Compile’’’’(0Ø&? &Incremental’’’’ 0Ø?&All’’’’30Ø1?&Program Unit Editor...’’’’20Ø0?PL/SQL &Interpreter...’’’’:0Ø8?&Stored Program Unit Editor...o’’’’70Ø5? Database &Trigger Editor...’’’’.0Ø,? Synta&x Palette...d’’’’A0Ø?? %&Find and Replace in Program Units...’’’’ 0Ø? &New’’’’!0Ø? &Savean’’’’#0Ø!?&Revert’’’’!0Ø?&Dropt’’’’"0Ø ?&Close’’’’!0Ø?He&lp’’’’"0Ø ?Owner:’’’’!0Ø?Name:’’’’(0Ø&? Not Modified’’’’10Ø/?Successfully Compiledro’’’’0800Ø (0’’’’0800Ø ‰@’’’’0800Ø ŠP’’’’(0000Ø&FG’’’’ 0800Ø4`p1DEŠ’’’’hr’’’’ 0800ØfĻž`’’’’0800Ø p’’’’ 0800Ø/Ōž€°cript"> var jump_index = 1 // Jump to this page var num_pages = &TotalPages // Total number of pages var basefilename = "&file_name" // Base file name var fileext = "&file_ext" //File extension /* jumps to "new_page" */ function new_page(form, new_page) { form.reqpage.value = new_page; parent.frames[0].location = basefilename + "_" + new_page + "."+fileext; } /* go back one page */ function back(form) { /* if we are not in first page */ if (jump_index > 1) { jump_index--; new_page(form, jump_index); } } /* go forward one page */ function forward(form) { /* if we are not in last page */ if (jump_index < num_pages) { jump_index++; new_page(form, jump_index); } } /* go to first page */ function first(form) { if(jump_index != 1) { jump_index = 1; new_page(form, jump_index); } } /* go to last page */ function last(form) { if(jump_index != num_pages) { jump_index = num_pages; new_page(form, jump_index); } } /* go to the user specified page number */ function pagenum(form) { /* sanity check */ if (form.reqpage.value < 1) { form.reqpage.value = 1; } if (form.reqpage.value > num_pages) { form.reqpage.value = num_pages; } jump_index = form.reqpage.value; new_page(form, jump_index); }
&IntoS’’’’!0Ø=O&verS’’’’ 0Ø=O&ut’’’’ 0Ø=&To:’’’’*0Ø(=&Program Unit:’’’’"0Ø =&Line:m’’’’#0Ø!=&Count:’’’’"0Ø = &Apply’’’’0Ø= OKp’’’’"0Ø = Cancel’’’’!0Ø= &Help’’’’'0Ø%> PL/SQL Step’’’’"0Ø >&Mode:S’’’’!0Ø>&IntoS’’’’!0Ø>O&verS’’’’ 0Ø>O&ut’’’’ 0Ø>&To:’’’’*0Ø(>&Program Unit:’’’’"0Ø >&Line:m’’’’#0Ø!>&Count:’’’’"0Ø > &Apply’’’’0Ø> OKp’’’’"0Ø > Cancel’’’’!0Ø> &Help’’’’=0Ø;?!PL/SQL Stored Program Unit Editor’’’’60Ø4?Stored Program Unit EditorE’’’’$0Ø"?&Program’’’’$0Ø"?&Compile’’’’(0Ø&? &Incremental’’’’ 0Ø?&All’’’’30Ø1?&Program Unit Editor...’’’’20Ø0?PL/SQL &Interpreter...’’’’:0Ø8?&Stored Program Unit Editor...o’’’’70Ø5? Database &Trigger Editor...’’’’.0Ø,? Synta&x Palette...d’’’’A0Ø?? %&Find and Replace in Program Units...’’’’ 0Ø? &New’’’’!0Ø? &Savean’’’’#0Ø!?&Revert’’’’!0Ø?&Dropt’’’’"0Ø ?&Close’’’’!0Ø?He&lp’’’’"0Ø ?Owner:’’’’!0Ø?Name:’’’’(0Ø&? Not Modified’’’’10Ø/?Successfully Compiledro’’’’0800Ø (0’’’’0800Ø ‰@’’’’0800Ø ŠP’’’’(0000Ø&FG’’’’ 0800Ø4`p1DEą’’’Ōl1 °$ ‘CF_LOCAL_CURRFORMULA2function CF_LOCAL_CURRFormula return VARCHAR2 is CURSOR L_CURR IS SELECT PARA_VALUE FROM FP_PARAMETER WHERE PARA_ID = 'BASE.CURR'; V_CURR VARCHAR2(20); BEGIN OPEN L_CURR; FETCH L_CURR INTO V_CURR; CLOSE L_CURR; RETURN(V_CURR); END; †«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«ĶwÄ SYSSTANDARD xj 1-PAYUSER FP_PARAMETERxj 2/ ORION_LIVE FP_PARAMETER$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08MF"PKG INIT"CF_LOCAL_CURRFORMULA"L_CURR""PARA_VALUE"V_CURR""'-/589?BCEGIK    šš AB ’’$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08CCCC"P’’’’d# $eedAAAA‹e))"FUNCTION"CF_LOCAL_CURRFORMULA"RETURN"VARCHAR2"CURSOR"L_CURR"PARA_VALUE"FP_PARAMETER"PARA_ID"="BASE.CURR"V_CURR"20"OPEN"CLOSE"" #$(35:IMNY[]bhlmqxy}‚†‡‹‘•™š”©­°³µŗ¾ĀĆČĢŠŌŲŻßćēźīšōöłü h,“ ±½ōČ“±·é劬 ī² .|“ n¬¤°£ cQ·éŻ ³éÓ  éĮ eZ O¤µQc¬`°£¬    &        9 ’€ '8    ’  >€ €€= € € < !#  #$%€€% €& € €)'*+B -'./  "2'3 5'6# " € : €;€€;@€€€> "(,1470A?,’’dA "«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0P ^^TB `ä”#4w u   s % hg! r„{t gdtgd €!č’Œčø`h:=š8@šT€dCF_LOCAL_CURRFORMULA$ 48 <\ `\š  - 1<J=SELECT PARA_VALUE FROM FP_PARAMETER WHERE PARA_ID = ''BASE.CURR''"@@€’’’’x*€*€6€6€?B(F J€JąV(Z€Ząf(j€j€j(n(r(vf RUNONLY trPR007CRy }.itur Cu@Pnt No˜v˜™’’’’ pInsreppląV(’’’’S N¢¦(Ŗ0«¬²@¶@ŗ0»0¾@Ā@Ę@Ź@Ī@Ņ@Ö0×0ŲŁŚ0Ū0Ü8Ž8ąįpįpāpāćäåęēčź ģ0ķ0īļš8ņ8ō0õöų śūüżž@A11 AAAAAA"1#1&A*A.1/12A6A:A>ABAFAJ1K1LMNOPQdp‘ś<Ģ †°­PB==@!@`@`8Śs  «ījjv. †°­PBW2@`@`@` †°­PB@`@`@` ’’’’ 00 N’’’’ 00 N _„’ € €  € € €€@^ €€ € € € € š’’’Ōl1 °$" źCF_COMPANYFORMULAŹfunction CF_COMPANYFormula return VARCHAR2 is COMPANY VARCHAR2(40); begin SELECT SUBSTR(COMP_NAME,1,40) INTO COMPANY FROM FM_COMPANY WHERE COMP_CODE = :CP_COMP_CODE ; RETURN(NVL(COMPANY,'XX')); end; ɂ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«ĶwÄ SYSSTANDARD xj 1-PAYUSER FM_COMPANYxj 2 ORION_LIVE FM_COMPANY$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08B J"PKG INIT"CF_COMPANYFORMULA"COMPANY""""ņ%()/17:<>@  ( $8c  ’’$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08@@@@-tdeedAAeG AA $eeŁeeAeeAA‹ew"FUNCTION"CF_COMPANYFORMULA"RETURN"VARCHAR2"COMPANY"40"SUBSTR"COMP_NAME"1"FM_COMPANY"COMP_CODE"CP_COMP_CODE""="NVL"XX""Z #$(359:AIMPSUZ`dejnosvy€…ŠŽ“š›œ ¤§¬°±µŗ¼ĄĀÉŃÕŲŪÜŻåéźńō÷’h,“ ±°£ cQ·é劬. „ QQī² .|“ ¼¬² eZ. „ nO¤µóücQ¬¬`°£Qc¬ #   &  0+’€ /  €€€€€(%8 €7€  € € €($ € ! €6€ € 21 ()€*+€?€ > 2€€435€P &:€$€8€<€=€€=(  '."#&,-"#1;9,-$’’d1’’ «Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0D ddT üäœq„{t 8w8$×8t8ą‚$&'$„Ó’@@ $C@% hg!ą’ˆąČ`h:=8@T€dCF_COMPANYFORMULAXX,$“č( 8ģš€@ōųŃT°P1^SELECT SUBSTR(COMP_NAME,1,40) FROM FM_COMPANY WHERE COMP_CODE = :b1"”@@'#( ! deupwv7! deupwv8"#$%&'#$’’’ž%’’’’&’’’’' (! deupwv9"#$%&'(! deupwv10"#$%&'#$’’’ž%’’’’&’’’’' (! deupwv11"#$%&'#$’’’ž%’’’’&’’’’' ("$%&'#$%&'#$%&'#$%&'#( ! deupwv12! deupwv13"#$%&'#$’’’ž%’’’’&’’’’' () deupwv0 pushb*+,P-34 MS Sans Serif ’’’Ō l1 °$"wCF_CPMTHFORMULAefunction CF_CPMTHFormula return VARCHAR2 is PVAL NUMBER; PVAL1 VARCHAR2(10); begin SELECT to_char(to_date(to_number(PARA_VALUE),'YYYYMM'),'Mon-YYYY') INTO PVAL1 FROM PM_COMP_PARAMETER WHERE PARA_CODE = 'CPMTH' AND PARA_COMP_CODE = :CP_COMP_CODE; RETURN(NVL(PVAL1,'X')); end; ---to_char(to_date(to_number('199902'),'YYYY/MM'),'Mon-YYYY') ½g«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«ĶwÄ SYSSTANDARD xj  %PAYUSERPM_COMP_PARAMETER$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08MK"PKG INIT"CF_CPMTHFORMULA"PVAL"PVAL1""""%(.128:@CEGIK    $,@c ’’$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ081^^^^s>ČdeedAAeŗ ‡  # $ $eeŁeeAAA‹eAA‹eAA‹eeeAA‹e¼"FUNCTION"CF_CPMTHFORMULA"RETURN"VARCHAR2"PVAL"NUMBER"PVAL1"10"TO_CHAR"TO_DATE"TO_NUMBER"PARA_VALUE"YYYYMM"Mon-YYYY"PM_COMP_PARAMETER"PARA_CODE"="CPMTH"PARA_COMP_CODE"CP_COMP_CODE""NVL"X""R #$(359:AIMQRYaehkmrx|}‚…†‹•˜™¢§®Æ³ø½ĮĀĘĖŠŌÕŁąįāęźķņö÷ū!$'/01258@ADGOPX\]dgjrh,“ ±°£ °£ cQ·é劬.Ÿ„. „.Ÿ„ nnī² .|“ n .|“ ¼¬² eZ. „ nO¤µóücQQc¬¬¬Qc¬Qc¬`°£Qc¬      !   $0:  B<(’€ A  €€€ €€€€ € 7V' €U € €Q €"#€M € € P T(*6€+01€,-€K€€J23€L€€DC :;€<=€]€"\D€€FEG€P€H €I!€"€I%*- #€N$€O%€&€O/'€R(€S)€*€S27X+€5,€V-€Z.€[/€0€[9  9@&!%$)./458>?./C45$!%&YW>?*’’dC’’ «Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0D ddTć ä˜q„{t @w@,×@t@ą‚,&',„Ó’HH $CH% hg!ä’€äĢ`h:=8@T|dCF_CPMTHFORMULAX2$¼Ō,Ųģ  @šō€HųüŃ\øP1 ^ SELECT TO_CHAR(TO_DATE(TO_NUMBER(PARA_VALUE),''YYYYMM''),''Mon-YYYY'') FROM PM_COMP_PARAMETER WHERE PARA_CODE = ''CPMTH'' AND PARA_COMP_CODE = :b1"@@) deuiwv0 toolbar.bcKM1N`vQ desti’’’Ō"l1 €°$ 6!F_CONV_AMOUNT_TO_WORDSPPROCEDURE F_CONV_AMOUNT_TO_WORDS(P_CURR_CODE IN VARCHAR2, P_AMOUNT IN NUMBER, P_AMOUNT_IN_WORDS IN OUT VARCHAR2) IS M_CURR_DECIMAL NUMBER(1) ; M_CURR_UNIT_NAME VARCHAR2(15) ; M_AMOUNT_DESC VARCHAR2(250) ; CURSOR C1 IS SELECT CURR_UNIT_NAME, CURR_DECIMAL FROM FM_CURRENCY WHERE CURR_CODE = P_CURR_CODE ; CURSOR C2 IS SELECT TRANSLATE((TO_CHAR(TO_DATE(DECODE( TRUNC(NVL(P_AMOUNT,0)/1000000),0,'', TRUNC(NVL(P_AMOUNT,0)/1000000)),'j'),'JSP') || DECODE(NVL(TRUNC(NVL(P_AMOUNT,0)/1000000),0), 0,'', ' MILLION ') || DECODE(NVL(P_AMOUNT,0) - TRUNC(NVL(P_AMOUNT,0) / 1000000) * 1000000, 0,'', (TO_CHAR(TO_DATE(TRUNC(NVL(P_AMOUNT,0)) - TRUNC(NVL(P_AMOUNT,0)/1000000) * 1000000, 'J'),'JSP'))) || DECODE((NVL(P_AMOUNT,0) * POWER(10, M_CURR_DECIMAL)) - (TRUNC(NVL(P_AMOUNT,0)) * POWER(10, M_CURR_DECIMAL)), 0, ' ', --Commented by Manjula for ORIONQC-GDC-814777 on 31/01/2006 ' And ' || M_CURR_UNIT_NAME || ' ' || TO_CHAR(TO_DATE((NVL(P_AMOUNT,0) * POWER(10, M_CURR_DECIMAL)) - (TRUNC(NVL(P_AMOUNT,0)) * POWER(10,M_CURR_DECIMAL)) , 'J'), 'JSP')) || ' ONLY '),'-',' ') "AMOUNT_IN_WORDS" FROM DUAL ; begin OPEN C1 ; FETCH C1 INTO M_CURR_UNIT_NAME, M_CURR_DECIMAL ; CLOSE C1 ; OPEN C2 ; FETCH C2 INTO M_AMOUNT_DESC ; CLOSE C2 ; P_AMOUNT_IN_WORDS := M_AMOUNT_DESC ; END;0§«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«ĶwÄ SYSSTANDARD xj 2PAYUSER FM_CURRENCY“p <<PAYUSERDUAL xj  (PUBLICDUALxj  (SYSDUAL$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0822¢¶"PKG INIT"F_CONV_AMOUNT_TO_WORDS"P_CURR_CODE"P_AMOUNT"P_AMOUNT_IN_WORDS"M_CURR_DECIMAL"M_CURR_UNIT_NAME"M_AMOUNT_DESC"C1""CURR_UNIT_NAME"CURR_DECIMAL"C2"AMOUNT_IN_WORDS"">%(.17:;<BEFLOPX^`fijps{ƒ‰ŒŽ’”–˜šœž     /   *+,ś 0 - 'š ( 1 #. %)&šš  4<ij,– $! "’’$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08 1××××eØ(’’’’’’’’@B@B@B@B@B@B@BededAAAeedAAeedAA0+ $e•eeźeźeźeźeŗ ‡ óī  ŽAAAī  ŽAAe Žī  ŽAAAAe āŽAöī  ŽAAAAeeŗ ‡ āī ŽAöī  ŽAAAe āöŽA Aöī ŽA AAeźeźeźeŗ ‡ āöŽA Aöī ŽA Ae66..AA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eeeł ł ł ł ł ł ł ł X"F_CONV_AMOUNT_TO_WORDS"P_CURR_CODE"VARCHAR2"P_AMOUNT"NUMBER"P_AMOUNT_IN_WORDS"OUT"M_CURR_DECIMAL"1"M_CURR_UNIT_NAME"15"M_AMOUNT_DESC"250"CURSOR"C1"CURR_UNIT_NAME"CURR_DECIMAL"FM_CURRENCY"CURR_CODE"="C2"TRANSLATE"TO_CHAR"TO_DATE"DECODE"TRUNC"NVL"0"/"1000000""j"JSP"||" MILLION "-"*"J"POWER"10" " And " " ONLY "AMOUNT_IN_WOR ’’’Ō$lDS"DUAL"OPEN"CLOSE""Ņ #$)*26;<DHMNUYdfjkrz~„‡‹Œ“›Ÿ¢„©Ŗ±¹½ĄĆČ×ŪÜēéėšöśū’  !"&+:>?JLNSY]^`eijmrvw|€†Š‹”•šž£§Ø­±²·»¼ĮÅĘĖĻŠŌ׌Żāēėģńõöū’ #'(-127;<AEFJMPSV[`eijosty}~‚…ŠŽ”˜™ž¢£Ø¬­±“·ŗ½ĀÅŹĶĪÓ×ŲŻįāēėģńõöśż  $%),/27<AEFKOPSX\]bfgknswx{‚‡‹Œ‘•–›Ÿ ¤§¬°±“ø»ĄÅÉŹĻÓŌŁŻŽćēģńōõśž’   $',0148;@DEJNOTXY]`eijmqv{€…ŠŽ•–š›Ÿ”¦Ŗ®Æ“ø¼ĄÄČĶĻÓŲÜąįęźīņöūż  "#*./6789<?GHIJKNQYZ]`hijklmps{~‰Š‹ŒŽ‘”—Ÿ ”¢£¤„¦©¬“µø»ĆÄÅĘĒČÉŹĖĢĶĪŃŌÜßāźėīńłśūüżž’ !"#&)1258@CFNOW[\cdhšU“=° =° ?° ±°£ cQQ°£ cQ°£ cQ½ōČ“±·é劬  ī² .|“  ¬¤½ōČ“±·é劬¹. „Z.|“.|“.|“.|“.Ÿ„. „. „. „.|“. „ QQQn. „.|“. „ QQnn. „. „. „.|“. „ QQQQnn. „.|“. „ Q.|“. „.|“. „ QQQQnZ.Ÿ„. „.|“. „. „ Q.|“. „.|“. „ QQQnn. „.|“Z.|“. „ Q. „Q Z.|“. „. „ Q. „Q Qn.|“.|“.|“n n.Ÿ„. „.|“Z.|“. „ Q. „Q Z.|“. „. „ Q. „Q nnnnn ī² ¬¤·éŻ ³éÓ   éĮ éŻ ³éÓ  éĮ    O¤µ¬`°£°£¬¬¬Qc¬¬¬¬Qc¬Qc¬¬¬¬¬QcQc¬¬¬¬¬¬¬¬Qc¬¬¬¬¬¬¬Qc¬Qc¬¬¬¬¬¬¬¬¬¬¬QcQc¬Qc¬¬¬¬¬¬¬¬¬Qc¬Qc¬¬¬¬Qc¬QcQc¬`°£¬¬ " !!""""####%&&&&''''''(((****++++,,,.../%  &* !"""1  D0%%%  #%  $) #!$-137  ="2""""&/4? ,(#  %  8  #'   #  %"  $'   $      %  ""         _„’ € €  € € €€@^ €€ € € € € 0’’’Ōl !" €€"€#€ €%' '()€€)€*€ €ś,-/-/,’.01A,+//314a58€€9;@/€<=€`€ € /CDFDFC’EGH?CBF#FJHKŃL;%N:OP€Š€'R€ST €É"!€+VW"€Å"#€.YZ$€Ÿ"%€1\]&€…"'€4_`(€y)€7bc*€u+€:ef,€q-€=hi.€j/€Bkl0€i1€Dno2€h3€G 4€5€€6€mvw7€p8€Jyz9€o:€L|};€n<€O =€>€€ t !x!„…?€„@€R‡ˆA€}B€WŠ‹C€|D€ZŽE€{F€\‘G€zH€_ I€J€€K€L€€#ƒ#š›M€žN€bžO€‹$P€g ”Q€†R€j S€„¦T€Š%U€mØ©V€‰W€p«¬X€ˆY€r®ÆZ€‡[€u \€]€€^€€_€Ž·`€ø¹a€b€x»¼c€™d€{¾æe€•$f€~ĮĀg€h€ÄÅi€j€ƒ k€ÉŹl€”%m€†ĢĶn€“o€‰ĻŠp€’q€‹ŅÓr€‘s€Ž t€u€€v€ €&˜&!œ!ŪÜw€Äx€‘Žßy€§$z€–į{€āć|€¢%}€™åę~€ €œ €€źė€”'‚€Ÿ(ƒ€ ļ„€šń…€¦%†€¢óō‡€¤ˆ€„ö÷‰€£Š€§ ‹€ūüŒ€„'€Ŗ(Ž€ €)Ŗ)€Ć"‘€­’€²"“€° ”€®"•€³*­* +±+–€Ā—€¶˜€¾™€¹š€ŗ$›€¼œ€€µ%ž€æŸ€³ €Ā ”€ !¢€“'£€Å(¤€ %„€&'¦€¹%§€Č)*؀·©€Ė,-Ŗ€¶«€Ķ ¬€12­€ø'®€Š(ƀ &½&!Į!,Č,$Ģ$+Ļ+-°€<>FÓ.±€FÕB@CDÕ,F@GH,Ž L@M,O@PQÖCS@TUCį &X@YC[\@ &čć3c²€ę³€€6af“€ėµ€€7aķšó¶€k·€lø€¹€löłü’ ŗ€r»€s¼€½€s!¾€væ€wĄ€Į€w  Ā€~ƀĀŀ#ʀ Ē€‚Ȁɀ‚!$'*-Ź€ŒĖ€Ģ€Ķ€0369<?B&Ī€–Ļ€—Š€Ń€—E!Ņ€šӀ›Ō€Õ€›HKPSVY\_beh)րØ׀©Ų€Ł€©*Ś€«Ū€¬܀Ż€¬k+Ž€Æ߀°ą€į€°nqtwz}€ƒ†&ā€»ć€¼ä€å€¼‰!ę€æē€Ąč€é€ĄŒ’—,ź€Ęė€Ēģ€ķ€Ēš$ī€Źļ€Ėš€ń€Ė+ņ€Ķó€Īō€õ€Ī£JÓö€”-÷€MŃ   $+B&267:>?IMQ89U7XŚ[™^ƒa‚dgstujmrpqx{€~†–—˜‰•Œ”’“œ“µ¶Ÿ¤¢£§³Ŗ­²°±ŗŁ½ŲĄČĆĘĒĖ×ĪŃÖŌÕŻ’ąīäéēčģķņśõųłżž    65$"#(0+./34=AEKNRWZ]IJVbed>?gpqmrjų€~{€xł€gstuda‚’“”Œś€‰•†–—˜^ƒ¢£°±­²Ŗū€§³Ÿ¤ĘĒĆü€ŌÕŃÖĪż€Ė×ĄČ½ŲŗŁœ“µ¶[™ēčģķäéųłõž€żžņśąī   "#./+’€34(0$56 Ż’XŚU7Q89ŌŅ2I`’’ dg  Ō,C&d«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0\ ØØ”j–@’’’Ōl Ģäč#\w4Dw4Xu4DD XX„„s4#Pw< u<  s< % ! r„{t$gd4}gd4ggetgd4 €! r„{t`gd<}gd<gge}gd<gge}gd<gge}gd<gge}gd<gge}gd<gge}gd<gge}gd<gge}gd<gd}gd< gge}gd< gd}gd< gd }gd< gge}gd< gd}gd<gge}gd<gdtgd< €!€’€ 0``h:=<Lš`h:=x€”ĤF_CONV_AMOUNT_TO_WORDSF`x |” ˜œś (4 ¤ (<ج(D°¬š(X°Č&'B(F*L+`,d.i/r =ž=SELECT CURR_UNIT_NAME,CURR_DECIMAL FROM FM_CURRENCY WHERE CURR_CODE = :b1"SELECT TRANSLATE((TO_CHAR(TO_DATE(DECODE(TRUNC(NVL(:b1,0) / 1000000 ),0,'''',TRUNC(NVL(:b1,0) / 1000000 )),''j''),''JSP'') || DECODE(NVL(TRUNC(NVL(:b1,0) / 1000000 ),0),0,'''','' MILLION '') || DECODE(NVL(:b1,0) - TRUNC(NVL(:b1,0) / 1000000 ) * 1000000 ,0,'''',(TO_CHAR(TO_DATE(TRUNC(NVL(:b1,0)) - TRUNC(NVL(:b1,0) / 1000000 ) * 1000000 ,''J''),''JSP''))) || DECODE((NVL(:b1,0) * POWER(10,:b9) ) - (TRUNC(NVL(:b1,0)) * POWER(10,:b9) ) ,0,'' '','' And '' || :b12 || '' '' || TO_CHAR(TO_DATE((NVL(:b1,0) * POWER(10,:b9) ) - (TRUNC(NVL(:b1,0)) * POWER(10,:b9) ) ,''J''),''JSP'') ) || '' ONLY '' ),''-'','' '') '"AMOUNT_IN_WORDS'" FROM DUAL" ąä@@0Ø0;OK& ’’’’W0ØU;<;No matches found. Continue search on the next program unit? ’’’’$0Ø"’’<Continue’’’’'0Ø%g0= PL/SQL Step0’’’’"0Ø 5g=&Mode:’’’’’’!0Ø_C=&Into€Ą’’’’!0Ø" =O&ver75g’’’’ 0Ø0=O&ut’’’’ 0Ø€=&To:x$ &( *_C r100g0b75’’ĄĄ’’’’(00x!"$ &_Cr0g0b88ą’’’’*00x" $& (_Cr25g0b88@ąąĄ’’’’*00x" $& (_Cr50g0b88€ąąĄ’’’’*00x" $& (_Cr75g0b88ĄąąĄ’’’’*00x" $& (_Cr88g0b88ąąąĄ’’’’,00x$ &( *_C r100g0b88’’ąą’’’’(00x"#$ &_C r0g0b100’’’’’’,00x$ &( *_C! r25g0b100@ą’’’’’’,00x$ &( *_C" r50g0b100€ą’’’’’’,00x$ &( *_C# r75g0b100Ąą’’’’’’,00x$ &( *_C$ r88g0b100ąą’’’’’’,00x$ &( *_C% r100g0b100’’ą’’’’’’&00x " $_C&grayĄĄĄ’’’’’’*00x" $ & (_C'darkgray€€€’’’’’’&00x " $_C(cyanr’’’’€’’’’*00x"$ & (_C)darkcyan’€€’’’’’’(00x " $ &_C*gray80333333’’’’(00x " $ &_C+gray76p=p=p=’’’’(00x " $ &_C,gray72®G®G®G’’’’(00x " $ &_C-gray68ėQėQėQ’’’’'00x!" $%_C.r0g25b0@Q’’’’)00x" $ &'_C/r25g25b0@@€’’’’’’)00x" $ &'_C0r50g25b0€@€’’’’’’)00x" $ &'_C1r75g25b0Ą@€’’’’’’)00x" $ &'_C2r88g25b0ą@€’’’’’’+00x$ & ()_C3 r100g25b0’’@’’’’’*00x"$ & (_C4r0g25b50@€’’’’’,00x$ & ( *_C5 r25g25b50@@€’’’’,00x$ & ( *_C6 r50g25b50€@€’’’’,00x$ & ( *_C7 r75g25b50Ą@€’’’’,00x$ & ( *_C8 r88g25b50ą@€’’’’,00x$ & ( *_C9 r100g25b50’’@€’’’’*00x"$ & (_C:r0g25b750@Ą€’’’’,00x$ & ( *_C; r25g25b75@@Ą’’’’,00x$ & ( *_C< r50g25b75€@Ą’’’’,00x$ & ( *_C= r75g25b75Ą@Ą’’’’,00x$ & ( *_C> r88g25b75ą@Ą’’’’,00x$ & ( *_C? r100g25b75’’@Ą’’’’*00x"$ & (_C@r0g25b885@ąĄ’’’’,00x$ & ( *_CA r25g25b88@@ą’’’’,00x$ & ( *_CB r50g25b88€@ą’’’’,00x$ & ( *_CC r75g25b88Ą@ą’’’’,00x$ & ( *_CD r88g25b88ą@ąrwloP’’’’`r’’’’Z0808ØXBBPROCEDURE LOAD_BP IS M_ITEM_NAME VARCHAR2(100); M_MODULE_NAME VARCHAR2(60); M_BP_VALUE VARCHAR2(100); CURSOR C1 IS SELECT BT_ITEM_NAME,DECODE(:P_LANG_CODE,'ENG',BT_ENG_TEXT,BT_FOR_TEXT) FROM PR_BOILERPLATE_TEXT WHERE BT_MODULE_NAME = 'PR007'; BEGIN OPEN C1; LOOP FETCH C1 INTO M_ITEM_NAME,M_BP_VALUE ; EXIT WHEN C1%NOTFOUND; IF M_ITEM_NAME = 'CP_BANK' THEN :CP_BANK := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_BANKC_ACNT_NO' THEN :CP_BANKC_ACNT_NO := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_BANKC_CODE' THEN :CP_BANKC_CODE := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_BANK_ADDR1' THEN :CP_BANK_ADDR1 := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_BANK_ADDR2' THEN :CP_BANK_ADDR2 := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_BANK_ADDR3' THEN :CP_BANK_ADDR3 := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_BANK_NAME' THEN :CP_BANK_NAME := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_BANK_NAME1' THEN :CP_BANK_NAME1 := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_EMP_CODE' THEN :CP_EMP_CODE := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_EMP_NAME' THEN :CP_EMP_NAME := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_FP_LC_AMOUNT' THEN :CP_FP_LC_AMOUNT := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_END_OF_REP' THEN :CP_END_OF_REP := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_TOTAL' THEN :CP_TOTAL := M_BP_VALUE; END IF; END LOOP; CLOSE C1; END;L> &IntoS’’’’!0Ø=O&verS’’’’ 0Ø=O&ut’’’’ 0Ø=&To:’’’’*0Ø(=&Program Unit:’’’’"0Ø =&Line:m’’’’#0Ø!=&Count:’’’’"0Ø = &Apply’’’’0Ø= OKp’’’’"0Ø = Cancel’’’’!0Ø= &Help’’’’'0Ø%> PL/SQL Step’’’’"0Ø >&Mode:S’’’’!0Ø>&IntoS’’’’!0Ø>O&verS’’’’ 0Ø>O&ut’’’’ 0Ø>&To:’’’’*0Ø(>&Program Unit:’’’’"0Ø >&Line:m’’’’#0Ø!>&Count:’’’’"0Ø > &Apply’’’’0Ø> OKp’’’’"0Ø > Cancel’’’’!0Ø> &Help’’’’=0Ø;?!PL/SQL Stored Program Unit Editor’’’’60Ø4?Stored Program Unit EditorE’’’’$0Ø"?&Program’’’’$0Ø"?&Compile’’’’(0Ø&? &Incremental’’’’ 0Ø?&All’’’’30Ø1?&Program Unit Editor...’’’’20Ø0?PL/SQL &Interpreter...’’’’:0Ø8?&Stored Program Unit Editor...o’’’’70Ø5? Database &Trigger Editor...’’’’.0Ø,? Synta&x Palette...d’’’’A0Ø?? %&Find and Replace in Program Units...’’’’ 0Ø? &New’’’’!0Ø? &Savean’’’’#0Ø!?&Revert’’’’!0Ø?&Dropt’’’’"0Ø ?&Close’’’’!0Ø?He&lp’’’’"0Ø ?Owner:’’’’!0Ø?Name:’’’’(0Ø&? Not Modified’’’’10Ø/?Successfully Compiledro’’’’0800Ø (0’’’’0800Ø ‰@’’’’0800Ø ŠP’’’’(0000Ø&FG’’’’ 0800Ø4`p1DE`’’’’@r’’’’0800Ø ‘ą’’’’J0808ØH22function CF_LOCAL_CURRFormula return VARCHAR2 is CURSOR L_CURR IS SELECT PARA_VALUE FROM FP_PARAMETER WHERE PARA_ID = 'BASE.CURR'; V_CURR VARCHAR2(20); BEGIN OPEN L_CURR; FETCH L_CURR INTO V_CURR; CLOSE L_CURR; RETURN(V_CURR); END; TE’’’’0800Ø źš’’’’ā0808Øą ŹŹfunction CF_COMPANYFormula return VARCHAR2 is COMPANY VARCHAR2(40); begin SELECT SUBSTR(COMP_NAME,1,40) INTO COMPANY FROM FM_COMPANY WHERE COMP_CODE = :CP_COMP_CODE ; RETURN(NVL(COMPANY,'XX')); end;M_’’’’0800Ø w’’’’}0808Ø{ eefunction CF_CPMTHFormula return VARCHAR2 is PVAL NUMBER; PVAL1 VARCHAR2(10); begin SELECT to_char(to_date(to_number(PARA_VALUE),'YYYYMM'),'Mon-YYYY') INTO PVAL1 FROM PM_COMP_PARAMETER WHERE PARA_CODE = 'CPMTH' AND PARA_COMP_CODE = :CP_COMP_CODE; RETURN(NVL(PVAL1,'X')); end; ---to_char(to_date(to_number('199902'),'YYYY/MM'),'Mon-YYYY')NK_’’’’ 0800Ø 6!ž@; ELSIF M_ITEM_NAME = 'CP_BANK_NAME' THEN :CP_BANK_NAME := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_BANK_NAME1' THEN :CP_BANK_NAME1 := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_EMP_CODE' THEN :CP_EMP_CODE := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_EMP_NAME' THEN :CP_EMP_NAME := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_FP_LC_AMOUNT' THEN :CP_FP_LC_AMOUNT := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_END_OF_REP' THEN :CP_END_OF_REP := M_BP_VALUE; ELSIF M_ITEM_NAME = 'CP_TOTAL' THEN :CP_TOTAL := M_BP_VALUE; END IF; END LOOP; CLOSE C1; END;L> &IntoS’’’’!0Ø=O&verS’’’’ 0Ø=O&ut’’’’ 0Ø=&To:’’’’*0Ø(=&Program Unit:’’’’"0Ø =&Line:m’’’’#0Ø!=&Count:’’’’"0Ø = &Apply’’’’0Ø= OKp’’’’"0Ø = Cancel’’’’!0Ø= &Help’’’’'0Ø%> PL/SQL Step’’’’"0Ø >&Mode:S’’’’!0Ø>&IntoS’’’’!0Ø>O&verS’’’’ 0Ø>O&ut’’’’ 0Ø>&To:’’’’*0Ø(>&Program Unit:’’’’"0Ø >&Line:m’’’’#0Ø!>&Count:’’’’"0Ø > &Apply’’’’0Ø> OKp’’’’"0Ø > Cancel’’’’!0Ø> &Help’’’’=0Ø;?!PL/SQL Stored Program Unit Editor’’’’60Ø4?Stored Program Unit EditorE’’’’$0Ø"?&Program’’’’$0Ø"?&Compile’’’’(0Ø&? &Incremental’’’’ 0Ø?&All’’’’30Ø1?&Program Unit Editor...’’’’20Ø0?PL/SQL &Interpreter...’’’’:0Ø8?&Stored Program Unit Editor...o’’’’70Ø5? Database &Trigger Editor...’’’’.0Ø,? Synta&x Palette...d’’’’A0Ø?? %&Find and Replace in Program Units...’’’’ 0Ø? &New’’’’!0Ø? &Savean’’’’#0Ø!?&Revert’’’’!0Ø?&Dropt’’’’"0Ø ?&Close’’’’!0Ø?He&lp’’’’"0Ø ?Owner:’’’’!0Ø?Name:’’’’(0Ø&? Not Modified’’’’10Ø/?Successfully Compiledro’’’’0800Ø (0’’’’0800Ø ‰@’’’’0800Ø ŠP’’’’(0000Ø&FG’’’’ 0800Ø4`p1DEp’’’Ōl1 °$" žCF_AMT_IN_WORDSFORMULA¹function CF_AMT_IN_WORDSFormula return VARCHAR2 is M_AMT_IN_WORDS VARCHAR2(250); M_DUMM NUMBER ; begin M_DUMM := ROUND(:CS_COMP_BANK_TOTAL,2); --ABS added by shaibu on 31/01/2006 for fixing the issue id ORIONQC-GDC-814795. since -ve values will create problem in the F_CONV_AMOUNT_TO_WORDS procedure F_CONV_AMOUNT_TO_WORDS(:P_CURR_CODE ,ROUND(ABS(:CS_COMP_BANK_TOTAL),2), M_AMT_IN_WORDS); RETURN('('||M_AMT_IN_WORDS||')'); end; įt«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«ĶwÄ SYSSTANDARD %/Namespace0003/F_CONV_AMOUNT_TO_WORDS$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ088 8"PKG INIT"CF_AMT_IN_WORDSFORMULA"M_AMT_IN_WORDS"M_DUMM""Ź%()/246  ś ,@ŗ ’’$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08%LLLL76˜deedAA A ĄAeeźeźeeAAA‹eAA‹e"FUNCTION"CF_AMT_IN_WORDSFORMULA"RETURN"VARCHAR2"M_AMT_IN_WORDS"250"M_DUMM"NUMBER"ROUND"CS_COMP_BANK_TOTAL""2"F_CONV_AMOUNT_TO_WORDS"P_CURR_CODE"ABS"("||")"": #$(359:AIMPSWX_gkmquz~†‰Ž’“šŸ£¤©­®µø¼ĄĆČĢĶŅÖ×Üąåēėķōū '(+.6h,“ ±°£ cQ°£ ·  . „¼QW „¼. „. „¼Q eZ.|“.|“n nO¤µóóücQ¬¬¬¬Qc¬Qc¬  (   ')))///3HL     /) 8#’€ 7  €€€€€ś €€ €  €@ € ;„9 € C € <§:#$€B €&'€A€ ;„9 € ,-€./€K€12€G€F J ;„‚ <§€€€€>=?€ &!),€D€E€ €E0!€H"€I#€$€I3  +6!"*%)(0534(9:%)!"*3405.’’d:’’ 9’’«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0D »»*8 Ń 4äxŚ„&'„H $fEH@Ś§Ś„&'P$O&'P„X $f'XŅ,`,`` $`,;„,x;x„ tt% hg!č’čČP0CF_AMT_IN_WORDSFORMULA()N ,“øś(@¼Ō(HŲš(Pō (X((`,0ś|”˜° 5›µ dh p„§@@"(--.6=SELECT BT_ITEM_NAME,DECODE(:b1,''ENG'',BT_ENG_TEXT,BT_FOR_TEXT) FROM PR_BOILERPLATE_TEXT WHERE BT_MODULE_NAME = ''PR007''"»Œ˜0° HÄ `Ų xģ  Ø Ą( Ų8 šH\  p#š^Z`\Œ›”‹U]:@@€’’’’dr’’’’h0808Øf PPPROCEDURE F_CONV_AMOUNT_TO_WORDS(P_CURR_CODE IN VARCHAR2, P_AMOUNT IN NUMBER, P_AMOUNT_IN_WORDS IN OUT VARCHAR2) IS M_CURR_DECIMAL NUMBER(1) ; M_CURR_UNIT_NAME VARCHAR2(15) ; M_AMOUNT_DESC VARCHAR2(250) ; CURSOR C1 IS SELECT CURR_UNIT_NAME, CURR_DECIMAL FROM FM_CURRENCY WHERE CURR_CODE = P_CURR_CODE ; CURSOR C2 IS SELECT TRANSLATE((TO_CHAR(TO_DATE(DECODE( TRUNC(NVL(P_AMOUNT,0)/1000000),0,'', TRUNC(NVL(P_AMOUNT,0)/1000000)),'j'),'JSP') || DECODE(NVL(TRUNC(NVL(P_AMOUNT,0)/1000000),0), 0,'', ' MILLION ') || DECODE(NVL(P_AMOUNT,0) - TRUNC(NVL(P_AMOUNT,0) / 1000000) * 1000000, 0,'', (TO_CHAR(TO_DATE(TRUNC(NVL(P_AMOUNT,0)) - TRUNC(NVL(P_AMOUNT,0)/1000000) * 1000000, 'J'),'JSP'))) || DECODE((NVL(P_AMOUNT,0) * POWER(10, M_CURR_DECIMAL)) - (TRUNC(NVL(P_AMOUNT,0)) * POWER(10, M_CURR_DECIMAL)), 0, ' ', --Commented by Manjula for ORIONQC-GDC-814777 on 31/01/2006 ' And ' || M_CURR_UNIT_NAME || ' ' || TO_CHAR(TO_DATE((NVL(P_AMOUNT,0) * POWER(10, M_CURR_DECIMAL)) - (TRUNC(NVL(P_AMOUNT,0)) * POWER(10,M_CURR_DECIMAL)) , 'J'), 'JSP')) || ' ONLY '),'-',' ') "AMOUNT_IN_WORDS" FROM DUAL ; begin OPEN C1 ; FETCH C1 INTO M_CURR_UNIT_NAME, M_CURR_DECIMAL ; CLOSE C1 ; OPEN C2 ; FETCH C2 INTO M_AMOUNT_DESC ; CLOSE C2 ; P_AMOUNT_IN_WORDS := M_AMOUNT_DESC ; END;’’’’0800Ø žp’’’’Ń0808ØĻ¹¹function CF_AMT_IN_WORDSFormula return VARCHAR2 is M_AMT_IN_WORDS VARCHAR2(250); M_DUMM NUMBER ; begin M_DUMM := ROUND(:CS_COMP_BANK_TOTAL,2); --ABS added by shaibu on 31/01/2006 for fixing the issue id ORIONQC-GDC-814795. since -ve values will create problem in the F_CONV_AMOUNT_TO_WORDS procedure F_CONV_AMOUNT_TO_WORDS(:P_CURR_CODE ,ROUND(ABS(:CS_COMP_BANK_TOTAL),2), M_AMT_IN_WORDS); RETURN('('||M_AMT_IN_WORDS||')'); end;bpclmnopqprrpspwwxyz{0|0}0~00€0p‚‚ƒ„…†‡ˆp‰p‰‰Š‹Œpp’’“”•p–pŸŸ ”YPRINTJOBHYesP€LISPRINTJOB’’’’Ÿ/bpchijklmpnnpopwwxyz{0|0}0~00€0p‚‚ƒ„…†‡ˆp‰p‰‰Š‹Œpp’’“”•p–p››œZMODEGDefaultP€LISMODE&’’’’­/bpcnopqrspvvpwpzz{|}~00€00‚0ƒ0„pŠŠ‹ŒŽp‘p‘‘’“”p•pšš›œpžp©©Ŗ«[BACKGROUNDFtNoP€MODEBACKGROUND’’’’²/bpcopqrstpzzp{pƒƒ„…†‡0ˆ0‰0Š0‹0Œ0pŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p®®Æ°\ORIENTATIONENoDefaultP€ORIENTATION’’’’¢/bpcklmnoppvvpwpwwxyz{0|0}0~00€0p‚‚ƒ„…†‡ˆp‰p‰‰Š‹Œpp’’“”•p–pžžŸ ]DECIMALD€DECIMALan’’’’¤/bpcmnopqrpvvpwpwwxyz{0|0}0~00€0p‚‚ƒ„…†‡ˆp‰p‰‰Š‹Œpp’’“”•p–p  ”¢^THOUSANDSC€THOUSANDS’’’’£/bpclmnopqprrpspsstu vx0y0z0{0|0}0~p‚‚ƒ„…†‡ˆp‰p‰‰Š‹Œpp’’“”•p–pŸŸ ”_CURRENCYB€CURRENCY’’’’”/bpcjklmnoprrpspuuvwxy0z0{0|0}0~0p‚‚ƒ„…†‡ˆp‰p‰‰Š‹Œpp’’“”•p–pžŸ`COPIESA1€COPIES100’’’’°/bpcmnopqrpvvpwp||}~ €‚0ƒ0„0…0†0‡0ˆpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p¬¬­®aDESFORMAT@dflt€ESDESFORMAT’’’’¦/bpcklmnoppvvpwpwwxy z|0}0~00€00‚p††‡ˆ‰Š‹ŒppŽp‘p––—˜™pšp¢¢£¤bDESNAME?DESNAME’’’’’’®/bpcklmnoppvvpwp~~€‚0ƒ0„0…0†0‡0ˆpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢pŖŖ«¬cDESTYPE>ScreenPDESNDESTYPEb7’’’’·/bpctuvwxypzzp{p{{|}~0€00‚0ƒ0„@ŠpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p³³“µ“P_BASE_NO_OF_DECI DESNP_BASE_NO_OF_DECg25b88€@ą’’’’,00x $ & (*C r75g25b88Ą@ą0800Ø4`p1DE’’’Ōl1 °$"CF_BRACKETFORMULAyfunction CF_BRACKETFormula return Char is begin :CP_OPEN_BRACKET := '('; :CP_CLOSE_BRACKET := ')'; RETURN(''); end;©A«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«ĶwÄ SYSSTANDARD $«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08!"PKG INIT"CF_BRACKETFORMULA""v6’’$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08 ****Ē TŠeeAeeAAA‹eAA‹eAA‹eO"FUNCTION"CF_BRACKETFORMULA"RETURN"CHAR"CP_OPEN_BRACKET""("CP_CLOSE_BRACKET")""ō #$(357;BGKRW[^ceikry…ˆ‹“—š £«®±¹¼æh,“ ±· ¼n ¼neZnO¤µóóücQücQQcQcQc # ’€   ¬# ­ &  ))¬­€€€2€€ €2€! €" € €" €$ €%€€%€'€(€€( "’’d’’’’«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0D 77/H " ¬äx„Ū¬„Ū­„0$ hg!ø’ø˜L0CF_BRACKETFORMULA`()…,h¬…lØ­&1`h0p¬­@@%NOTFOUND THEN :CP_COMP_ADD_1 := NULL; :CP_COMP_ADD_2 := NULL; :CP_COMP_ADD_3 := NULL; END IF; CLOSE C_COMP; END IF; IF NVL(LOGO_YN,'N') = 'Y' THEN :CP_TITLE_11A := :P_TITLE_11; ELSE :CP_TITLE_11A := NULL; END IF; OPEN B1; FETCH B1 INTO :CP_M_CPMTH; CLOSE B1; IF C_GET_BANK_CURRENCY%ISOPEN THEN CLOSE C_GET_BANK_CURRENCY ; END IF; OPEN C_GET_BANK_CURRENCY ; FETCH C_GET_BANK_CURRENCY INTO M_CURR_CODE ; CLOSE C_GET_BANK_CURRENCY ; :P_CURR_CODE := M_CURR_CODE ; M_NOTE := TO_CHAR(TO_DATE(:CP_VALUE_DATE),'MONTH YYYY'); :P_TITLE_34 := 'Salary Transfer for the Month of'||' '||M_NOTE ; SELECT INITCAP(TO_CHAR(TO_DATE(:CP_VALUE_DATE),'MONTH DD, YYYY')) INTO :P_DATE FROM DUAL; LOAD_BP; RETURN (TRUE); END; xئrwwt_Expresswizard£”vgmisq_helpstringžœrwbwvpulmenuˆ†rwlfs_helpstring|zrwlbstringqorwdqe_helpstringjhrwbwolwindowKIrwbwdowindow,*!rwbwfewindow*(Yrwbwetwindow)'rwbwtpwindow%#lrwbhrewindow#!rwbwtrwindow" rwbwfi1windowrwbwcmwindowrwbwdiwindow#rwbwmrwindowrwbwrgwindowrwbwcnwindow  rwbwsrwindow  rwbwgiwindow  HyperlinksWWbox½»MatrixCellbox¬Ŗ rwbwmfwindow”Ÿ vgmitx_helpstringŸvgmirt_helpstring—•vgmigr_helpstring“‘rwlo ’’’’hr’’’’½0808Ø»„„1 °$ „F_DATEFORMATTRIGGERkfunction F_dateFormatTrigger return boolean is begin --FORMAT_DATE.SET_DATE_FORMAT; return (TRUE); end;ķA«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«ĶwÄ SYSSTANDARD $«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08"PKG INIT"F_DATEFORMATTRIGGER""n’’$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08J 3"FUNCTION"F_DATEFORMATTRIGGER"RETURN"BOOLEAN"TRUE""( #$(357;>BDHh,“ ±·eZ O¤µ % ’€   €€ ’’d«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0D    „% hg!t’tdL0F_DATEFORMATTRIGGER `@@’’’’0000Ø}kkfunction F_dateFormatTrigger return boolean is begin --FORMAT_DATE.SET_DATE_FORMAT; return (TRUE); end;R’’’’0800؁&'()VG_COLORCELLID)@’’’’-pp &()*+VG_COLORNAME_SET@ zŠ’’’’/pp (*+,-VG_COLORNAME_LENGTH “’’’’/pp (*+,-VG_COLORCOLOR_NAMExU’’’’'pp "#$%VG_COLORRED B’’’’)pp "$%&'VG_COLORGREEN P ’’’’)pp "$%&'VG_COLORBLUE ’’’’' x% = APTH_CR_DT ’’’’2 x0) ™===================++ ’’’’ x€Rž=(v’’’’. x,SQ_Q 1 Apth Txn CodePA’’’’. x,aQ 1 Apth Ref FromPA’’’’. x,cQ 1 Tt Short DescE’’’’2 x00ŗeQ 1 Apth Cont Sign Dtą’’’’. x,0ģuQ 1 Apth Emp Code@ž’’’’, x*A&yQ 1 Apth Amd No’’’’2 x0}Q 1 Apth Amd Res Code`’’’’# x! Ė======’’’’É xĒ@ ­============================================================================================================================================================================TU’’’’ x_C ž==M’’’’Ā xĄP_ ¦=====================================================================================================================================================================_’’’’  xDD ===’’’’Į xæ1 „====================================================================================================================================================================’’’’ x…=’’’’' x%to*\ ATTENTION i’’’’ x*\:’’’’% x#Ed*\ MANAGER’’’’† x„nt*wjPlease credit the payee's account without any deductions and debit our account with any charges of your ’’’’M xK*w1correspondent banks related to these transfers. Rev’’’’- x+Ø*{Sincerely Yours "’’’’4 x2*†Authorized Signatories ’’’’ x*Ų1.’’’’ x’’*Ś2.’’’’ x+of’’’’E xCt + )Total No of Pages Including this Page : lly’’’’% x#8+# Page : 0’’’’# x! ‰,Ref :0800Ø ŠP’’’’(0000Ø&FG’’’’ 0800Ø4`p1DE°’’’Ōl1 °$" —F_2_FP_FC_AMOUNT1FORMATTRIGGERNfunction F_2_FP_FC_AMOUNT1FormatTrigger return boolean is MASK VARCHAR2(20); begin SRW.REFERENCE(:Q_2_EMP_CURR_CODE1); SRW.REFERENCE(:Q_2_FP_FC_AMOUNT1); FORMAT_FC_NUMBER.FIND_FC_MASK(:Q_2_EMP_CURR_CODE1); FORMAT_FC_NUMBER.SET_FC_MASK(:Q_2_FP_FC_AMOUNT1,MASK); FORMAT_NUMBER.SET_FIELD_FC(MASK); return (TRUE); end; Ż»«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«ĶwÄ SYSSTANDARD SRW FORMAT_FC_NUMBER xj %PAYUSERFORMAT_FC_NUMBER /LInsrepplFORMAT_NUMBER $«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08 + /"PKG INIT"F_2_FP_FC_AMOUNT1FORMATTRIGGER"MASK""ž#&')  ( ’’$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08CCCC(deedAA“Ā8@ eeAČ"FUNCTION"F_2_FP_FC_AMOUNT1FORMATTRIGGER"RETURN"BOOLEAN"MASK"VARCHAR2"20"SRW"REFERENCE"Q_2_EMP_CURR_CODE1""Q_2_FP_FC_AMOUNT1"FORMAT_FC_NUMBER"FIND_FC_MASK"SET_FC_MASK"FORMAT_NUMBER"SET_FIELD_FC"TRUE""„ #$(359:AIMPSUZ]aefmruy}~…Š‘•–¢„©­®µ¹¾ĮÅÉŹĪŅÕŁŪßįčļ÷ūž     h,“ ±°£ cQ·Wk  „¼Wk  „¼Wk  „¼Wk  „¼ Wk  „ eZ O¤µóóücQ¬¬¬¬¬  0"!4 6’€ 5  €€€€€>€ € 9£7? € € =¢8"@ ! € € 9£7%(A&' €€ =¢8 ,/B-.€€ 23€€ 9£‚ =¢‚€€;:<€ €€!#&  $+14#)*078#)*0(’’d7’’8’’ «Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0D ”” ƒ ŌälŚ£ &' <<%Ś¢ &' %Ś£  "{tlŚ¢  Ņ(@@"{tč@(&'($„% hg!Š’4Š˜X0F_2_FP_FC_AMOUNT1FORMATTRIGGERø|xj % FORMAT_FC_NUMBERPAYUSERFIND_FC_MASKFFORMAT_FC_NUMBER4ųxj % FORMAT_FC_NUMBERPAYUSERSET_FC_MASKFOFORMAT_FC_NUMBER+(Œ¬@°Š Tl  pˆ0L^ › h£¢@@"M_ITEM_NAME"VARCHAR2"100"M_MODULE_NAME"60"M_BP_VALUE"CURSOR"C1"BT_ITEM_NAME"DECODE"P_LANG_CODE""ENG"BT_ENG_TEXT"BT_FOR_TEXT"PR_BOILERPLATE_TEXT"BT_MODULE_NAME"="PR007"OPEN"LOOP"EXIT"NOTFOUND"CP_BANK"ELSIF"CP_BANKC_ACNT_NO"CP_BANKC_CODE"CP_BANK_ADDR1"CP_BANK_ADDR2"CP_BANK_ADDR3"CP_BANK_NAME"CP_BANK_NAME1"CP_EMP_CODE"CP_EMP_NAME"CP_FP_LC_AMOUNT"CP_END_OF_REP"CP_TOTAL"CLOSE""  #$/156=EILOST[cgjmqry…ˆ‹Ÿ£¤Æ±³ø¾ĀĆĒĢŠŃŲŻįåģķńöśū’   "'+/37;AEIMPTY]^bgimtx|…†Š‘•œ ¤©­®²·¹½ÄĄ’’’Ōl1 °$"§R_EMP_SAL_LEVEL1FORMATTRIGGER³function R_EMP_SAL_LEVEL1FormatTrigger return boolean is begin IF NVL(:Q_2_FP_FC_AMOUNT1,0) <= 0 THEN return (FALSE); ELSE return (TRUE); END IF; RETURN NULL; end;‘A«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«ĶwÄ SYSSTANDARD $«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08)"PKG INIT"R_EMP_SAL_LEVEL1FORMATTRIGGER""nv’’$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08 ((((›< 9ŽAA _"FUNCTION"R_EMP_SAL_LEVEL1FORMATTRIGGER"RETURN"BOOLEAN"NVL"Q_2_FP_FC_AMOUNT1""0"<="FALSE"TRUE""® #$(357:>CGHMQRY\_aehlprvy}‚„ˆŠ‘™šh,“ ±·<.|“. „¼QQ·eZ ·eZ eMO¤µó¬¬ /  #%    #’€ "  €' € €&€ %¢$€€ € €  € €  %¢‚ € € ! $’’d$’’«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0D ww Z °ätŚ¢.„&'  $L.„( (!„%'„%0% hg!Č’Č X0R_EMP_SAL_LEVEL1FORMATTRIGGER+Tl pˆ(Œ¤0ج8PJ[fqlp¢@@ 8)7 8)7 8)75%70 $ Ō½|’;Ó   €€€€€d €€€ € €<  € € €€€d " "’!#$:""&$'#(1 €+,€" € ć#Õ!€€249"€56€€€"=;>?* A#;"@CADE & I@@AJK€ )ANS@LOP€.€7 -:MUVS ēšÖX]@LYZ€2€< 1?W_` ] ė^×bg@Lcd€6€A 5Daij g ļZŲlq@Lmn €:!€F 9Ikstq ó`Łv{@Lwx"€>#€K =Nu}~{ ÷\Ś€…@L‚$€B%€P AS‡ˆ… ūŒŪŠ@L‹Œ&€F'€U E X‰‘’ ’›Ü”™@L•–(€J)€Z !I!]“›œ™! ”Żž£@LŸ *€N+€_ "M"b„¦£" ‹ŽØ­@L©Ŗ,€R-€d #Q#g§Æ°­# Uß²·@L³“.Š’’’Ōl1 °$"ŅCF_BANK_DTLSFORMULAōfunction CF_BANK_DTLSFormula return Char is CURSOR C1 IS SELECT NVL(BANK_ADD3,BANK_CODE)||'('|| TXNFIELD_FLD1||')' BNK_DTLS FROM PM_EMP_PAY, PT_TXN_FLEX_FIELDS, PM_BANK WHERE EMPY_CODE = TXNFIELD_EMP_CODE(+) AND BANK_CODE = EMPY_BANK_CODE AND EMPY_CODE = :Q_2_EMPY_CODE1 AND TXNFIELD_BLOCK_NUM =2; M_DTLS VARCHAR2(2000); BEGIN IF C1%ISOPEN THEN CLOSE C1; END IF; OPEN C1; FETCH C1 INTO M_DTLS; CLOSE C1; RETURN (M_DTLS); END; …£«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«ĶwÄ SYSSTANDARD xj  ;PAYUSER PM_EMP_PAYxj  PAYUSERPT_TXN_FLEX_FIELDSxj   PAYUSERPM_BANK$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08L?"PKG INIT"CF_BANK_DTLSFORMULA"C1""BNK_DTLS"M_DTLS""'-/58>ABDFHJ    Š IJ&  ’’$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ088!ˆˆˆˆYäŠeźeźeźeŁ;#e $ e™  $# $  ų AeedAA eeAAA‹eAA‹eee"FUNCTION"CF_BANK_DTLSFORMULA"RETURN"CHAR"CURSOR"C1"NVL"BANK_ADD3"BANK_CODE"||"("TXNFIELD_FLD1")"BNK_DTLS"PM_EMP_PAY"PT_TXN_FLEX_FIELDS"PM_BANK"EMPY_CODE"TXNFIELD_EMP_CODE"="(+)"EMPY_BANK_CODE"Q_2_EMPY_CODE1""TXNFIELD_BLOCK_NUM"2"M_DTLS"VARCHAR2"2000"ISOPEN"CLOSE"OPEN""ņ #$(35:IMNY[]bhlmotxy~‚ƒˆŒ’–—›Ÿ¤Ø­±ø¹½ĮÅŹĻŌŁŻŽāēźėļōųłż   $'(,018@DGJLOSW[_afhlquyzƒ‡‹”–šž”„§«­“¼ĄĆĘĒČÉŹĖĢĻŅŚŪÜßāźėó÷ų’h,“ ±½ōČ“±·é劬¹.|“.|“.|“. „  n n ī²   .|“ .~“  .|“   .|“ ¼ .|“ Q¬¤°£ cQ·<  ·éĮ éŻ ³éÓ  éĮ eZ O¤µóücQ¬¬¬¬¬¬Qc¬¬Qc¬`°£¬       % 8 ( # %+:>       !!!"   ! nW;’€ Sm    ’ K ƒ('€‚ € €~ € €} € !€y € € € | €   €)-J€€€.DE€/>?€089€12€u€€56€t€€:;€v€ €€@A€w€" €pØoFG!€x"€%#€$€MO (OPQ%€&€Q'€R(€)€Š*1SVYTWX*€ 3U[Y\ ^S_`‡ bScd 5NgSh jSkONp؂+€,€rqs-€9=@CFI .€z/€{0€1€{LO 2€3€€4€5€€RU…6€77€ƒ L&%$"#*+,3ą’’’Ōl47<=BCHINT]afilUZe†7o34<=BCHI"#$%&„2’’do’’† N«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0P ppTJh 0ä”x  s#/w u  s $ hg! r„{t gd×gdØtgd €!ü’”ü¼`h:=8@T€dCF_BANK_DTLSFORMULA`% HL  P,Š4D!59DR=SELECT NVL(BANK_ADD3,BANK_CODE) || ''('' || TXNFIELD_FLD1 || '')'' BNK_DTLS FROM PM_EMP_PAY,PT_TXN_FLEX_FIELDS,PM_BANK WHERE EMPY_CODE = TXNFIELD_EMP_CODE (+) AND BANK_CODE = EMPY_BANK_CODE AND EMPY_CODE = :b1 AND TXNFIELD_BLOCK_NUM = 2"Ø@@ges) { jump_index = num_pages; new_page(form, jump_index); } } /* go to the user specified page number */ function pagenum(form) { /* sanity check */ if (form.reqpage.value < 1) { form.reqpage.value = 1; } if (form.reqpage.value > num_pages) { form.reqpage.value = num_pages; } jump_index = form.reqpage.value; new_page(form, jump_index); }
’’’’ 0800ØĖZžP’’’’ 0800ØŽ(ž`€’’’’0800Ø[ ’’’’0800Ø  ’’’’0800Ø°’’’’ 0800ØĶ0žĄš’’’’0800ØA ’’’’N0808ØL 661 °$ 6F_DATEFORMATTRIGGERķA«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«ĶwÄ SYSSTANDARD $«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08"PKG INIT"F_DATEFORMATTRIGGER""n’’$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08J 3"FUNCTION"F_DATEFORMATTRIGGER"RETURN"BOOLEAN"TRUE""( #$(357;>BDHh,“ ±·eZ O¤µ % ’€   €€ ’’d«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0D    „% hg!t’tdL0F_DATEFORMATTRIGGER `@@’’’’0800Ø  ’’’’x*€*€6€6€?B(F J€JąV(Z€Ząf(j€j€j(n(r(vf RUNONLY trPR007CRy }.itur Cu@Pnt No˜v˜™’’’’ pInsreppląV(’’’’S N¢¦(Ŗ0«¬²@¶@ŗ0»0¾@Ā@Ę@Ź@Ī@Ņ@Ö0×0ŲŁŚ0Ū0Ü8Ž8ąįpįpāpāćäåęēčź ģ0ķ0īļš8ņ8ō0õöų śūüżž@A11 AAAAAA"1#1&A*A.1/12A6A:A>ABAFAJ1K1LMNOPQdp‘ś<Ģ †°­PB==@!@`@`8Śs  «ījjv. †°­PBW2@`@`@` †°­PB@`@`@` ’’’’ 00 N’’’’ 00 NUš’’’’Dr’’’’0000Ø‹yyfunction CF_BRACKETFormula return Char is begin :CP_OPEN_BRACKET := '('; :CP_CLOSE_BRACKET := ')'; RETURN(''); end;p A’’’’0800Ø —°’’’’f0808ØdNNfunction F_2_FP_FC_AMOUNT1FormatTrigger return boolean is MASK VARCHAR2(20); begin SRW.REFERENCE(:Q_2_EMP_CURR_CODE1); SRW.REFERENCE(:Q_2_FP_FC_AMOUNT1); FORMAT_FC_NUMBER.FIND_FC_MASK(:Q_2_EMP_CURR_CODE1); FORMAT_FC_NUMBER.SET_FC_MASK(:Q_2_FP_FC_AMOUNT1,MASK); FORMAT_NUMBER.SET_FIELD_FC(MASK); return (TRUE); end; ™’’’’0800اĄ’’’’Ė0808Øɳ³function R_EMP_SAL_LEVEL1FormatTrigger return boolean is begin IF NVL(:Q_2_FP_FC_AMOUNT1,0) <= 0 THEN return (FALSE); ELSE return (TRUE); END IF; RETURN NULL; end;’’’’ 0800ØŅŠą’’’’ 0808Ø ōōfunction CF_BANK_DTLSFormula return Char is CURSOR C1 IS SELECT NVL(BANK_ADD3,BANK_CODE)||'('|| TXNFIELD_FLD1||')' BNK_DTLS FROM PM_EMP_PAY, PT_TXN_FLEX_FIELDS, PM_BANK WHERE EMPY_CODE = TXNFIELD_EMP_CODE(+) AND BANK_CODE = EMPY_BANK_CODE AND EMPY_CODE = :Q_2_EMPY_CODE1 AND TXNFIELD_BLOCK_NUM =2; M_DTLS VARCHAR2(2000); BEGIN IF C1%ISOPEN THEN CLOSE C1; END IF; OPEN C1; FETCH C1 INTO M_DTLS; CLOSE C1; RETURN (M_DTLS); END; ĖĢ–CP_FP_LC_AMOUNTP„ŗh’™fCp Adp Ref Txn Codedp€]'CP_FP_LC_AMOUNT’’’’’’Ļ/ bpduvwxyzp~~pp€‚ƒ0„0…@†8Š8Œ8Žp(¢¦§ ØŖ«¬p­p­­®Æ°p±p¶¶·ø¹pŗpĖĖĢĶ—CP_BANKC_ACNT_NOP„»p™fCp Adp Remarksdp€^'CP_BANKC_ACNT_NO„’’’’¼/ bpdnopqrspvvpwpwwxyz{0|0}0~8€8‚8„p†(–š› œžŸ p”p””¢£¤p„pŖŖ«¬­p®pøø¹ŗėCP_FM_EMPPU U™fCp From Dtp Adp† N'^'CP_FM_EMP’’’’ø/ bpdnopqrspvvpwpwwxyz{0|0}0~8€8‚8„p†(’–— ˜š›œppžŸ p”p¦¦§Ø©pŖp““µ¶ģCP_TO_EMPPU«™fCp To Dttp† O'CP_TO_EMP’’’’Å/ bpdopqrstpzzp{p{{|}~0€00‚8„8†8ˆpŠ(ž¢£ ¤¦§Øp©p©©Ŗ«¬p­p²²³“µp¶pĮĮĀĆķCP_FM_DIVNPU™fCp From Txn Code€J'O_EMCP_FM_DIVNŠ‹’’’’Å/ bpdopqrstpzzp{p{{|}~0€00‚8„8†8ˆpŠ(ž¢£ ¤¦§Øp©p©©Ŗ«¬p­p²²³“µp¶pĮĮĀĆīCP_TO_DIVNPU ™fCp To Txn Codee€K'O_EMCP_TO_DIVN±p²’’’’Į/ bpdopqrstpzzp{p{{|}~0€08‚8„8†8ˆpŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²p½½¾æļCP_FM_DEPTP«U™fCp From Noodee€L'CP_FM_DEPT±p²’’’’½/ bpdopqrstpzzp{p{{|}~0€08‚8„8†8ˆpŠ(–š› œžŸ p”p””¢£¤p„pŖŖ«¬­p®p¹¹ŗ»šCP_TO_DEPTP«"™fCp To Nooo€M'CP_TO_DEPTÆ°’’’’Ć/ bpdqrstuvpzzp{p{{|}~0€00‚8„8†8ˆpŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pææĄĮmCP_TITLE_11APU&U™fCp Title 11a€t'CP_TITLE_11A°’’’’Ć/ bpdqrstuvpzzp{p{{|}~0€08‚8„8†8ˆpŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pææĄĮyCP_BASE_CURRP@Sé™fCp Base Curr€'CP_BASE_CURRØ’’’’Ä/ bpdrstuvwpzzp{p{{|}~0€08‚8„8†8ˆpŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pĄĄĮĀzCF_LOCAL_CURR@M<™fCf Local Curr @'CF_LOCAL_CURR’’’’®/ bpdlmnopqprrpspsstuvw0x0y8z8|8~8€p‚(ŠŽ ’“”p•p••–—˜p™pžžŸ ”p¢pŖŖ«¬„CP_DEDNP«(«™fCp Dedn€v'@ CP_DEDN®’’’’Į/ bpdopqrstpzzp{p{{|}~0€08‚0„8†8ˆpŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²p½½¾æÕCP_FM_LOCNPP5YXD™fCp From Locn€~'CP_FM_LOCNŠpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p³³“µ“P_BASE_NO_OF_DECI DESNP_BASE_NO_OF_DECg25b88€@ą’’’’,00x $ & (*C r75g25b88Ą@ą0800Ø4`p1DE’’’Ōl1 °$"yCF_AMTINWORDSFORMULA®function CF_AMTINWORDSFormula return CHAR is M_AMT_IN_WORDS VARCHAR2(2000); M_DUMM NUMBER ; begin M_DUMM := ROUND(:CF_1,2); --ABS added by shaibu on 31/01/2006 for fixing the issue id ORIONQC-GDC-814795. since -ve values will create problem in the F_CONV_AMOUNT_TO_WORDS procedure F_CONV_AMOUNT_TO_WORDS(:P_CURR_CODE ,ROUND(ABS(:CF_1),2), M_AMT_IN_WORDS); RETURN(('UAE Dirhams'||' '||INITCAP(M_AMT_IN_WORDS))); end; it«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«ĶwÄ SYSSTANDARD %/Namespace0003/F_CONV_AMOUNT_TO_WORDS$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ088 6"PKG INIT"CF_AMTINWORDSFORMULA"M_AMT_IN_WORDS"M_DUMM""Ź%()/246  Š ,@Ö ’’$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08(QQQQE:¤ŠeedAA A ĄAeeeźeźeļeeAAA‹eAA‹e„"FUNCTION"CF_AMTINWORDSFORMULA"RETURN"CHAR"M_AMT_IN_WORDS"VARCHAR2"2000"M_DUMM"NUMBER"ROUND"CF_1""2"F_CONV_AMOUNT_TO_WORDS"P_CURR_CODE"ABS"UAE Dirhams"||" "INITCAP""† #$(359:AIMPSWX_gkmquz~†‰Ž’“šŸ£¤©­®µø¼ĄĆĘĖĻŠÕŁŚßäéķīņōųś"#$%&),47:BCDh,“ ±°£ cQ°£ ·  . „¼QW „¼. „. „¼Q eZZ.|“.|“nn. „ O¤µóóücQ¬¬¬¬QcQc¬¬¬   &   )))///3:>    ( /) <'’€ ;  €€€€€Š €€ €  €D € ?²= € G € @§>#$€F €&'€E€ ?²= € ,-€.€/0€P€23€N€JM78€O€!  ?²‚ @§€€€€BAC€ *%-0 € H!€I"€#€I$€K%€L&€'€L4#7  +:!"*%)(164599(=>%)!"*4516.’’d>’’ =’’«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0D ××*8 ż ä|Ś²&'„H $fEH@Ś§Ś²&'P$O&'P„X $f'XŅ,`,`` $`,;„„ x&',Ó’||$1;x|tt$ hg!ų’ųŲL0CF_AMTINWORDSFORMULA` UAE Dirhams [ ,ȤŠ(@ØĄ(HÄÜ(Pąų(Xü Ø` ōŠØ|ųüŃØ¬Ä 5› Ń `d  t²§@@  %)*-./0378<@ĻŅBHLFG MWaku‰“§±»ÅQRT[\^efhopryz|ƒ„†Ž—˜š”¢¤«¬®µ¶øæĄĀÉŹĢ)&ÕÖ×ŲŁŚŪÜŻŽßąįā78-./0$'QR[\efopyzƒ„Ž—˜”¢«¬µ¶æĄÉŹ%’’’’r’’’’‹0808؉ss1 °$"s CF_1FORMULAQfunction CF_1Formula return Number is begin :P_1 := :CS_1; RETURN(:P_1); end;ÉA«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«ĶwÄ SYSSTANDARD $«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08!"PKG INIT"CF_1FORMULA""r 8’’$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08} /"FUNCTION"CF_1FORMULA"RETURN"NUMBER"P_1""CS_1""Ī #$(357;BIMPWY]_fmuh,“ ±· ¼¼eZ¼O¤µóó    ’€   °± °°±‚€€€€ "’’d’’’’«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0D 99 Ī LäXŚ± E Ū°Ś°E% hg!Œ’ŒtD0 CF_1FORMULA, 0H=!=3=°±@@CompCF_CPMTH’’’’Č/ bpd{| ~€ ‚„pŠŠp‹p‹‹Œ Ž0‘0’0“0”0•0–pšš›œžŸ p”p””¢£¤p„pŖŖ«¬­p®pÄÄÅĘ)ļQ_2_EMPY_BANK_REMARKS1J?)šŠ!'Q_2_EMPY_BANK_REMARKS’’’’“/ bpdst vx z|p‚‚pƒpƒƒ„…†‡0ˆ0‰0Š0‹0Œ0pŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p°°±²*"Q_2_EMPY_CODE1AJ1*#J?!ØQ_2_EMPY_CODE’’’’Ń/ bpdxy z| ~€p††p‡p‡‡ˆ‰Š‹0Œ00Ž000‘p’ ¦Ø© Ŗ¬­®pÆpÆÆ°±²p³p¶¶·ø¹pŗpĶĶĪĻ*(Q_2_COMP_BANK_CODE1*,*)Q 2 Comp Bank Code1ź`¦'PYQ_2_COMP_BANK_CODE(’’’’ä/ bpd{| ~€ ‚„pŠŠp‹p‹‹ŒŽ00‘0’0“0”0•p–(²¶· øŗ»¼p½p½½¾æĄpĮpĘĘĒČÉpŹpąąįā**Q_2_COMP_BANK_ACNT_NO1*,*+Q 2 Comp Bank Acnt No1† '_BANQ_2_COMP_BANK_ACNT_NO’’’’·/ bpdvw xz |~p‚‚pƒpƒƒ„…†‡0ˆ0‰0Š0‹0Œ0pŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p³³“µ*-Q_2_FP_FC_AMOUNT1J*.!&¢CompQ_2_FP_FC_AMOUNT’’’’Õ/ bpdxy z| ~€p††p‡p‡‡ˆ‰Š‹0Œ00Ž000‘p’(¦Ŗ« ¬®Æ°p±p±±²³“pµpŗŗ»¼½p¾pŃŃŅÓ*@Q_2_COMP_BANK_NAME1*,**AQ 2 Comp Bank Name1† ''Q_2_COMP_BANK_NAMEAdd’’’’ē/ bpd~ €‚ „†pŠŠp‹p‹‹ŒŽ00‘0’0“0”0•p–(²¶· øŗ»¼p½p½½¾æĄpĮpĘĘĒČÉpŹpććäå*BQ_2_COMP_BANK_SHORT_NAME1*,*CQ 2 Comp Bank Short Name1† 'COMPQ_2_COMP_BANK_SHORT_NAMEK’’’’Ö/ bpdxy z| ~€p††p‡p‡‡ˆ‰Š‹0Œ00Ž000‘p’(¦Ŗ« ¬®Æ°p±p±±²³“pµpŗŗ»¼½p¾pŅŅÓŌ*DQ_2_COMP_BANK_ADD_4*,*EC*Q 2 Comp Bank Add 4† ''Q_2_COMP_BANK_ADD_1pd’’’’Ö/ bpdxy z| ~€p††p‡p‡‡ˆ‰Š‹0Œ00Ž000‘p’(¦Ŗ« ¬®Æ°p±p±±²³“pµpŗŗ»¼½p¾pŅŅÓŌ*FQ_2_COMP_BANK_ADD_1*,*GC*Q 2 Comp Bank Add 1† ''Q_2_COMP_BANK_ADD_2ps’’’’Ö/ bpdxy z| ~€p††p‡p‡‡ˆ‰Š‹0Œ00Ž000‘p’(¦Ŗ« ¬®Æ°p±p±±²³“pµpŗŗ»¼½p¾pŅŅÓŌ*HQ_2_COMP_BANK_ADD_2*,*IC*Q 2 Comp Bank Add 2† ''Q_2_COMP_BANK_ADD_3‘’“”p•p••–—˜p™pžžŸ ”p¢p³³“µ“P_BASE_NO_OF_DECI DESNP_BASE_NO_OF_DECg25b88€@ą’’’’,00x $ & (*C r75g25b88Ą@ą0800Ø4`p1DE ’’’’Xr’’’’e0000ØcQQfunction CF_1Formula return Number is begin :P_1 := :CS_1; RETURN(:P_1); end;JQ_’’’’0800Øy’’’’Ę0808ØÄ®®function CF_AMTINWORDSFormula return CHAR is M_AMT_IN_WORDS VARCHAR2(2000); M_DUMM NUMBER ; begin M_DUMM := ROUND(:CF_1,2); --ABS added by shaibu on 31/01/2006 for fixing the issue id ORIONQC-GDC-814795. since -ve values will create problem in the F_CONV_AMOUNT_TO_WORDS procedure F_CONV_AMOUNT_TO_WORDS(:P_CURR_CODE ,ROUND(ABS(:CF_1),2), M_AMT_IN_WORDS); RETURN(('UAE Dirhams'||' '||INITCAP(M_AMT_IN_WORDS))); end;/ bpdwx z| ~€p††p‡p‡‡ˆ‰Š‹0Œ00Ž000‘p’’“”•–—˜p™p™™š›œpp¢¢£¤„p¦p¹¹ŗ»*PQ_2_EMP_BANK_ADD_1M*9*QM*!Q_2_EMP_BANK_ADD_2’’’’½/ bpdwx z| ~€p††p‡p‡‡ˆ‰Š‹0Œ00Ž000‘p’’“”•–—˜p™p™™š›œpp¢¢£¤„p¦p¹¹ŗ»*RQ_2_EMP_BANK_ADD_2M*9*SM*!Q_2_EMP_BANK_ADD_3’’’’ø/ bpdvw xz |~p‚‚pƒpƒƒ„…†‡0ˆ0‰0Š0‹0Œ0pŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p““µ¶*ŅCS_EMP_BANK_TOTAL*9**-((&¤CS_EMP_BANK_TOTAL’’’’¼/ bpdwx z| ~€p††p‡p‡‡ˆ‰Š‹0Œ00Ž000‘p’’“”•–—˜p™p™™š›œpp¢¢£¤„p¦pøø¹ŗ*ÓQ_2_EMP_CURR_CODE1*J**Ō !£Q_2_EMP_CURR_CODE’’’’Õ/ bpdwx z| ~€p† †pˆpˆˆ‰Š‹Œ00Ž000‘0’p“(¦Ŗ« ¬®Æ°p±p±±²³“pµpŗŗ»¼½p¾pŃŃŅÓ*ęCS_COMP_BANK_TOTAL**,**-*,(&Cs Comp Bank Total_„'ECS_COMP_BANK_TOTAL’’’’Ę/ bpdtu vxyzp~~pp€‚ƒ0„0…0†0‡0ˆ0‰pŠ(šžŸ  ¢£¤p„p„„¦§Øp©p®®Æ°±p²pĀĀĆÄ+xCF_AMT_IN_WORDS*,*śCf Amt In Words† '„'CF_AMT_IN_WORDSp„’’’’¦/ bpdpqrstupvvpwpwwxyz{0|0}0~00€0p‚‚ƒ„…†‡ˆp‰p‰‰Š‹Œpp’’“”•p–p¢¢£¤+zP_CURR_CODEW §mt IP_CURR_CODE0Œ’’’’Å/ bpd{|}~€p††p‡p‡‡ˆ‰Š‹0Œ08Ž88’8”p––—˜™š›œppžŸ p”p¦¦§Ø©pŖpĮĮĀĆ+łCP_FROM_COMP_BANK_CODE4§ 0U/¼™f©CP_FROM_COMP_BANK_CODE®pÆ’’’’æ/ bpdyz{|}~p‚‚pƒpƒƒ„…†‡0ˆ0‰8Š8Œ8Ž8p’’“”•–—˜p™p™™š›œpp¢¢£¤„p¦p»»¼½+śCP_TO_COMP_BANK_CODE5 03/¼™fŖCP_TO_COMP_BANK_CODE”’’’’°/ bpdrstuvwpzzp{p{{|}~0€08‚8„8†8ˆpŠŠ‹ŒŽp‘p‘‘’“”p•pšš›œpžp¬¬­®+ūCP_VALUE_DATE6 0U6«™f«CP_VALUE_DATE’’’’Ŗ/ bpdpqrstupvvpwpwwxyz{0|0}8~8€8‚8„p††‡ˆ‰Š‹ŒppŽp‘p––—˜™pšp¦¦§Ø+üCP_VALUE_DT7 0w6«™fCP_VALUE_DT_F’’’’±/ bpdopqrstpzzp{p{{|}~0€0@‚8†8ˆ8ŠpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p­­®Æ,ÉCF_BRACKET82 ¼««™fCP_VCF_BRACKETe1’’’’¶/ bpdtuvwxypzzp{p{{|}~0€0@‚8†8ˆ8ŠpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p²²³“,ĖCP_OPEN_BRACKET92 ĻU,«™fć¬CP_VCP_OPEN_BRACKET*C’’’’»/ bpduvwxyzp~~pp€‚ƒ0„0…@†8Š8Œ8Žp’’“”•–—˜p™p™™š›œpp¢¢£¤„p¦p··ø¹,ĢCP_CLOSE_BRACKET:2 Ō6U™fp’­CP_CLOSE_BRACKET¾’’’’­/ bpdopqrstpzzp{p{{|} ~€00‚0ƒ0„0…0†pŠŠ‹ŒŽp‘p‘‘’“”p•pšš›œpžp©©Ŗ«,ēP_TITLE_34X:Š ®P_TITLE_34‘p’’’’’³/ bpdqr tvwxp~~pp€ ‚„0…0†0‡0ˆ0‰0ŠpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢pÆÆ°±-LCF_BANK_DTLSJŠ CF_BANK_DTLS|’’’’±/ bpdopqrstpzzp{p€€‚ƒ„0…0†0‡0ˆ0‰0ŠpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p­­®Æ-SP_TITLE_35YBankš P_TITLE_35OMP_BANK_ADD_3‘’“”p•p••–—˜p™pžžŸ ”p¢p³³“µ“P_BASE_NO_OF_DECI DESNP_BASE_NO_OF_DECg25b88€@ą’’’’,00x $ & (*C r75g25b88Ą@ą0800Ø4`p1DE0’’’Ō l1 °$  CF_REF_LETTER…function CF_REF_LETTER return Char is /*CURSOR C1 IS SELECT PARA_VALUE || (PARA_VALUE_NUM) REF_LETTER FROM PM_COMP_PARAMETER WHERE PARA_CODE ='BANK_CD'; M_DTLSA VARCHAR2(2000); BEGIN IF C1%ISOPEN THEN CLOSE C1; END IF; OPEN C1; FETCH C1 INTO M_DTLSA; CLOSE C1; UPDATE PM_COMP_PARAMETER SET PARA_VALUE_NUM =PARA_VALUE_NUM+1 WHERE PARA_CODE ='BANK_CD' ; COMMIT; RETURN (M_DTLSA); */ CURSOR C1 IS SELECT PARA_VALUE REF_LETTER FROM PM_COMP_PARAMETER WHERE PARA_CODE ='BANK_CD'; M_DTLSA VARCHAR2(2000); M_LTRNO VARCHAR2(2000); BEGIN IF C1%ISOPEN THEN CLOSE C1; END IF; OPEN C1; FETCH C1 INTO M_LTRNO; CLOSE C1; --SET PARA_TYPE = TO_NUMBER(PARA_TYPE)+1 UPDATE PM_COMP_PARAMETER SET PARA_VALUE = TO_NUMBER(PARA_VALUE) + 1 WHERE PARA_CODE ='BANK_CD' ; COMMIT; M_DTLSA := 'MAT/L'||LPAD(M_LTRNO,4,'0')||'/'||TO_CHAR(SYSDATE,'YYYY'); RETURN (M_DTLSA); END; Eg«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«ĶwÄ SYSSTANDARD xj  %PAYUSERPM_COMP_PARAMETER$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08 c]"PKG INIT"CF_REF_LETTER"C1""REF_LETTER"M_DTLSA"M_LTRNO"""f'-/589?BCILMSUWY[]_a    ŠŠ0D¹ŗ ’’$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08F!ŸŸŸŸ^a ’’’’Š#) $eedAAeedAA #Ī #A $ĢeźeźeźeAeŗ ģAA‹e))AA‹eAA‹eAA‹eAA‹eAA‹eŁ"FUNCTION"CF_REF_LETTER"RETURN"CHAR"CURSOR"C1"PARA_VALUE"REF_LETTER"PM_COMP_PARAMETER"PARA_CODE"="BANK_CD"M_DTLSA"VARCHAR2"2000"M_LTRNO"ISOPEN"CLOSE"OPEN"TO_NUMBER"+"1"COMMIT"MAT/L"||"LPAD"4"0"/"TO_CHAR"SYSDATE"YYYY"" v #$(35:IMNY[]bhlmosw~ƒˆŒ‘–—›Ÿ §Æ³¶¹½¾ÅĶŃŌףܹäčģīóõłž !#',2679=BFGLOPTW\`aejotxy}†Š‹”•šžŸ¤©­®²µŗæÄĒČĶŃŅ×ŪŽāäčźķšųł  #&.14<=>ADLMNQT\]h,“ ±½ōČ“±·é劬¹  ī² .|“ n¬¤°£ cQ°£ cQ·<  ·éĮ éŻ ³éÓ  éĮ éļ łē .|“.Ÿ„ Q.|“ néW “  .|“.|“.|“n. „ Qnn.Ÿ„. ³neZ O¤µQc¬`°£¬¬¬Qc¬¬QcQc¬¬Qc¬¬Qc¬¬ !!!!!!"""$$$$%%%%&&&(((())))))))))*****++++-------------------------...0 $))*+------        (* . )  #%+00088@  80 |]’€ 0{    ’ !  €€  €€€ € €  #%  %&'€ €' €( € €Š*, ,-. €€.€/€€Š@’’’Ō"l036145€  2869 ;0<=… ?0@A "+D0E G0HITF €$KL€MN€‡€&PQ€†€)€€UV€‹ €+ € Š Z0[\ŒY€^_0 $`a€ž €.cd!€˜"€1fg#€”$€4jk%€“&€7+'€’—qr(€)€;tu*€™+€ œ x0y% $ ,€}-€~.€/€~B>ƒ0€@1€€EG 2€ˆ3€‰4€5€‰J6€7€Ž8€9€Ž:€;€‘<€=€‘MQ>€•?€–@€A€–T B€šC€›D€E€›WZ ")$+ 1:>CFY]wz27BJOSRWXbpeohilmnsv‚„ROSWXlmnhieosvbpFY2’’d+„$ «Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0P ÖÖFh„ŗ$ päģx  s#Ÿw0u 0sq„{tXDtD &'$Ļ&'0„„ Ó’TT$3;„ TP;P„8L&'|$Ō1|„Ph:Lh$ hg! r„{t$gdtgd €!”’č” <``h:= <DXh:=pp„¬” CF_REF_LETTER`0MAT/L/YYYYN „ˆ ŒhŠØ0lHŠ (DLPØTTXŃØh\` (|dl!"$!%5&9(H+T-©.“0Ā=SELECT PARA_VALUE REF_LETTER FROM PM_COMP_PARAMETER WHERE PARA_CODE = ''BANK_CD''"UPDATE PM_COMP_PARAMETER SET PARA_VALUE=TO_NUMBER(PARA_VALUE) + 1 WHERE PARA_CODE = ''BANK_CD''"F ĄÄ Ģ8ŲPą@@  /   *+,ś 0 - 'š ( 1 #. %)&šš  4<ij,– $! "’’$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08 1××××eØ(’’’’’’’’@B@B@B@B@B@B@BededAAAeedAAeedAA0+ $e•eeźeźeźeźeŗ ‡ óī  ŽAAAī  ŽAAe Žī  ŽAAAAe āŽAöī  ŽAAAAeeŗ ‡ āī ŽAöī  ŽAAAe āöŽA Aöī ŽA AAeźeźeźeŗ ‡ āöŽA Aöī ŽA Ae66..AA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eAA‹eeeł ł ł ł ł ł ł ł X"F_CONV_AMOUNT_TO_WORDS"P_CURR_CODE"VARCHAR2"P_AMOUNT"NUMBER"P_AMOUNT_IN_WORDS"OUT"M_CURR_DECIMAL"1"M_CURR_UNIT_NAME"15"M_AMOUNT_DESC"250"CURSOR"C1"CURR_UNIT_NAME"CURR_DECIMAL"FM_CURRENCY"CURR_CODE"="C2"TRANSLATE"TO_CHAR"TO_DATE"DECODE"TRUNC"NVL"0"/"1000000""j"JSP"||" MILLION "-"*"J"POWER"10" " And " " ONLY "AMOUNT_IN_WORP’’’Ō$l1 °$ Ā CF_LETTER~function CF_LETTER return Char is /*CURSOR C1 IS SELECT PARA_VALUE || (PARA_TYPE) REF_LETTER FROM PM_COMP_PARAMETER WHERE PARA_CODE ='BANK_CD'; */ CURSOR C1 IS SELECT PARA_VALUE FROM PM_COMP_PARAMETER WHERE PARA_CODE ='BANK_CD'; M_DTLSA VARCHAR2(2000); M_LTRNO VARCHAR2(2000); BEGIN IF C1%ISOPEN THEN CLOSE C1; END IF; OPEN C1; FETCH C1 INTO M_LTRNO; CLOSE C1; --SET PARA_TYPE = TO_NUMBER(PARA_TYPE)+1 UPDATE PM_COMP_PARAMETER SET PARA_VALUE = TO_NUMBER(PARA_VALUE) + 1 WHERE PARA_CODE ='BANK_CD' ; COMMIT; M_DTLSA := 'MAT/L'||LPAD(M_LTRNO,4,'0')||'/'||TO_CHAR(SYSDATE,'YYYY'); RETURN (M_DTLSA); END; g«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«ĶwÄ SYSSTANDARD xj  %PAYUSERPM_COMP_PARAMETER$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08 cY"PKG INIT"CF_LETTER"C1""PARA_VALUE"M_DTLSA"M_LTRNO"""f'-/589?BCILMSUWY[]_a    ŠŠ0D¹ŗ ’’$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08E Xa’’’’Š# $eedAAeedAA #Ī #A $ĢeźeźeźeAeŗ ģAA‹e))AA‹eAA‹eAA‹eAA‹eAA‹eŹ"FUNCTION"CF_LETTER"RETURN"CHAR"CURSOR"C1"PARA_VALUE"PM_COMP_PARAMETER"PARA_CODE"="BANK_CD"M_DTLSA"VARCHAR2"2000"M_LTRNO"ISOPEN"CLOSE"OPEN"TO_NUMBER"+"1"COMMIT"MAT/L"||"LPAD"4"0"/"TO_CHAR"SYSDATE"YYYY"" Z #$(35:IMNY[]bhlmqxy}‚†‡‹‘•™š”©­°³·øæĒĖĪŃÓÖŚŽāęčķļóųü !&,0137<@AFIJNQVZ[_dinrsw{€„…ŠŽ”˜™ž£§Ø¬Æ“¹¾ĮĀĒĖĢŃÕŲÜŽāäēźņóū’    (+.678;>FGHKNVWh,“ ±½ōČ“±·é劬 ī² .|“ n¬¤°£ cQ°£ cQ·<  ·éĮ éŻ ³éÓ  éĮ éļ łē .|“.Ÿ„ Q.|“ néW “  .|“.|“.|“n. „ Qnn.Ÿ„. ³neZ O¤µQc¬`°£¬¬¬Qc¬¬QcQc¬¬Qc¬¬Qc¬¬            (* . )  #%+00088@  80 z]’€ .y    ’   € €€~ € € } !#  #$%€€% €& € €Š(* *+, € €, €-€€Š.14/23€  0647 9.:;ƒ =.>? ")B.C E.FGRD€$IJ€KL€…€&NO€„€)€€ST€‰ €+ € ˆ X.YZŠW€\`’’’Ōl]. "^_€œ€.ab €–!€1de"€’#€4hi$€‘%€7)&€•op'€›(€;rs)€—*€šv.w# " +€{,€|-€.€|B>/€@0€€EG 1€†2€‡3€4€‡J5€‹6€Œ7€8€Œ9€Ž:€;€<€MQ=€“>€”?€@€”TA€˜B€™C€D€™WZ '") /8<ADW[ux05@HMQPUV`ncmfgjklqt€‚PMQUVjklfgcmqt`nDW2’’d)‚" «Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0P ÖÖFh„ŗ päčx  s#Ÿw0u 0sq„{tXDtD &'$Ļ&'0„„ Ó’TT$3;„ TP;P„8L&'|$Ō1|„Ph:Lh$ hg! r„{t$gdtgd €!’č 8``h:= <DXh:=pp„ؔ CF_LETTER`0MAT/L/YYYYN „ˆ ŒhŠØ0lHŠ (DLPØTTXŃØh\` (|dl!59HT©“ Ā =SELECT PARA_VALUE FROM PM_COMP_PARAMETER WHERE PARA_CODE = ''BANK_CD''"UPDATE PM_COMP_PARAMETER SET PARA_VALUE=TO_NUMBER(PARA_VALUE) + 1 WHERE PARA_CODE = ''BANK_CD''"F ¼Ą Č8ŌPÜ@@˜€¾™€¹š€ŗ$›€¼œ€€µ%ž€æŸ€³ €Ā ”€ !¢€“'£€Å(¤€ %„€&'¦€¹%§€Č)*؀·©€Ė,-Ŗ€¶«€Ķ ¬€12­€ø'®€Š(ƀ &½&!Į!,Č,$Ģ$+Ļ+-°€<>FÓ.±€FÕB@CDÕ,F@GH,Ž L@M,O@PQÖCS@TUCį &X@YC[\@ &čć3c²€ę³€€6af“€ėµ€€7aķšó¶€k·€lø€¹€löłü’ ŗ€r»€s¼€½€s!¾€væ€wĄ€Į€w  Ā€~ƀĀŀ#ʀ Ē€‚Ȁɀ‚!$'*-Ź€ŒĖ€Ģ€Ķ€0369<?B&Ī€–Ļ€—Š€Ń€—E!Ņ€šӀ›Ō€Õ€›HKPSVY\_beh)րØ׀©Ų€Ł€©*Ś€«Ū€¬܀Ż€¬k+Ž€Æ߀°ą€į€°nqtwz}€ƒ†&ā€»ć€¼ä€å€¼‰!ę€æē€Ąč€é€ĄŒ’—,ź€Ęė€Ēģ€ķ€Ēš$ī€Źļ€Ėš€ń€Ė+ņ€Ķó€Īō€õ€Ī£JÓö€”-÷€MŃ   $+B&267:>?IMQ89U7XŚ[™^ƒa‚dgstujmrpqx{€~†–—˜‰•Œ”’“œ“µ¶Ÿ¤¢£§³Ŗ­²°±ŗŁ½ŲĄČĆĘĒĖ×ĪŃÖŌÕŻ’ąīäéēčģķņśõųłżž    65$"#(0+./34=AEKNRWZ]IJVbed>?gpqmrjų€~{€xł€gstuda‚’“”Œś€‰•†–—˜^ƒ¢£°±­²Ŗū€§³Ÿ¤ĘĒĆü€ŌÕŃÖĪż€Ė×ĄČ½ŲŗŁœ“µ¶[™ēčģķäéųłõž€żžņśąī   "#./+’€34(0$56 Ż’XŚU7Q89ŌŅ2I`’’ dg  Ō,C&d«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0\ ØØ”j–p’’’’ r’’’’‹0808؉ss1 °$"s CF_2FORMULAQfunction CF_2Formula return Number is begin :P_2 := :CS_2; RETURN(:P_2); end;ÉA«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«ĶwÄ SYSSTANDARD $«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08!"PKG INIT"CF_2FORMULA""r 8’’$«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ08} /"FUNCTION"CF_2FORMULA"RETURN"NUMBER"P_2""CS_2""Ī #$(357;BIMPWY]_fmuh,“ ±· ¼¼eZ¼O¤µóó    ’€   ³“ ³³“‚€€€€ "’’d’’’’«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ0D 99 Ī LäXŚ“ E Ū³Ś³E% hg!Œ’ŒtD0 CF_2FORMULA, 0H=!=3=³“@@’’’’e0000ØcQQfunction CF_2Formula return Number is begin :P_2 := :CS_2; RETURN(:P_2); end;’’’’ 0800Ø 0@pR8R8T@V@Z^_`a0b0c0d0e0f0gh0i0jklmnopqr'ųM_2Y•p0 žˆė#’’’’’Š BpD VX(^pbpb8b0d@j@nr tvw0x0y0z0{0|0}~00€‚ƒ„…†‡ˆ*R_COMP_BANK_LEVELY#  žģĘ3*,’’’’’„ BpD VX(^pbpb8b8d@f8jl npq0r0s0t0u0v0wx0y0z{|}~€‚-R_EMP_SAL_LEVEL1Y#  ˜X_į½„J ’’’’x BpD NP RpTpV8V8X@Z8^` bde0f0g0h0i0j0kl0m0nopqrstuv-/M_2_HDR1_Y EnPgā*Z J’PL/SQL Step’’’’"0Ø >&Mode:S’’’’!0Ø>&IntoS’’’’!0Ø>O&verS’’’’ 0Ø>O&ut’’’’ 0Ø>&To:’’’’*0Ø(>&Program Unit:’’’’"0Ø >&Line:m’’’’#0Ø!>&Count:’’’’"0Ø > &Apply’’’’0Ø> OKp’’’’"0Ø > Cancel’’’’!0Ø> &Help’’’’=0Ø;?!PL/SQL Stored Program Unit Editor’’’’60Ø4?Stored Program Unit EditorE’’’’$0Ø"?&Program’’’’$0Ø"?&Compile’’’’(0Ø&? &Incremental’’’’ 0Ø?&All’’’’30Ø1?&Program Unit Editor...’’’’20Ø0?PL/SQL &Interpreter...’’’’:0Ø8?&Stored Program Unit Editor...o’’’’70Ø5? Database &Trigger Editor...’’’’.0Ø,? Synta&x Palette...d’’’’A0Ø?? %&Find and Replace in Program Units...’’’’ 0Ø? &New’’’’!0Ø? &Savean’’’’#0Ø!?&Revert’’’’!0Ø?&Dropt’’’’"0Ø ?&Close’’’’!0Ø?He&lp’’’’"0Ø ?Owner:’’’’!0Ø?Name:’’’’(0Ø&? Not Modified’’’’10Ø/?Successfully Compiledro’’’’0800Ø (0’’’’0800Ø ‰@’’’’0800Ø ŠP’’’’(0000Ø&FG’’’’ 0800Ø4`p1DE€’’’’ Ōr’’’’b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`..Arial’’č$ um’’’’b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_`.vArial’č wÄ’’’’5 p&*+˜.23øbeforereport RET_DĶ«Ķ’’’’- p"#˜&*+hload_bppoET’’’’A p. 24˜:>?|cf_local_currformula_Dz END"P’’’’9 p& *,˜267(†cf_companyformula(…D ’’’’9 p& *,˜267(Źcf_cpmthformulaa (ÉD 8’’’’= p.23˜6:;+Xf_conv_amount_to_words(D Ķ«Ķ’’’’A p. 24˜:>?+ycf_amt_in_wordsformula(D+x ’’’’= p* .0˜6:;,²f_dateformattriggerla(1x+’’’’9 p& *,˜267,Źcf_bracketformula,É1(Ī’’’’I p6 :<˜BFG-f_2_fp_fc_amount1formattrigger- CLe’’’’E p2 68˜>BC- r_emp_sal_level1formattrigger-- ’’’’= p* .0˜6:;-Mcf_bank_dtlsformulaat-L’’’’5 p" &(˜.23-ˆcf_1formulafo-†t’’’’A p. 24˜:>?-“cf_amtinwordsformulat-’’’’’5 p" &(˜.23-—cf_2formulasf-•t’’’’5 p" &(˜.23.@cf_ref_letter .>t!’’’’1 p "$˜*./.Hcf_letter".G>.t#Ķ«Ķ’’’’U p p0p:HIJ0K0L NPQRS?"Q_1_BANK_NAME"BANK_NAMEQ_1_BANK_NAMEņ’’’’U p p0p:HIJ0K0L NPQRSA"Q_1_BANK_ADD1"BANK_ADD1Q_1_BANK_ADD1ņt’’’’U p p0p:HIJ0K0L NPQRSC"Q_1_BANK_ADD2"BANK_ADD2Q_1_BANK_ADD2ņ’’’’U p p0p:HIJ0K0L NPQRSE"Q_1_BANK_ADD3"BANK_ADD3Q_1_BANK_ADD3ņ0’’’’U p p0p;IJK0L0M NPQRSb"Q_1_BANK_CODE"BANKC_CODEQ_1_BANK_CODEņend’’’’[ p p1p?NOP0Q0R TVWXY("Q_1_BANKC_ACNT"BANKC_ACNT_NOQ_1_BANKC_ACNTņ_’’’’c p p5pDWXY0Z0[ \^_`a(7"Q_2_EMPY_BANK_CODE"EMPY_BANK_CODEQ_2_EMPY_BANK_CODEI‚’’’’[ p p0p@NOP0Q0R TVWXY(’"Q_1_COMP_CODE"BANKC_COMP_CODEQ_1_COMP_CODE OņD’’’’m p p8pJ`a b0d0e fhijk)š"Q_2_EMPY_BANK_REMARKS"EMPY_BANK_REMARKSQ_2_EMPY_BANK_REMARKS ŠI’’’’U p p0p:HIJ0K0L NPQRS*#"Q_2_EMPY_CODE"EMPY_CODEQ_2_EMPY_CODE _I1_’’’’a p p5pBUVW0X0Y Z\]^_*)"Q_2_COMP_BANK_CODE"B.BANKC_CODEQ_2_COMP_BANK_CODEI’’’’k p p8pH^_`0a0b dfghi*+"Q_2_COMP_BANK_ACNT_NO"B.BANKC_ACNT_NOQ_2_COMP_BANK_ACNT_NOI’’’’½ p p3p ±²³0“0µ ¶ø¹ŗ»*."Q_2_FP_FC_AMOUNT"SUM ( DECODE ( ALLW_EARN_DEDUC , 'E' , NVL ( FP_FC_AMOUNT , 0 ) , ( ( - 1 ) * NVL ( FP_FC_AMOUNT , 0 ) ) ) )Q_2_FP_FC_AMOUNT&Iy’’’’a p p5pATUV0W0X Z\]^_*A"Q_2_COMP_BANK_NAME"B.BANK_NAMEQ_2_COMP_BANK_NAME I ’’’’s p p;pMfgh0i0j lnopq*C"Q_2_COMP_BANK_SHORT_NAME"B.BANK_SHORT_NAMEQ_2_COMP_BANK_SHORT_NAMETIP’’’’c p p6pBVWX0Y0Z \^_`a*E"Q_2_COMP_BANK_ADD_1"B.BANK_ADD1Q_2_COMP_BANK_ADD_1SI’(0Ø&? &Incremental’’’’ 0Ø?&All’’’’30Ø1?&Program Unit Editor...’’’’20Ø0?PL/SQL &Interpreter...’’’’:0Ø8?&Stored Program Unit Editor...o’’’’70Ø5? Database &Trigger Editor...’’’’.0Ø,? Synta&x Palette...d’’’’A0Ø?? %&Find and Replace in Program Units...’’’’ 0Ø? &New’’’’!0Ø? &Savean’’’’#0Ø!?&Revert’’’’!0Ø?&Dropt’’’’"0Ø ?&Close’’’’!0Ø?He&lp’’’’"0Ø ?Owner:’’’’!0Ø?Name:’’’’(0Ø&? Not Modified’’’’10Ø/?Successfully Compiledro’’’’0800Ø (0’’’’0800Ø ‰@’’’’0800Ø ŠP’’’’(0000Ø&FG’’’’ 0800Ø4`p1DE’’’’ \r’’’’0808Ø›!……function CF_REF_LETTER return Char is /*CURSOR C1 IS SELECT PARA_VALUE || (PARA_VALUE_NUM) REF_LETTER FROM PM_COMP_PARAMETER WHERE PARA_CODE ='BANK_CD'; M_DTLSA VARCHAR2(2000); BEGIN IF C1%ISOPEN THEN CLOSE C1; END IF; OPEN C1; FETCH C1 INTO M_DTLSA; CLOSE C1; UPDATE PM_COMP_PARAMETER SET PARA_VALUE_NUM =PARA_VALUE_NUM+1 WHERE PARA_CODE ='BANK_CD' ; COMMIT; RETURN (M_DTLSA); */ CURSOR C1 IS SELECT PARA_VALUE REF_LETTER FROM PM_COMP_PARAMETER WHERE PARA_CODE ='BANK_CD'; M_DTLSA VARCHAR2(2000); M_LTRNO VARCHAR2(2000); BEGIN IF C1%ISOPEN THEN CLOSE C1; END IF; OPEN C1; FETCH C1 INTO M_LTRNO; CLOSE C1; --SET PARA_TYPE = TO_NUMBER(PARA_TYPE)+1 UPDATE PM_COMP_PARAMETER SET PARA_VALUE = TO_NUMBER(PARA_VALUE) + 1 WHERE PARA_CODE ='BANK_CD' ; COMMIT; M_DTLSA := 'MAT/L'||LPAD(M_LTRNO,4,'0')||'/'||TO_CHAR(SYSDATE,'YYYY'); RETURN (M_DTLSA); END; ’’’’ 0800Ø"ĀP`’’’’–0808Ø”#~~function CF_LETTER return Char is /*CURSOR C1 IS SELECT PARA_VALUE || (PARA_TYPE) REF_LETTER FROM PM_COMP_PARAMETER WHERE PARA_CODE ='BANK_CD'; */ CURSOR C1 IS SELECT PARA_VALUE FROM PM_COMP_PARAMETER WHERE PARA_CODE ='BANK_CD'; M_DTLSA VARCHAR2(2000); M_LTRNO VARCHAR2(2000); BEGIN IF C1%ISOPEN THEN CLOSE C1; END IF; OPEN C1; FETCH C1 INTO M_LTRNO; CLOSE C1; --SET PARA_TYPE = TO_NUMBER(PARA_TYPE)+1 UPDATE PM_COMP_PARAMETER SET PARA_VALUE = TO_NUMBER(PARA_VALUE) + 1 WHERE PARA_CODE ='BANK_CD' ; COMMIT; M_DTLSA := 'MAT/L'||LPAD(M_LTRNO,4,'0')||'/'||TO_CHAR(SYSDATE,'YYYY'); RETURN (M_DTLSA); END; S’’’’’0808ؐ$zzselect BANKC_COMP_CODE "Q_1_COMP_CODE", BANK_NAME "Q_1_BANK_NAME", BANK_ADD1 "Q_1_BANK_ADD1", BANK_ADD2 "Q_1_BANK_ADD2", BANK_ADD3 "Q_1_BANK_ADD3", BANKC_CODE "Q_1_BANK_CODE", BANKC_ACNT_NO "Q_1_BANKC_ACNT" from PM_BANK ,PM_BANK_COMP WHERE BANKC_COMP_CODE = :CP_COMP_CODE AND BANKC_CODE = BANK_CODE AND NVL(BANKC_ACNT_NO,'0') != '0'C_’’’’0800Ø%  ’’’’œ€*€>€F€R[(^ b€fąo(v€ząƒ(Š€Ž€Ž(Ž(’(–š_ESQL*ReportWriters REPORTPAYUSER ouPR007CRAc.} PAYROLLwÅP@PAYUSERxl˜v˜™’’’’ pInsrepplDE’’’’S N¢(¦0Ŗ«¬@²@¶0ŗ0»@¾@Ā@Ę@Ź@Ī@Ņ0Ö0×ŲŁ0Ś0Ū8Ü8Žąpįpįpāāćäåęēč ź0ģ0ķīļ8š8ņ0ōõö ųśūüż@žA11A AAAAA1"1#A&A*1.1/A2A6A:A>ABAF1J1KLMNOPQidpś‘„Ē† ­°PB==@!@`@`8Śs «ījj.v† ­°PBW2@`@`@`† ­°PB@`@`@` ’’’’ 00 )’’’’ 00P_MOUNT , 0 ) ) ) )Q_2_FP_FC_AMOUNT&Iy’’’’a p p5pATUV0W0X Z\]^_*A"Q_2_COMP_BANK_NAME"B.BANK_NAMEQ_2_COMP_BANK_NAME I ’’’’s p p;pMfgh0i0j lnopq*C"Q_2_COMP_BANK_SHORT_NAME"B.BANK_SHORT_NAMEQ_2_COMP_BANK_SHORT_NAMETIP’’’’c p p6pBVWX0Y0Z \^_`a*E"Q_2_COMP_BANK_ADD_1"B.BANK_ADD1Q_2_COMP_BANK_ADD_1SI’(0Ø&? &Incremental’’’’ 0Ø?&All’’’’30Ø1?&Program Unit Editor...’’’’20Ø0?PL/SQL &Interpreter...’’’’:0Ø8?&Stored Program Unit Editor...o’’’’70Ø5? Database &Trigger Editor...’’’’.0Ø,? Synta&x Palette...d’’’’A0Ø?? %&Find and Replace in Program Units...’’’’ 0Ø? &New’’’’!0Ø? &Savean’’’’#0Ø!?&Revert’’’’!0Ø?&Dropt’’’’"0Ø ?&Close’’’’!0Ø?He&lp’’’’"0Ø ?Owner:’’’’!0Ø?Name:’’’’(0Ø&? Not Modified’’’’10Ø/?Successfully Compiledro’’’’0800Ø (0’’’’0800Ø ‰@’’’’0800Ø ŠP’’’’(0000Ø&FG’’’’ 0800Ø4`p1DE ’’’ŌlSELECT B.BANKC_CODE "Q_2_COMP_BANK_CODE", B.BANKC_ACNT_NO "Q_2_COMP_BANK_ACNT_NO" , B.BANK_NAME "Q_2_COMP_BANK_NAME", B.BANK_SHORT_NAME "Q_2_COMP_BANK_SHORT_NAME", B.BANK_ADD1 "Q_2_COMP_BANK_ADD_1", B.BANK_ADD2 "Q_2_COMP_BANK_ADD_2", B.BANK_ADD3 "Q_2_COMP_BANK_ADD_3", EMPY_BANK_CODE "Q_2_EMPY_BANK_CODE", EMPY_BANK_REMARKS "Q_2_EMPY_BANK_REMARKS", EMPY_CODE "Q_2_EMPY_CODE", DECODE(:P_LANG_CODE, 'ENG', EMP_LONG_NAME, EMP_BL_NAME) "Q_2_EMP_NAME", DECODE(:P_LANG_CODE, 'ENG', A.BANK_NAME, A.BANK_BL_NAME) "Q_2_EMP_BANK_NAME", DECODE(:P_LANG_CODE, 'ENG', A.BANK_SHORT_NAME, A.BANK_BL_SHORT_NAME) "Q_2_EMP_BANK_SHORT_NAME", A.BANK_ADD1 "Q_2_EMP_BANK_ADD_1", A.BANK_ADD2 "Q_2_EMP_BANK_ADD_2", A.BANK_ADD3 "Q_2_EMP_BANK_ADD_3", FP_CURR_CODE "Q_2_EMP_CURR_CODE", SUM(DECODE(ALLW_EARN_DEDUC, 'E', NVL(FP_FC_AMOUNT,0), ((-1)*NVL(FP_FC_AMOUNT,0)))) "Q_2_FP_FC_AMOUNT" FROM PS_FINAL_PROC, PM_BANK_COMP A, PM_BANK_COMP B, PM_BANK A, PM_BANK B, PM_EMP_KEY, PM_EMP_PAY, PM_ALLOWANCE WHERE FP_COMP_CODE = :CP_COMP_CODE AND EMP_COMP_CODE = FP_COMP_CODE AND EMPY_COMP_CODE = FP_COMP_CODE AND A.BANKC_COMP_CODE = FP_COMP_CODE AND A.BANKC_COMP_CODE = B.BANKC_COMP_CODE AND EMP_CODE = EMPY_CODE AND EMPY_PAY_MODE = 'B' AND B.BANKC_CODE = B.BANK_CODE AND B.BANKC_CODE = :CP_FROM_COMP_BANK_CODE AND EMPY_BANK_CODE = A.BANK_CODE AND EMPY_COMP_BANK_CODE= B.BANKC_CODE AND EMPY_BANK_CODE = FP_BANK_CODE AND EMPY_BANK_CODE = A.BANKC_CODE AND EMP_CODE = FP_EMP_CODE AND ALLW_CODE = FP_ALLW_CODE AND EMP_STATUS NOT IN (4, 5, 6) /*added by shaibu on 10/10/2005 for fixing the issue id JAMOMAN-88901. Employees who has terminated or made EOS should not be displayed */ AND FP_PROC_MTH = TO_NUMBER(:CP_M_CPMTH) AND FP_EMP_CODE BETWEEN :CP_FM_EMP AND :CP_TO_EMP AND FP_CONT_TYPE_CODE BETWEEN :CP_FM_CONT_TYPE AND :CP_TO_CONT_TYPE AND FP_DIVN_CODE BETWEEN :CP_FM_DIVN AND :CP_TO_DIVN AND FP_DEPT_CODE BETWEEN :CP_FM_DEPT AND :CP_TO_DEPT AND FP_LOCN_CODE BETWEEN :CP_FM_LOCN AND :CP_TO_LOCN AND FP_CC_CODE BETWEEN :CP_FM_CC AND :CP_TO_CC AND NVL(FP_CNTRY_CODE,:CP_FM_CNTRY) BETWEEN :CP_FM_CNTRY AND :CP_TO_CNTRY --having clause added by shaibu on 11/02/2006 for fixing the issue id ORIONQC-GDC-814988 HAVING SUM(DECODE(ALLW_EARN_DEDUC, 'E', NVL(FP_FC_AMOUNT,0), ((-1)*NVL(FP_FC_AMOUNT,0)))) > 0 GROUP BY B.BANKC_CODE , B.BANKC_ACNT_NO , B.BANK_NAME , B.BANK_SHORT_NAME , B.BANK_ADD1 , B.BANK_ADD2 , B.BANK_ADD3 , EMPY_BANK_CODE , EMPY_BANK_REMARKS , EMPY_CODE , DECODE(:P_LANG_CODE, 'ENG', EMP_LONG_NAME, EMP_BL_NAME) , DECODE(:P_LANG_CODE, 'ENG', A.BANK_NAME, A.BANK_BL_NAME) , DECODE(:P_LANG_CODE, 'ENG', A.BANK_SHORT_NAME, A.BANK_BL_SHORT_NAME) , A.BANK_ADD1 , A.BANK_ADD2, A.BANK_ADD3, FP_CURR_CODE ORDER BY EMPY_CODE€ Sm    ’ K ƒ('€‚ € €~ € €} € !€y € € € | €   €)-J€€€.DE€/>?€089€12€u€€56€t€€:;€v€ €€@A€w€" €pØoFG!€x"€%#€$€MO (OPQ%€&€Q'€R(€)€Š*1SVYTWX*€ 3U[Y\ ^S_`‡ bScd 5NgSh jSkONp؂+€,€rqs-€9=@CFI .€z/€{0€1€{LO 2€3€€4€5€€RU…6€77€ƒ L&%$"#*+,3°’’’’Pr’’’’“/ bpdrs tvwxp~~pp€ ‚„0…0†0‡0ˆ0‰0ŠpŽŽ‘’“”p•p••–—˜p™pžžŸ ”p¢p°°±².>CF_REF_LETTERóAEDŠ CF_REF_LETTER’’’’¬/ bpdno prstpzzp{p{{|} ~€00‚0ƒ0„0…0†pŠŠ‹ŒŽp‘p‘‘’“”p•pšš›œpžpØØ©Ŗ.GCF_LETTER *,Š CF_LETTER’’’’·* Zp\ `b(fpjpj8j8l8n8prstxzŠŽ0’“0”0•0–—˜™š0›0œp¢¢¦0Ŗ«¬­®Æ°±²³“µ*\B_2YER( ā/ĪGÖ|Cā/ĪGÖ’h’’’’³* Zp\ `b dpfpf8f8h@j8npqrxv†Š0Ž00‘0’“”•–0—0˜pžž¢0¦§Ø©Ŗ«¬­®Æ°±1;,ģB_5Y EāIøß śāIøß śÖ’_’’’’»* Zp\ bd(jpnpn8n8p8r8tvwxx~Ž’0–—0˜0™0š›œž0Ÿ0 p¦¦Ŗ0®Æ°±²³“µ¶·ø¹; ,ļB_15Y āøI ā9«®UāIøā9«®U’s’’’’³* Zp\ `b(fpjpj8j8l@n0rstuxv†Š0Ž00‘0’“”•–0—0˜pžž¢0¦§Ø©Ŗ«¬­®Æ°±AN-B_7+( 0æVćį.æVćūķVć®’’P’’’’»* Zp\ `b(fpjpj8j@n8r8tvwxx~Ž’0–—0˜0™0š›œž0Ÿ0 p¦¦Ŗ0®Æ°±²³“µ¶·ø¹AR-lB_3Y  ā_CÕ±+śUæVćāÕ±+śU’v’’’’»* Zp\ `b(fpjpj8j@n8r8tvwxx~Ž’0–—0˜0™0š›œž0Ÿ0 p¦¦Ŗ0®Æ°±²³“µ¶·ø¹ET-mB_4Y  āp\żJaUæVćāżJaU’)’’’’»* Zp\ `b(fpjpj8j@n8r8tvwxx~Ž’0–—0˜0™0š›œž0Ÿ0 p¦¦Ŗ0®Æ°±²³“µ¶·ø¹CH-nB_6Y  ā1Üą>P .æVćāÜą>P .’C’’’’·* Zp\ `b(fpjpj8j8l8n8prstxzŠŽ0’“0”0•0–—˜™š0›0œp¢¢¦0Ŗ«¬­®Æ°±²³“µ1_-B_8Y  0 bVHüU æbVHüU .’BANKC_ACNT" from PM_BANK ,PM_BANK_COMP WHERE BANKC_COMP_CODE = :CP_COMP_CODE AND BANKC_CODE = BANK_CODE AND NVL(BANKC_ACNT_NO,'0') != '0'C_’’’’0800Ø%  ’’’’œ€*€>€F€R[(^ b€fąo(v€ząƒ(Š€Ž€Ž(Ž(’(–š_ESQL*ReportWriters REPORTPAYUSER ouPR007CRAc.} PAYROLLwÅP@PAYUSERxl˜v˜™’’’’ pInsrepplDE’’’’S N¢(¦0Ŗ«¬@²@¶0ŗ0»@¾@Ā@Ę@Ź@Ī@Ņ0Ö0×ŲŁ0Ś0Ū8Ü8Žąpįpįpāāćäåęēč ź0ģ0ķīļ8š8ņ0ōõö ųśūüż@žA11A AAAAA1"1#A&A*1.1/A2A6A:A>ABAF1J1KLMNOPQidpś‘„Ē† ­°PB==@!@`@`8Śs «ījj.v† ­°PBW2@`@`@`† ­°PB@`@`@` ’’’’ 00 )’’’’ 00P_MOUNT , 0 ) ) ) )Q_2_FP_FC_AMOUNT&Iy’’’’a p p5pATUV0W0X Z\]^_*A"Q_2_COMP_BANK_NAME"B.BANK_NAMEQ_2_COMP_BANK_NAME I ’’’’s p p;pMfgh0i0j lnopq*C"Q_2_COMP_BANK_SHORT_NAME"B.BANK_SHORT_NAMEQ_2_COMP_BANK_SHORT_NAMETIP’’’’c p p6pBVWX0Y0Z \^_`a*E"Q_2_COMP_BANK_ADD_1"B.BANK_ADD1Q_2_COMP_BANK_ADD_1SI’(0Ø&? &Incremental’’’’ 0Ø?&All’’’’30Ø1?&Program Unit Editor...’’’’20Ø0?PL/SQL &Interpreter...’’’’:0Ø8?&Stored Program Unit Editor...o’’’’70Ø5? Database &Trigger Editor...’’’’.0Ø,? Synta&x Palette...d’’’’A0Ø?? %&Find and Replace in Program Units...’’’’ 0Ø? &New’’’’!0Ø? &Savean’’’’#0Ø!?&Revert’’’’!0Ø?&Dropt’’’’"0Ø ?&Close’’’’!0Ø?He&lp’’’’"0Ø ?Owner:’’’’!0Ø?Name:’’’’(0Ø&? Not Modified’’’’10Ø/?Successfully Compiledro’’’’0800Ø (0’’’’0800Ø ‰@’’’’0800Ø ŠP’’’’(0000Ø&FG’’’’ 0800Ø4`p1DEĄ’’’’ r’’’’³* Zp\ `b(fpjpj@j8n8p0rstuxv†Š0Ž00‘0’“”•–0—0˜pžž¢0¦§Ø©Ŗ«¬­®Æ°± t-œB_9+(! 0ĪRa¬,UĪRa¬ś§a¬U’’’’’·* Zp\ bd(jpnpn@n8r8t0vwxyxzŠŽ0’“0”0•0–—˜™š0›0œp¢¢¦0Ŗ«¬­®Æ°±²³“µe -B_10++("0ĪRh†,UĪRh†ś§h†’u’’’’³* Zp\ bd fphpj8j8l@n0rstuxv†Š0Ž00‘0’“”•–0—0˜pžž¢0¦§Ø©Ŗ«¬­®Æ°±ur-“B_12++(#0æ_»į.æ_»ūķ_»h†’’’’’»* Zp\ `b(fpjpj8j@n@r8vxyzx~Ž’0–—0˜0™0š›œž0Ÿ0 p¦¦Ŗ0®Æ°±²³“µ¶·ø¹-ĪB_1Y%+#0 Fr ĢiējG_»FĢiējG’.’’’’  e’’’’  ™ee ’’’’  žetr’’’’  _e t’’’’  ae&F’’’’  ceh ’’’’  eex’’’’  ueds’’’’  yes ’’’’  }eCu’’’’  ĖeCO’’’’   e.’’’’   že’’’’   e’’’’   eAM’’’’   e ’’’’  … Ē :’’’’  *\-V ’’’’  *\-: ’’’’  *\-VP_’’’’  *w+e ’’’’  *w+eK_’’’’  *{'ņ :’’’’  *†'ņM_’’’’  *Ų*—DE’’’’  *Ś*—HE’’’’  +'ņ ’’’’  + 'ņ_V’’’’  +#'ņAM’’’’  ,'ņ ’’’’  ,¢'ņ :’’’’  ,ģ'ņ ’’’’  ,ļ'ņ ’’’’  -7'ņP_’’’’  -e-` ’’’’  -g-`LC’’’’  -h-` :’’’’  -l-V_I’’’’  -m-:RE’’’’  -n-V ’’’’  -n-V ’’’’  --V ’’’’  -½-VP_’’’’  -Ī-VTH’’’’t BpD HJ(NpRpR8R8T@V@Z^_`a0b0c0d0e0f0gh0i0jklmnopqr'ųM_2Y•p0 žˆė#’’’’’Š BpD VX(^pbpb8b0d@j@nr tvw0x0y0z0{0|0}~00€‚ƒ„…†‡ˆ*R_COMP_BANK_LEVELY#  žģĘ3*,’’’’’„ BpD VX(^pbpb8b8d@f8jl npq0r0s0t0u0v0wx0y0z{|}~€‚-R_EMP_SAL_LEVEL1Y#  ˜X_į½„J ’’’’x BpD NP RpTpV8V8X@Z8^` bde0f0g0h0i0j0kl0m0nopqrstuv-/M_2_HDR1_Y EnPgā*Z J’PL/SQL Step’’’’"0Ø >&Mode:S’’’’!0Ø>&IntoS’’’’!0Ø>O&verS’’’’ 0Ø>O&ut’’’’ 0Ø>&To:’’’’*0Ø(>&Program Unit:’’’’"0Ø >&Line:m’’’’#0Ø!>&Count:’’’’"0Ø > &Apply’’’’0Ø> OKp’’’’"0Ø > Cancel’’’’!0Ø> &Help’’’’=0Ø;?!PL/SQL Stored Program Unit Editor’’’’60Ø4?Stored Program Unit EditorE’’’’$0Ø"?&Program’’’’$0Ø"?&Compile’’’’(0Ø&? &Incremental’’’’ 0Ø?&All’’’’30Ø1?&Program Unit Editor...’’’’20Ø0?PL/SQL &Interpreter...’’’’:0Ø8?&Stored Program Unit Editor...o’’’’70Ø5? Database &Trigger Editor...’’’’.0Ø,? Synta&x Palette...d’’’’A0Ø?? %&Find and Replace in Program Units...’’’’ 0Ø? &New’’’’!0Ø? &Savean’’’’#0Ø!?&Revert’’’’!0Ø?&Dropt’’’’"0Ø ?&Close’’’’!0Ø?He&lp’’’’"0Ø ?Owner:’’’’!0Ø?Name:’’’’(0Ø&? Not Modified’’’’10Ø/?Successfully Compiledro’’’’0800Ø (0’’’’0800Ø ‰@’’’’0800Ø ŠP’’’’(0000Ø&FG’’’’ 0800Ø4`p1DE