<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: qwm $
    $Date: 2014/01/13 05:48:38 $
    $Revision: 1.5 $
    $Purpose: 
-->
<ns1:model xmlns:ns1="http://www.leaf-framework.org/schema/bm" defaultOrderBy="start_date desc" extend="gld.gld_period_status_v" extendMode="reference">
    <ns1:fields>
        <ns1:field name="period_year" databaseType="VARCHAR2" datatype="java.lang.String" displayWidth="200" forQuery="true" fordisplay="true" prompt="GLD_PERIODS.PERIOD_YEAR" queryWidth="150"/>
        <ns1:field name="internal_period_num" databaseType="BIGINT" datatype="java.lang.Long"/>
        <ns1:field name="period_name" databaseType="VARCHAR2" datatype="java.lang.String" displayWidth="230" forQuery="true" fordisplay="true" prompt="GLD_PERIODS.PERIOD_NAME" queryWidth="150"/>
    </ns1:fields>
    <ns1:query-fields>
        <ns1:query-field field="period_year" queryOperator="like"/>
        <ns1:query-field field="period_name" queryOperator="like"/>
        <ns1:query-field field="period_status_code" queryOperator="="/>
        <ns1:query-field field="start_date" queryOperator="&lt;="/>
        <ns1:query-field field="end_date" queryOperator="&gt;="/>
        <ns1:query-field name="monthly_closed_flag" queryExpression="nvl(MONTHLY_CLOSED_FLAG,&apos;N&apos;) = &apos;N&apos; "/>
    </ns1:query-fields>
    <ns1:data-filters>
        <!-- <ns1:data-filter enforceActions="query" expression="              period_set_code =             (select period_set_code             from gld_set_of_books             where set_of_books_id =             (select set_of_books_id             from fnd_companies             where company_id = ${/session/@top_biz_company_id})) "/> -->
        <ns1:data-filter enforceActions="query" expression=" company_id =${/session/@company_id} "/>
        <!-- <ns1:data-filter enforceActions="query" expression=" nvl(MONTHLY_CLOSED_FLAG,&apos;N&apos;) = &apos;N&apos; "/> -->
    </ns1:data-filters>
    <ns1:ref-fields/>
</ns1:model>
