<?xml version="1.0" encoding="UTF-8"?><bm:modelxmlns:bm="http://www.leaf-framework.org/schema/bm"alias="gp"baseTable="GLD_PERIODS"><bm:fields><bm:fieldname="period_set_code"databaseType="VARCHAR2"datatype="java.lang.String"/><bm:fieldname="period_year"databaseType="NUMBER"datatype="java.lang.Long"/><bm:fieldname="period_num"databaseType="NUMBER"datatype="java.lang.Long"/><bm:fieldname="period_name"databaseType="VARCHAR2"datatype="java.lang.String"/><bm:fieldname="adjustment_flag"databaseType="VARCHAR2"datatype="java.lang.String"/><bm:fieldname="internal_period_num"databaseType="NUMBER"datatype="java.lang.Long"/><bm:fieldname="start_date"databaseType="DATE"datatype="java.util.Date"/><bm:fieldname="end_date"databaseType="DATE"datatype="java.util.Date"/><bm:fieldname="quarter_num"databaseType="NUMBER"datatype="java.lang.Long"/></bm:fields><bm:primary-key><bm:pk-fieldname="internal_period_num"/><bm:pk-fieldname="period_set_code"/></bm:primary-key><bm:query-fields><bm:query-fieldname="company_id"queryExpression="period_set_code=(select gd.period_set_code from gld_set_of_books gd,fnd_companies fc where gd.set_of_books_id=fc.set_of_books_id and fc.company_id=${/session/@company_id})"/><bm:query-fieldname="date"queryExpression="start_date <= to_date(${@date},'yyyy-mm-dd') and end_date>= to_date(${@date},'yyyy-mm-dd')"/></bm:query-fields></bm:model>