APPS.LNS_OCM_ADP_PUB dependencies on LNS_PAY_SUM_OVERDUE_V

Line 2230: LNS_PAY_SUM_OVERDUE_V lps

2226:
2227: CURSOR total_active_loans_overdue(C_LOAN_ID NUMBER , C_PARTY_ID NUMBER) IS
2228: SELECT sum( nvl(lps.total_overdue ,0) ) , llh.loan_currency
2229: FROM lns_loan_headers_all llh ,
2230: LNS_PAY_SUM_OVERDUE_V lps
2231: WHERE llh.loan_id = lps.loan_id
2232: AND llh.loan_id IN ( SELECT loan_id
2233: FROM lns_participants
2234: WHERE hz_party_id IN ( SELECT hz_party_id