[Home] [Help]
11825: +-----------------------------------------------------------------------*/
11826:
11827: CURSOR c_get_xml(p_loan_id NUMBER) IS
11828: SELECT nvl(DOCUMENT_XML, empty_clob())
11829: FROM LNS_LOAN_DOCUMENTS
11830: WHERE source_id = p_loan_id and
11831: SOURCE_TABLE = 'LNS_LOAN_HEADERS_ALL' and
11832: DOCUMENT_TYPE = 'LOAN_AGREEMENT' AND
11833: VERSION = 1;