APPS.LNS_BORROWERS_SUMMARY_PUB dependencies on LNS_PARTICIPANTS

Line 315: lns_participants par,

311: nvl(count(head.loan_id), 0),
312: nvl(sum(decode(head.LOAN_CURRENCY, P_CURRENCY, head.REQUESTED_AMOUNT, (head.REQUESTED_AMOUNT*head.EXCHANGE_RATE))), 0),
313: nvl(sum(decode(head.LOAN_CURRENCY, P_CURRENCY, head.FUNDED_AMOUNT, (head.FUNDED_AMOUNT*head.EXCHANGE_RATE))), 0)
314: from
315: lns_participants par,
316: lns_loan_headers_all head
317: where
318: par.hz_party_id = P_PARTY_ID and
319: par.loan_id = head.loan_id and

Line 338: lns_participants par

334: from
335: lns_loan_headers_ALL loan,
336: LNS_AMORTIZATION_SCHEDS am,
337: ar_receivable_applications_ALL rec,
338: lns_participants par
339: where
340: par.hz_party_id = P_PARTY_ID and
341: par.loan_participant_type in ('PRIMARY_BORROWER', 'COBORROWER') and
342: par.loan_id = loan.loan_id and

Line 956: lns_participants par,

952: distinct party.party_id,
953: party.PARTY_NUMBER,
954: party.party_name
955: from
956: lns_participants par,
957: hz_parties party,
958: lns_loan_headers_all head
959: where
960: party.party_id = nvl(P_BORROWER_ID, party.party_id) and