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);