bknox edison_aces Thu, 2 Feb 2012 15:51:11 -0600 Which Funds and Orgns Can I See? Banner Fund/Orgn Security Wed, 15 Feb 2012 11:53:13 -0600 Mon, 11 Apr 2011 16:25:28 -0600 Mon, 11 Apr 2011 16:25:22 -0600 bknox <datablock> <information> <description>Argos Object File</description> <development>Argos Builder Version 3.8.2 Build 427</development> <company>Evisions, Inc.</company> <date>Wed, 15 Feb 2012 11:53:12 -0600</date> </information> <query> <ADOOptions/> </query> <parameter_queries/> <parameters> <control Type="Label"> <Align>None</Align> <Alignment>Left</Alignment> <AutoSize>Yes</AutoSize> <DataAware>No</DataAware> <Height>13</Height> <Layout>Top</Layout> <Left>8</Left> <ParentFont>Yes</ParentFont> <Text>Banner Security will allow you to view these ORGNs and FUNDs:</Text> <Top>8</Top> <VariableName>Label1</VariableName> <Width>306</Width> <WordWrap>No</WordWrap> </control> <control Type="MultiColumn"> <Align>None</Align> <AutoSelect>No</AutoSelect> <AutoSizeColumn>0</AutoSizeColumn> <Choices><Data><Lines>SELECT FUND, Fund_Description FROM (select ftvfund_fund_code Fund, FTVFUND_TITLE Fund_Description from (SELECT FTVFUND_FUND_CODE, FTVFUND_TITLE FROM FTVFUND -- FUND IN-LINE VIEW WHERE FTVFUND_EFF_DATE &lt;= SYSDATE AND (FTVFUND_NCHG_DATE &gt; SYSDATE OR FTVFUND_NCHG_DATE IS NULL) AND (FTVFUND_TERM_DATE &gt; SYSDATE OR FTVFUND_TERM_DATE IS NULL) -- AND FTVFUND_STATUS_IND = 'A' ), FOBSYSC where decode(fobsysc_fund_org_security_ind,'Y', f_fund_org_security_fnc('Z',ftvfund_fund_code,'','','',''),'Y')='Y' and FOBSYSC_EFF_DATE &lt;= SYSDATE and (FOBSYSC_NCHG_DATE IS NULL OR FOBSYSC_NCHG_DATE &gt; SYSDATE) and FOBSYSC_STATUS_IND = 'A' ) ORDER BY FUND</Lines><Query><ADOOptions/></Query></Data></Choices> <ChooseField>FUND</ChooseField> <ColumnAligns>Left,Left</ColumnAligns> <ColumnFormats>,</ColumnFormats> <ColumnLines>No</ColumnLines> <Columns>"FUND,,,WideString,0","FUND_DESCRIPTION,,,WideString,0"</Columns> <ColumnVisible>Yes,Yes</ColumnVisible> <ColumnWidths>80,329</ColumnWidths> <Height>219</Height> <Left>0</Left> <MultiSelect>No</MultiSelect> <ParentFont>Yes</ParentFont> <Required>Yes</Required> <RowLines>No</RowLines> <ShowItemCount>No</ShowItemCount> <SqlEntries>Yes</SqlEntries> <TabOrder>1</TabOrder> <TabStop>Yes</TabStop> <Top>160</Top> <VariableName>MultiColumn1</VariableName> <Width>800</Width> </control> <control Type="MultiColumn"> <Align>None</Align> <AutoSelect>No</AutoSelect> <AutoSizeColumn>0</AutoSizeColumn> <Choices><Data><Lines>SELECT ORGN, Orgn_or_Department FROM (select ftvorgn_orgn_code Orgn, FTVORGN_TITLE Orgn_or_Department from (SELECT FTVORGN_ORGN_CODE, FTVORGN_TITLE FROM FTVORGN -- ORGN IN-LINE VIEW WHERE TRUNC(FTVORGN_EFF_DATE) &lt;= SYSDATE AND (FTVORGN_NCHG_DATE &gt; SYSDATE OR FTVORGN_NCHG_DATE IS NULL) AND (FTVORGN_TERM_DATE &gt; SYSDATE OR FTVORGN_TERM_DATE IS NULL) -- AND FTVORGN_STATUS_IND = 'A' ), FOBSYSC where decode(fobsysc_fund_org_security_ind,'Y', f_fund_org_security_fnc('Z','',ftvorgn_orgn_code,'','',''),'Y')='Y' and FOBSYSC_EFF_DATE &lt;= SYSDATE and (FOBSYSC_NCHG_DATE IS NULL OR FOBSYSC_NCHG_DATE &gt; SYSDATE) and FOBSYSC_STATUS_IND = 'A' ) ORDER BY ORGN</Lines><Query><ADOOptions/></Query></Data></Choices> <ChooseField>ORGN</ChooseField> <ColumnAligns>Left,Left</ColumnAligns> <ColumnFormats>,</ColumnFormats> <ColumnLines>No</ColumnLines> <Columns>"ORGN,,,WideString,0","ORGN_OR_DEPARTMENT,,,WideString,0"</Columns> <ColumnVisible>Yes,Yes</ColumnVisible> <ColumnWidths>80,329</ColumnWidths> <Height>115</Height> <Left>0</Left> <MultiSelect>No</MultiSelect> <ParentFont>Yes</ParentFont> <Required>Yes</Required> <RowLines>No</RowLines> <ShowItemCount>No</ShowItemCount> <SqlEntries>Yes</SqlEntries> <TabOrder>0</TabOrder> <TabStop>Yes</TabStop> <Top>32</Top> <VariableName>MultiColumn2</VariableName> <Width>800</Width> </control> </parameters> </datablock>