APPS.ARP_PROCESS_APPLICATION2 dependencies on AR_PAYMENT_SCHEDULES

Line 135: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,

131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_acctd_amount_applied_to OUT NOCOPY NUMBER,
134: p_acctd_amount_applied_from OUT NOCOPY NUMBER,
135: p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE,
136: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE,
137: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
138: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
139: p_applied_rec_app_id IN ar_receivable_applications.applied_rec_app_id%TYPE,

Line 297: FROM ar_payment_schedules ps

293: , l_bill_to_site_use_id
294: , l_ship_to_site_use_id
295: , l_receipt_number
296: , l_legal_entity_id
297: FROM ar_payment_schedules ps
298: , ar_cash_receipts cr
299: , ar_cash_receipt_history crh
300: , ar_receipt_methods rm
301: , ce_bank_acct_uses ba

Line 346: , ar_payment_schedules p

342: , l_amount_due_remaining
343: , l_salesrep_id -- bug 2361331
344: , l_legal_entity_id
345: FROM ra_customer_trx t
346: , ar_payment_schedules p
347: WHERE t.customer_trx_id = p.customer_trx_id
348: AND p.payment_schedule_id = p_invoice_ps_id;
349:
350: SELECT cr.cash_receipt_id, cr.receipt_number

Line 354: ar_payment_schedules ps

350: SELECT cr.cash_receipt_id, cr.receipt_number
351: INTO l_rec_ra_rec.cash_receipt_id
352: , l_receipt_number
353: FROM ar_cash_receipts cr,
354: ar_payment_schedules ps
355: WHERE ps.payment_schedule_id = p_receipt_ps_id
356: AND cr.cash_receipt_id = ps.cash_receipt_id;
357: END IF;
358:

Line 499: lr_ps_rec ar_payment_schedules%ROWTYPE;

495: from ar_distributions ard
496: where ard.source_table = 'RA'
497: and ard.source_id = app.receivable_application_id);
498:
499: lr_ps_rec ar_payment_schedules%ROWTYPE;
500: lr_ra_rec ar_receivable_applications%ROWTYPE;
501:
502: ln_amount_applied NUMBER;
503: ln_acctd_amount_applied_from NUMBER;

Line 576: -- Populate the Payment Schedule record from ar_payment_schedules,

572: ARP_XLA_EVENTS.delete_event
573: ( p_document_id => p_ra_id,
574: p_doc_table => 'APP');
575:
576: -- Populate the Payment Schedule record from ar_payment_schedules,
577: -- based on the provided Applied_Payment_Schedule_Id.
578: arp_ps_pkg.fetch_p( p_app_ps_id, lr_ps_rec );
579:
580: -- Update the Transaction's Payment Schedule, set flag "Selected for