[Home] [Help]
178: +-----------------------------------------------------------------------*/
179:
180: /* query for borrower name */
181: CURSOR borrower_cur(P_BORROWER_ID number) IS
182: select party_name from hz_parties party where party_id = P_BORROWER_ID;
183:
184: /* query for product name */
185: CURSOR product_cur(P_PRODUCT_ID number) IS
186: select LOAN_PRODUCT_NAME from lns_loan_products_vl where loan_product_id = P_PRODUCT_ID;
737: nvl(ra.amount_applied_from, ra.AMOUNT_APPLIED)
738: from ar_receivable_applications ra,
739: ar_payment_schedules psa,
740: hz_cust_accounts cust,
741: hz_parties party
742: where
743: ra.APPLIED_PAYMENT_SCHEDULE_ID = P_PAYMENT_SCHEDULE_ID and
744: ra.application_type = 'CASH' and
745: ra.display = 'Y' and
1274: hz_cust_accounts cust,
1275: ar_payment_schedules psa,
1276: lns_system_options sys,
1277: gl_sets_of_books books,
1278: hz_parties party,
1279: AR_SYSTEM_PARAMETERS arsys
1280: where
1281: loan.loan_id = P_LOAN_ID and
1282: loan.loan_id = par.loan_id and
1461: from
1462: lns_amortization_scheds am,
1463: lns_loan_headers loan,
1464: ar_payment_schedules psa,
1465: hz_parties party,
1466: lns_loan_products_vl product,
1467: lns_lookups look
1468: where
1469: am.loan_id = P_LOAN_ID and
1504: from
1505: lns_amortization_scheds am,
1506: lns_loan_headers loan,
1507: ar_payment_schedules psa,
1508: hz_parties party,
1509: lns_loan_products_vl product,
1510: lns_lookups look
1511: where
1512: am.loan_id = P_LOAN_ID and
1788: loan.product_id,
1789: product.loan_product_name,
1790: loan.loan_currency
1791: from lns_loan_headers loan,
1792: hz_parties party,
1793: lns_loan_products_vl product
1794: where
1795: loan.primary_borrower_id = nvl(P_BORROWER_ID, loan.primary_borrower_id) and
1796: loan.product_id = nvl(P_PRODUCT_ID, loan.product_id) and