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 437: from ar_payment_schedules

433:
434: -- over interest charge had previous applications
435: select amount_due_original + l_payoff_tbl2(i).unbilled_amount
436: into l_new_interest
437: from ar_payment_schedules
438: where payment_schedule_id = l_app_pay_sched_id;
439:
440: else
441: -- over interest charge had no previous applications

Line 772: ,ar_payment_schedules ps

768: ,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
769: ,ps.TRX_DATE
770: ,ps.GL_DATE
771: from lns_amortization_scheds am
772: ,ar_payment_schedules ps
773: ,ra_cust_trx_types tty
774: where (am.principal_trx_id = ps.customer_trx_id OR
775: am.interest_trx_id = ps.customer_trx_id OR
776: am.fee_trx_id = ps.customer_trx_id) and

Line 1143: from ar_payment_schedules

1139: +-----------------------------------------------------------------------*/
1140:
1141: CURSOR receipt_cur(P_RECEIPT_ID number) IS
1142: select ABS(AMOUNT_DUE_REMAINING)
1143: from ar_payment_schedules
1144: where CASH_RECEIPT_ID = P_RECEIPT_ID
1145: and status = 'OP'
1146: and class = 'PMT';
1147:

Line 1150: from ar_payment_schedules

1146: and class = 'PMT';
1147:
1148: cursor c_due_date(p_payment_schedule_id number) is
1149: select due_date
1150: from ar_payment_schedules
1151: where payment_schedule_id = p_payment_schedule_id;
1152:
1153:
1154: BEGIN

Line 1514: ,ar_payment_schedules ps

1510: ,ps.due_date
1511: ,ps.TRX_DATE
1512: ,ps.GL_DATE
1513: from lns_amortization_scheds am
1514: ,ar_payment_schedules ps
1515: ,ra_cust_trx_types tty
1516: where (am.principal_trx_id = ps.customer_trx_id OR
1517: am.interest_trx_id = ps.customer_trx_id OR
1518: am.fee_trx_id = ps.customer_trx_id) and

Line 2698: ,ar_payment_schedules ps

2694: ,ps.trx_date
2695: ,ps.gl_date
2696: from lns_loan_headers loan
2697: ,lns_amortization_scheds am
2698: ,ar_payment_schedules ps
2699: where loan.loan_id = P_LOAN_ID and
2700: loan.LAST_AMORTIZATION_ID = am.AMORTIZATION_SCHEDULE_ID and
2701: ps.customer_trx_id in (am.principal_trx_id, am.interest_trx_id, am.fee_trx_id);
2702:

Line 3426: FROM ar_payment_schedules_all psa,

3422:
3423: CURSOR get_psa_cur(P_LOAN_ID number) IS
3424: SELECT psa.payment_schedule_id,
3425: am.AMORTIZATION_SCHEDULE_ID
3426: FROM ar_payment_schedules_all psa,
3427: LNS_LOAN_HEADERS_ALL loan,
3428: lns_amortization_scheds am
3429: WHERE loan.loan_id = am.loan_id and
3430: am.AMORTIZATION_SCHEDULE_ID = loan.LAST_AMORTIZATION_ID and