depreciation_import.lwm

<?xml version="1.0" encoding="UTF-8"?>

<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
                SELECT *
                FROM (SELECT a.period_name
                FROM gld_periods a
                WHERE a.adjustment_flag = 'N'
                AND TO_DATE(a.period_name, 'YYYY-MM') < ADD_MONTHS(SYSDATE, + 0)
                ORDER BY TO_DATE(a.period_name, 'YYYY-MM') DESC) t1
                #WHERE_CLAUSE#
                ]]>
            </bm:query-sql>
        </bm:operation>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
                begin
                hlcm_op_asset_depre_pkg.save_asset_depreciate_hd(
                p_header_id => ${@header_id},
                p_dts => ${@dts},
                p_user_id => ${/session/@user_id}
                );
                end;
                ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>