APPS.LNS_OCM_ADP_PUB dependencies on LNS_PAY_SUM_OVERDUE_V

Line 2228: LNS_PAY_SUM_OVERDUE_V lps

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