DBA Data[Home] [Help]

APPS.LNS_BILLING_UTIL_PUB dependencies on LNS_LOAN_HEADERS_ALL

Line 751: from lns_loan_headers_all loan

747: rec.org_id = loan.org_id and
748: am.loan_id = loan.loan_id and
749: am.principal_trx_id is not null and
750: nvl(am.PHASE, 'TERM') = nvl(loan.CURRENT_PHASE, 'TERM'))
751: from lns_loan_headers_all loan
752: where loan.loan_id = P_LOAN_ID;
753:
754: BEGIN
755: OPEN get_data_crs(P_LOAN_ID, P_DATE);