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 286: FROM ar_payment_schedules ps

282: , l_bill_to_site_use_id
283: , l_ship_to_site_use_id
284: , l_receipt_number
285: , l_legal_entity_id
286: FROM ar_payment_schedules ps
287: , ar_cash_receipts cr
288: , ar_cash_receipt_history crh
289: , ar_receipt_methods rm
290: , ce_bank_acct_uses ba

Line 335: , ar_payment_schedules p

331: , l_amount_due_remaining
332: , l_salesrep_id -- bug 2361331
333: , l_legal_entity_id
334: FROM ra_customer_trx t
335: , ar_payment_schedules p
336: WHERE t.customer_trx_id = p.customer_trx_id
337: AND p.payment_schedule_id = p_invoice_ps_id;
338:
339: SELECT cr.cash_receipt_id, cr.receipt_number

Line 343: ar_payment_schedules ps

339: SELECT cr.cash_receipt_id, cr.receipt_number
340: INTO l_rec_ra_rec.cash_receipt_id
341: , l_receipt_number
342: FROM ar_cash_receipts cr,
343: ar_payment_schedules ps
344: WHERE ps.payment_schedule_id = p_receipt_ps_id
345: AND cr.cash_receipt_id = ps.cash_receipt_id;
346: END IF;
347:

Line 488: lr_ps_rec ar_payment_schedules%ROWTYPE;

484: from ar_distributions ard
485: where ard.source_table = 'RA'
486: and ard.source_id = app.receivable_application_id);
487:
488: lr_ps_rec ar_payment_schedules%ROWTYPE;
489: lr_ra_rec ar_receivable_applications%ROWTYPE;
490:
491: ln_amount_applied NUMBER;
492: ln_acctd_amount_applied_from NUMBER;

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

561: ARP_XLA_EVENTS.delete_event
562: ( p_document_id => p_ra_id,
563: p_doc_table => 'APP');
564:
565: -- Populate the Payment Schedule record from ar_payment_schedules,
566: -- based on the provided Applied_Payment_Schedule_Id.
567: arp_ps_pkg.fetch_p( p_app_ps_id, lr_ps_rec );
568:
569: -- Update the Transaction's Payment Schedule, set flag "Selected for