APPS.LNS_BORROWERS_SUMMARY_PUB dependencies on LNS_LOAN_HEADERS_ALL

Line 316: lns_loan_headers_all head

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
320: par.loan_participant_type in ('PRIMARY_BORROWER', 'COBORROWER') and

Line 335: lns_loan_headers_ALL loan,

331: CURSOR amount_ytd_cur(P_PARTY_ID number, P_LINE_TYPE VARCHAR2, P_TIME_FLAG VARCHAR2, P_ORG_ID number) IS
332: select
333: nvl(sum(rec.ACCTD_AMOUNT_APPLIED_TO), 0)
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

Line 958: lns_loan_headers_all head

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
961: party.party_id = par.hz_party_id and
962: par.loan_id = head.loan_id and