[Home] [Help]
179: +-----------------------------------------------------------------------*/
180:
181: /* query for borrower name */
182: CURSOR borrower_cur(P_BORROWER_ID number) IS
183: select party_name from hz_parties party where party_id = P_BORROWER_ID;
184:
185: /* query for product name */
186: CURSOR product_cur(P_PRODUCT_ID number) IS
187: select LOAN_PRODUCT_NAME from lns_loan_products_vl where loan_product_id = P_PRODUCT_ID;
774: nvl(ra.amount_applied_from, ra.AMOUNT_APPLIED)
775: from ar_receivable_applications ra,
776: ar_payment_schedules ps,
777: hz_cust_accounts cust,
778: hz_parties party
779: where
780: ra.APPLIED_PAYMENT_SCHEDULE_ID = P_PAYMENT_SCHEDULE_ID and
781: ra.application_type = 'CASH' and
782: ra.display = 'Y' and
1327: hz_cust_accounts cust,
1328: ar_payment_schedules ps,
1329: lns_system_options sys,
1330: gl_sets_of_books books,
1331: hz_parties party,
1332: AR_SYSTEM_PARAMETERS arsys,
1333: ar_cash_receipts cr
1334: where
1335: loan.loan_id = :1 and
1531: from
1532: lns_amortization_scheds am,
1533: lns_loan_headers loan,
1534: ar_payment_schedules ps,
1535: hz_parties party,
1536: lns_loan_products_vl product,
1537: lns_lookups look
1538: where
1539: am.loan_id = P_LOAN_ID and
1574: from
1575: lns_amortization_scheds am,
1576: lns_loan_headers loan,
1577: ar_payment_schedules ps,
1578: hz_parties party,
1579: lns_loan_products_vl product,
1580: lns_lookups look
1581: where
1582: am.loan_id = P_LOAN_ID and
1864: loan.product_id,
1865: product.loan_product_name,
1866: loan.loan_currency
1867: from lns_loan_headers loan,
1868: hz_parties party,
1869: lns_loan_products_vl product
1870: where
1871: loan.primary_borrower_id = nvl(P_BORROWER_ID, loan.primary_borrower_id) and
1872: loan.product_id = nvl(P_PRODUCT_ID, loan.product_id) and