<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE Sybase_eDataWindow>
<Sybase_eDataWindow>
	<Release>9</Release>
	<BaseDefinition>
		<units>1</units>
		<timer_interval>0</timer_interval>
		<color>79741120</color>
		<processing>1</processing>
		<HTMLDW>no</HTMLDW>
		<print>
			<documentname></documentname>
			<printername></printername>
			<orientation>0</orientation>
			<margin>
				<left>24</left>
				<right>24</right>
				<top>24</top>
				<bottom>24</bottom>
			</margin>
			<paper>
				<source>0</source>
				<size>0</size>
			</paper>
			<prompt>no</prompt>
			<canusedefaultprinter>yes</canusedefaultprinter>
			<buttons>no</buttons>
			<preview.buttons>no</preview.buttons>
			<cliptext>no</cliptext>
			<overrideprintjob>no</overrideprintjob>
		</print>
		<grid.lines>0</grid.lines>
	</BaseDefinition>
	<Header>
		<height>17</height>
		<color>536870912</color>
	</Header>
	<Summary>
		<height>0</height>
		<color>536870912</color>
	</Summary>
	<Footer>
		<height>0</height>
		<color>536870912</color>
	</Footer>
	<Detail>
		<height>21</height>
		<color>536870912</color>
	</Detail>
	<TableDefinition>
		<table_column>
			<type size="5">char</type>
			<update>yes</update>
			<updatewhereclause>yes</updatewhereclause>
			<name>lve_code</name>
			<dbname>leavebal.lve_code</dbname>
		</table_column>
		<table_column>
			<type size="10">char</type>
			<update>yes</update>
			<updatewhereclause>yes</updatewhereclause>
			<name>emp_code</name>
			<dbname>leavebal.emp_code</dbname>
		</table_column>
		<table_column>
			<type>number</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>ccbal</name>
			<dbname>cbal</dbname>
		</table_column>
		<table_column>
			<type>number</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>crbal</name>
			<dbname>crbal</dbname>
		</table_column>
		<table_column>
			<type>number</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>max_accumulate</name>
			<dbname>max_accumulate</dbname>
		</table_column>
		<table_column>
			<type size="15">char</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>emp_lname</name>
			<dbname>employee.emp_lname</dbname>
		</table_column>
		<table_column>
			<type size="15">char</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>emp_fname</name>
			<dbname>employee.emp_fname</dbname>
		</table_column>
		<table_column>
			<type>number</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>max_days</name>
			<dbname>max_days</dbname>
		</table_column>
		<table_column>
			<type>number</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>laps_days</name>
			<dbname>laps_days</dbname>
		</table_column>
		<retrieve>PBSELECT( VERSION(400) TABLE(NAME=&quot;leavebal&quot; )  TABLE(NAME=&quot;employee&quot; ) COLUMN(NAME=&quot;leavebal.lve_code&quot;) COLUMN(NAME=&quot;leavebal.emp_code&quot;) COMPUTE(NAME=&quot;sum(leavebal.bal_days) cbal&quot;) COMPUTE(NAME=&quot;0.00 crbal&quot;) COMPUTE(NAME=&quot;0.00 max_accumulate&quot;) COLUMN(NAME=&quot;employee.emp_lname&quot;) COLUMN(NAME=&quot;employee.emp_fname&quot;) COMPUTE(NAME=&quot;0.00 max_days&quot;) COMPUTE(NAME=&quot;0.00 laps_days&quot;)    JOIN (LEFT=&quot;employee.emp_code&quot;    OP =&quot;=&quot;RIGHT=&quot;leavebal.emp_code&quot; )WHERE(    EXP1 =&quot;( leavebal.emp_code&quot;   OP =&quot;between&quot;    EXP2 =&quot;:emp_code_fr and :emp_code_to )&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;( leavebal.lve_code&quot;   OP =&quot;between&quot;    EXP2 =&quot;:lve_code_fr and :lve_code_to )&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;( employee.emp_site&quot;   OP =&quot;between&quot;    EXP2 =&quot;:site_code_fr and :site_code_to )&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;( leavebal.eff_date&quot;   OP =&quot;&lt;=&quot;    EXP2 =&quot;:laps_on_date )&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;( leavebal.exp_date&quot;   OP =&quot;&gt;=&quot;    EXP2 =&quot;:laps_on_date )&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;( leavebal.bal_days&quot;   OP =&quot;&gt;&quot;    EXP2 =&quot;0 )&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;( employee.dept_code&quot;   OP =&quot;&gt;=&quot;    EXP2 =&quot;:dept_code_fr )&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;( employee.dept_code&quot;   OP =&quot;&lt;=&quot;    EXP2 =&quot;:dept_code_to )&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;(employee.proc_group&quot;   OP =&quot;&gt;=&quot;    EXP2 =&quot;:as_proc_group__fr)&quot;    LOGIC =&quot;And&quot; ) WHERE(    EXP1 =&quot;(employee.proc_group&quot;   OP =&quot;&lt;=&quot;    EXP2 =&quot;:as_proc_group__to)&quot; )  GROUP(NAME=&quot;leavebal.emp_code&quot;) GROUP(NAME=&quot;leavebal.lve_code&quot;) GROUP(NAME=&quot;employee.emp_fname&quot;) GROUP(NAME=&quot;employee.emp_lname&quot;)) ARG(NAME = &quot;lve_code_fr&quot; TYPE = string)  ARG(NAME = &quot;lve_code_to&quot; TYPE = string)  ARG(NAME = &quot;emp_code_fr&quot; TYPE = string)  ARG(NAME = &quot;emp_code_to&quot; TYPE = string)  ARG(NAME = &quot;site_code_fr&quot; TYPE = string)  ARG(NAME = &quot;site_code_to&quot; TYPE = string)  ARG(NAME = &quot;laps_on_date&quot; TYPE = datetime)  ARG(NAME = &quot;dept_code_fr&quot; TYPE = string)  ARG(NAME = &quot;dept_code_to&quot; TYPE = string)  ARG(NAME = &quot;as_proc_group__fr&quot; TYPE = string)  ARG(NAME = &quot;as_proc_group__to&quot; TYPE = string) </retrieve>
		<argument>
			<name>lve_code_fr</name>
			<type>string</type>
		</argument>
		<argument>
			<name>lve_code_to</name>
			<type>string</type>
		</argument>
		<argument>
			<name>emp_code_fr</name>
			<type>string</type>
		</argument>
		<argument>
			<name>emp_code_to</name>
			<type>string</type>
		</argument>
		<argument>
			<name>site_code_fr</name>
			<type>string</type>
		</argument>
		<argument>
			<name>site_code_to</name>
			<type>string</type>
		</argument>
		<argument>
			<name>laps_on_date</name>
			<type>datetime</type>
		</argument>
		<argument>
			<name>dept_code_fr</name>
			<type>string</type>
		</argument>
		<argument>
			<name>dept_code_to</name>
			<type>string</type>
		</argument>
		<argument>
			<name>as_proc_group__fr</name>
			<type>string</type>
		</argument>
		<argument>
			<name>as_proc_group__to</name>
			<type>string</type>
		</argument>
		<sort>
			<expression>emp_code A</expression>
			<expression>lve_code A</expression>
		</sort>
	</TableDefinition>
	<TextObject>
		<band>Header</band>
		<alignment>2</alignment>
		<text>Emp Code</text>
		<border>6</border>
		<color>0</color>
		<x>2</x>
		<y>1</y>
		<height>16</height>
		<width>64</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>leavebal_emp_code_t</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>2</alignment>
		<text>Emp Fname</text>
		<border>6</border>
		<color>0</color>
		<x>68</x>
		<y>1</y>
		<height>16</height>
		<width>136</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>emp_fname_t</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>0</alignment>
		<text>Emp Lname</text>
		<border>6</border>
		<color>0</color>
		<x>206</x>
		<y>1</y>
		<height>16</height>
		<width>136</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>emp_lname_t</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>2</alignment>
		<text>Lve Code</text>
		<border>6</border>
		<color>0</color>
		<x>344</x>
		<y>1</y>
		<height>16</height>
		<width>51</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>leavebal_lve_code_t</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>2</alignment>
		<text>Balance Days</text>
		<border>6</border>
		<color>0</color>
		<x>397</x>
		<y>1</y>
		<height>16</height>
		<width>80</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>t_2</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>2</alignment>
		<text>Max days acc</text>
		<border>6</border>
		<color>0</color>
		<x>479</x>
		<y>1</y>
		<height>16</height>
		<width>76</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>t_3</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>2</alignment>
		<text>Days to be lapsed</text>
		<border>6</border>
		<color>0</color>
		<x>557</x>
		<y>1</y>
		<height>16</height>
		<width>99</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>t_4</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>79741120</color>
		</background>
	</TextObject>
	<ColumnObject>
		<band>Detail</band>
		<id>2</id>
		<alignment>0</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>2</x>
		<y>1</y>
		<height>16</height>
		<width>64</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>emp_code</name>
		<tag>Employee code.</tag>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>10</limit>
			<case>any</case>
			<autoselect>yes</autoselect>
			<autohscroll>yes</autohscroll>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>1090519039</color>
		</background>
	</ColumnObject>
	<ColumnObject>
		<band>Detail</band>
		<id>7</id>
		<alignment>0</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>68</x>
		<y>1</y>
		<height>16</height>
		<width>136</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>emp_fname</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>0</limit>
			<case>any</case>
			<focusrectangle>no</focusrectangle>
			<autoselect>no</autoselect>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>1090519039</color>
		</background>
	</ColumnObject>
	<ColumnObject>
		<band>Detail</band>
		<id>6</id>
		<alignment>0</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>206</x>
		<y>1</y>
		<height>16</height>
		<width>136</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>emp_lname</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>0</limit>
			<case>any</case>
			<focusrectangle>no</focusrectangle>
			<autoselect>no</autoselect>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>1090519039</color>
		</background>
	</ColumnObject>
	<ColumnObject>
		<band>Detail</band>
		<id>1</id>
		<alignment>0</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>344</x>
		<y>1</y>
		<height>16</height>
		<width>51</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>lve_code</name>
		<tag>Leave code.</tag>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>5</limit>
			<case>any</case>
			<autoselect>yes</autoselect>
			<autohscroll>yes</autohscroll>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>1090519039</color>
		</background>
	</ColumnObject>
	<ColumnObject>
		<band>Detail</band>
		<id>3</id>
		<alignment>1</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>397</x>
		<y>1</y>
		<height>16</height>
		<width>80</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>ccbal</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>0</limit>
			<case>any</case>
			<focusrectangle>no</focusrectangle>
			<autoselect>yes</autoselect>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>1090519039</color>
		</background>
	</ColumnObject>
	<ColumnObject>
		<band>Detail</band>
		<id>8</id>
		<alignment>1</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>479</x>
		<y>1</y>
		<height>16</height>
		<width>76</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>max_days</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>0</limit>
			<case>any</case>
			<autoselect>yes</autoselect>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>1090519039</color>
		</background>
	</ColumnObject>
	<ColumnObject>
		<band>Detail</band>
		<id>9</id>
		<alignment>1</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>557</x>
		<y>1</y>
		<height>16</height>
		<width>99</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>laps_days</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>0</limit>
			<case>any</case>
			<autoselect>yes</autoselect>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>1090519039</color>
		</background>
	</ColumnObject>
	<HtmlTable>
		<border>1</border>
	</HtmlTable>
	<HtmlGen>
		<clientevents>1</clientevents>
		<clientvalidation>1</clientvalidation>
		<clientcomputedfields>1</clientcomputedfields>
		<clientformatting>0</clientformatting>
		<clientscriptable>0</clientscriptable>
		<generatejavascript>1</generatejavascript>
		<encodeselflinkargs>1</encodeselflinkargs>
		<netscapelayers>0</netscapelayers>
	</HtmlGen>
	<Export.XML>
		<headgroups>1</headgroups>
		<includewhitespace>0</includewhitespace>
		<metadatatype>0</metadatatype>
		<savemetadata>0</savemetadata>
	</Export.XML>
	<Import.XML>
	</Import.XML>
	<Export.PDF>
		<method>0</method>
		<distill.custompostscript>0</distill.custompostscript>
		<xslfop.print>0</xslfop.print>
	</Export.PDF>
</Sybase_eDataWindow>
