<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
select nvl(bgfl_special_parameter_pkg.get_special_parameter_values('GUARANTOR_NAMES',
                                                               ${/parameter/@contract_id},
                                                               'GUARANTOR'),'/') guarantor_names,
       nvl(bgfl_special_parameter_pkg.get_special_parameter_values('MORTGAGE_NAMES',
                                                               ${/parameter/@contract_id},
                                                               'PLEDGER'),'/') mortgage_names,
       nvl(bgfl_special_parameter_pkg.get_special_parameter_values('PLEDGE_NAMES',
                                                               ${/parameter/@contract_id},
                                                               'PLEDGER'),'/') pledge_names
  from dual
        ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:fields>
        <bm:field name="guarantor_names" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GUARANTOR_NAMES"/>
        <bm:field name="mortgage_names" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_NAMES"/>
        <bm:field name="pledge_names" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PLEDGE_NAMES"/>
    </bm:fields>
</bm:model>
