<% crlf=chr(13)+chr(10) *=Sys(3101,1256) *=SYS(3101,65001) letterhead=orequest.form('letterhead') if isnull(letterhead) letterhead=nvl(orequest.querystring('letterhead'),'') endif record_number=orequest.form("record_number") if isnull(record_number) record_number=orequest.querystring("rref") endif tfilename=dbclocation+[details] tcmd=[select * from (']+tfilename+[') where recno()==]+record_number+[ into cursor 'dcursor'] &tcmd record_fileref=allt(reffid) tfilename=dbclocation+[fileref] tcmd=[select * from (']+tfilename+[') where allt(reffid)==']+record_fileref+[' into cursor 'fcursor'] &tcmd THESPCONTACT=iif(empty(SPONPHONE),sendphone,SPONPHONE) tfilename=dbclocation+[category] tcmd=[select * from (']+tfilename+[') where allt(reffid)==']+record_fileref+[' into cursor 'gcursor'] &tcmd VUNDERTAKING1V1='We M/S '+Upper(Alltrim(XCOMPANY.Name))+' OEPL No. '+Allt(XCOMPANY.LIC)+; ' solemnly affirm that M/S '+THESPCONTACT+; ' vide sikka wakala/khitab letter No. '+Alltrim(fcursor.VISAID)+' dated: '+Dtoc(fcursor.Date)+; ' have authorized us to recruit ( '+Alltrim(Str(fcursor.QTY,5,0))+' ) workers, and arrange their Departure to the employer.'+; ' We further confirm and stand guarantee that the employer is in need of workers in the following categories of workers, and shall provide'+; ' the salary and fringe benefits as detailed bellow:' VUNDERTAKING1V2='Other fringe benefits: '+Chr(13)+'
a). Accomodation '+Iif(fcursor.ACCOMODATI,'provided','not provided')+Chr(13)+; '
b). Food '+Iif(fcursor.FOOD,'provided','not provided')+Chr(13)+; '
c). Medical '+Iif(fcursor.MEDICAL,'provided','not provided')+Chr(13)+; '
d). Air Passage '+Iif(fcursor.TICKET,'provided','not provided')+Chr(13)+; '
e). Health Insurrance '+Iif(fcursor.HINSURANCE,'provided','not provided')+Chr(13)+; '
f). Other fringe benefits as per local labour laws'+Chr(13)+; '

I undertake that the above information are correct, and the demand received through electronic visa slip is genuine. '+; 'I/We further undertake that:'+Chr(13)+; '
1. In the event of the afforesaid information being found false or incorrect in any aspect, the recruiting permission shall be liable to legal and disciplinary action.'+Chr(13)+; '
2. In case any worker proceeding abroad in accordance with the permission is unable to secure job, I shall bear all the cost of his/her repartriation.' %> SSSoft™ - <<allt(xcompany.name)>>
<%if empty(letterhead)%>
<%=xcompany.name%>

<%=allt(allt(xcompany.address1)+[ ]+allt(xcompany.address2))%> <%=allt(allt(xcompany.phone)+[ ]+allt(xcompany.email))%>

<%else%>
<%=getimagehead()%>
<%endif%>

UNDERTAKING

<%=VUNDERTAKING1V1%>

<% gtablestr=[] GTABLESTR=GTABLESTR+[ ]+crlf GTABLESTR=GTABLESTR+[ ]+crlf GTABLESTR=GTABLESTR+[ ]+crlf GTABLESTR=GTABLESTR+[ ]+crlf GTABLESTR=GTABLESTR+[ ]+crlf GTABLESTR=GTABLESTR+[]+crlf select [gcursor] scan GTABLESTR=GTABLESTR+[]+crlf GTABLESTR=GTABLESTR+[]+crlf GTABLESTR=GTABLESTR+[] +crlf GTABLESTR=GTABLESTR+[]+crlf GTABLESTR=GTABLESTR+[]+crlf GTABLESTR=GTABLESTR+[]+crlf GTABLESTR=GTABLESTR+[]+CRLF endscan GTABLESTR=GTABLESTR+[
S.No.CATEGORY OF
WORKERS		NUMBER
REQUIRED		MONTHLY
SALARY		CONTRACT
PERIOD
]+allt(transform(recno()))+[]+allt(category)+[]+allt(TRANSFORM(qty))+[]+allt(curr)+" "+allt(str(salary,10,0))+[]+allt(iif(empty(year),"",allt(str(year,2))+" YEAR ")+ iif(empty(month),"",padl(allt(str(month,2,0)),2,"0")+" Month"))+[
] %> <%=GTABLESTR%>

Other fringe benefits:
 a). Accomodation <%=Iif(fcursor.ACCOMODATI,'provided','not provided')%>
 b). Food <%=Iif(fcursor.FOOD,'provided','not provided')%>
 c). Medical <%=Iif(fcursor.MEDICAL,'provided','not provided')%>
 d). Air Passage <%=Iif(fcursor.TICKET,'provided','not provided')%>
 e). Health Insurrance <%=Iif(fcursor.HINSURANCE,'provided','not provided')%>
 f). Other fringe benefits as per local labour laws

I undertake that the above information are correct, and the demand received through electronic visa slip is genuine.

I/We further undertake that:
1.  In the event of the afforesaid information being found false or incorrect in any aspect, the recruiting permission shall be liable to legal and disciplinary action.
2.  In case any worker proceeding abroad in accordance with the permission is unable to secure job, I shall bear all the cost of his/her repartriation.