APPS.LNS_PAYOFF_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 170: ,ar_payment_schedules trx

166: ,lam.fee_trx_id
167: from ar_receivable_applications rap
168: ,ar_cash_receipts rac
169: ,lns_amortization_scheds lam
170: ,ar_payment_schedules trx
171: where rap.cash_receipt_id = rac.cash_receipt_id
172: and rap.applied_customer_trx_id = trx.customer_trx_id
173: and trx.customer_trx_id = lam.interest_trx_id
174: and lam.payment_number = LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id)

Line 451: from ar_payment_schedules

447:
448: -- over interest charge had previous applications
449: select amount_due_original + l_payoff_tbl2(i).unbilled_amount
450: into l_new_interest
451: from ar_payment_schedules
452: where payment_schedule_id = l_app_pay_sched_id;
453:
454: else
455: -- over interest charge had no previous applications

Line 860: ,ar_payment_schedules ps

856: ,amount_due_remaining
857: ,am.due_date
858: ,lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', decode(ps.customer_trx_id, principal_trx_Id, 'PRIN', interest_trx_id, 'INT', fee_trx_id, 'FEE')) line_type
859: from lns_amortization_scheds am
860: ,ar_payment_schedules ps
861: ,ra_cust_trx_types tty
862: where (am.principal_trx_id = ps.customer_trx_id OR
863: am.interest_trx_id = ps.customer_trx_id OR
864: am.fee_trx_id = ps.customer_trx_id) and

Line 1190: from ar_payment_schedules

1186: +-----------------------------------------------------------------------*/
1187:
1188: CURSOR receipt_cur(P_RECEIPT_ID number) IS
1189: select ABS(AMOUNT_DUE_REMAINING)
1190: from ar_payment_schedules
1191: where CASH_RECEIPT_ID = P_RECEIPT_ID
1192: and status = 'OP'
1193: and class = 'PMT';
1194:

Line 1197: from ar_payment_schedules

1193: and class = 'PMT';
1194:
1195: cursor c_due_date(p_payment_schedule_id number) is
1196: select due_date
1197: from ar_payment_schedules
1198: where payment_schedule_id = p_payment_schedule_id;
1199:
1200:
1201: BEGIN