APPS.LNS_APPROVAL_ACTION_PUB dependencies on LNS_AMORTIZATION_SCHEDS

Line 542: lns_amortization_scheds am

538: /* get statement after its billed */
539: CURSOR get_statement_cur(P_LOAN_ID number) IS
540: select STATEMENT_XML
541: from LNS_LOAN_HEADERS loan,
542: lns_amortization_scheds am
543: where loan.loan_id = am.loan_id and
544: am.AMORTIZATION_SCHEDULE_ID = loan.LAST_AMORTIZATION_ID and
545: am.PAYMENT_NUMBER = loan.LAST_PAYMENT_NUMBER and
546: loan.loan_id = P_LOAN_ID;