APPS.ARP_ACCT_MAIN dependencies on AR_RECEIVABLE_APPLICATIONS

Line 529: FROM ar_receivable_applications

525:
526: CURSOR get_app_info(p_cash_receipt_id IN NUMBER) IS
527: SELECT receivable_application_id,
528: status
529: FROM ar_receivable_applications
530: where cash_Receipt_id = p_cash_receipt_id;
531:
532: CURSOR get_cm_info (p_request_id IN number) IS
533: select rec.customer_trx_id customer_trx_id,

Line 535: from AR_RECEIVABLE_APPLICATIONS rec,

531:
532: CURSOR get_cm_info (p_request_id IN number) IS
533: select rec.customer_trx_id customer_trx_id,
534: rec.receivable_application_id rec_app_id
535: from AR_RECEIVABLE_APPLICATIONS rec,
536: RA_CUSTOMER_TRX trx
537: where trx.customer_trx_id = rec.customer_trx_id
538: and trx.request_id = p_request_id;
539:

Line 545: old_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;

541: SELECT adjustment_id, code_combination_id
542: FROM ar_adjustments
543: WHERE request_id = p_request_id;
544:
545: old_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
546: --Bug#2750340
547: l_xla_ev_rec arp_xla_events.xla_events_type;
548: l_xla_doc_table VARCHAR2(20);
549:

Line 704: l_paired_id ar_receivable_applications.receivable_application_id%TYPE;

700: p_ae_doc_rec IN OUT NOCOPY ae_doc_rec_type,
701: p_ae_event_rec IN ae_event_rec_type
702: ) IS
703: l_ae_deleted BOOLEAN := FALSE;
704: l_paired_id ar_receivable_applications.receivable_application_id%TYPE;
705: l_accounting_method ar_system_parameters.accounting_method%TYPE;
706:
707: BEGIN
708: IF PG_DEBUG in ('Y', 'C') THEN