eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_BORROWERS_SUMMARY_PUB dependencies on LNS_PARTICIPANTS

Line 313: lns_participants par,

309: CURSOR loans_count_cur(P_PARTY_ID number, P_ORG_ID number) IS
310: select
311: nvl(count(head.loan_id), 0)
312: from
313: lns_participants par,
314: lns_loan_headers_all head
315: where
316: par.hz_party_id = P_PARTY_ID and
317: par.loan_id = head.loan_id and

Line 328: lns_participants par,

324: --nvl(count(head.loan_id), 0),
325: nvl(sum(decode(head.LOAN_CURRENCY, P_CURRENCY, head.REQUESTED_AMOUNT + head.ADD_REQUESTED_AMOUNT, ((head.REQUESTED_AMOUNT+ head.ADD_REQUESTED_AMOUNT)*head.EXCHANGE_RATE))), 0),
326: nvl(sum(decode(head.LOAN_CURRENCY, P_CURRENCY, head.FUNDED_AMOUNT, (head.FUNDED_AMOUNT*head.EXCHANGE_RATE))), 0)
327: from
328: lns_participants par,
329: lns_loan_headers_all head
330: where
331: par.hz_party_id = P_PARTY_ID and
332: par.loan_id = head.loan_id and

Line 351: lns_participants par

347: from
348: lns_loan_headers_ALL loan,
349: LNS_AMORTIZATION_SCHEDS am,
350: ar_receivable_applications_ALL rec,
351: lns_participants par
352: where
353: par.hz_party_id = P_PARTY_ID and
354: par.loan_participant_type in ('PRIMARY_BORROWER', 'COBORROWER', 'GUARANTOR') and
355: par.loan_id = loan.loan_id and

Line 974: lns_participants par,

970: distinct party.party_id,
971: party.PARTY_NUMBER,
972: party.party_name
973: from
974: lns_participants par,
975: hz_parties party,
976: lns_loan_headers_all head
977: where
978: party.party_id = nvl(P_BORROWER_ID, party.party_id) and