[Home] [Help]
2867: to_char(P_INT_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
2868: to_char(P_FEE_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
2869: to_char((P_PRIN_AMOUNT_DUE + P_INT_AMOUNT_DUE + P_FEE_AMOUNT_DUE), FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50))
2870: from lns_loan_headers loan,
2871: hz_parties party
2872: where party.party_id = loan.PRIMARY_BORROWER_ID and
2873: loan.loan_id = P_LOAN_ID;
2874:
2875: BEGIN
2993: +-----------------------------------------------------------------------*/
2994:
2995: /* query for borrower name */
2996: CURSOR borrower_cur(P_BORROWER_ID number) IS
2997: select party_name from hz_parties party where party_id = P_BORROWER_ID;
2998:
2999: /* query for loan number */
3000: CURSOR loan_cur(P_LOAN_ID number) IS
3001: select loan_number from lns_loan_headers where loan_id = P_LOAN_ID;
3285: 'order by payment_history.AMORTIZATION_SCHEDULE_ID) ' ||
3286: 'AS Recent_Payment_History ' ||
3287:
3288: 'FROM lns_loan_headers_all loan, ' ||
3289: 'hz_parties party, ' ||
3290: 'fnd_territories_tl terr, ' ||
3291: 'hr_all_organization_units_tl org, ' ||
3292: 'LNS_PAYMENTS_SUMMARY_V payment_summary, ' ||
3293: 'lns_amortization_scheds am, ' ||
3294: 'hz_locations loc, ' ||
3295: 'hz_cust_acct_sites_all acct_site, ' ||
3296: 'hz_party_sites site, ' ||
3297: 'fnd_currencies_tl curr, ' ||
3298: 'hz_parties contact_person, ' ||
3299: 'lns_loan_types_vl loan_type, ' ||
3300: 'lns_lookups loan_class, ' ||
3301: 'lns_lookups periodlkup, ' ||
3302: 'lns_lookups loan_subtype, ' ||