[Home] [Help]
3091: to_char(P_INT_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
3092: to_char(P_FEE_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
3093: to_char((P_PRIN_AMOUNT_DUE + P_INT_AMOUNT_DUE + P_FEE_AMOUNT_DUE), FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50))
3094: from lns_loan_headers loan,
3095: hz_parties party
3096: where party.party_id = loan.PRIMARY_BORROWER_ID and
3097: loan.loan_id = P_LOAN_ID;
3098:
3099: BEGIN
3225: +-----------------------------------------------------------------------*/
3226:
3227: /* query for borrower name */
3228: CURSOR borrower_cur(P_BORROWER_ID number) IS
3229: select party_name from hz_parties party where party_id = P_BORROWER_ID;
3230:
3231: /* query for loan number */
3232: CURSOR loan_cur(P_LOAN_ID number) IS
3233: select loan_number from lns_loan_headers where loan_id = P_LOAN_ID;
3556: 'order by payment_history.AMORTIZATION_SCHEDULE_ID) ' ||
3557: 'AS Recent_Payment_History ' ||
3558:
3559: 'FROM lns_loan_headers_all_vl loan, ' ||
3560: 'hz_parties party, ' ||
3561: 'fnd_territories_tl terr, ' ||
3562: 'hr_all_organization_units_tl org, ' ||
3563: 'LNS_PAY_SUM_V PAY_SUM, ' ||
3564: 'LNS_PAY_SUM_YEARLY_V PAY_SUM_YEARLY, ' ||
3567: 'hz_locations loc, ' ||
3568: 'hz_cust_acct_sites_all acct_site, ' ||
3569: 'hz_party_sites site, ' ||
3570: 'fnd_currencies_tl curr, ' ||
3571: 'hz_parties contact_person, ' ||
3572: 'lns_loan_types_vl loan_type, ' ||
3573: 'lns_lookups loan_class, ' ||
3574: 'lns_lookups periodlkup, ' ||
3575: 'lns_lookups loan_subtype, ' ||