APPS.ARP_ACCT_MAIN dependencies on AR_RECEIVABLE_APPLICATIONS

Line 52: FROM ar_receivable_applications ra

48: ) IS
49:
50: CURSOR get_miss_rec_app IS
51: SELECT ra.cash_receipt_id, ra.receivable_application_id
52: FROM ar_receivable_applications ra
53: WHERE ra.receivable_application_id = p_ae_doc_rec.source_id_old
54: AND ra.status = 'APP'
55: AND ra.application_type = 'CASH'
56: AND ra.posting_control_id <> -3

Line 692: FROM ar_receivable_applications

688:
689: CURSOR get_app_info(p_cash_receipt_id IN NUMBER) IS
690: SELECT receivable_application_id,
691: status
692: FROM ar_receivable_applications
693: where cash_Receipt_id = p_cash_receipt_id;
694:
695: CURSOR get_cm_info (p_request_id IN number) IS
696: select rec.customer_trx_id customer_trx_id,

Line 698: from AR_RECEIVABLE_APPLICATIONS rec,

694:
695: CURSOR get_cm_info (p_request_id IN number) IS
696: select rec.customer_trx_id customer_trx_id,
697: rec.receivable_application_id rec_app_id
698: from AR_RECEIVABLE_APPLICATIONS rec,
699: RA_CUSTOMER_TRX trx
700: where trx.customer_trx_id = rec.customer_trx_id
701: and trx.request_id = p_request_id;
702:

Line 708: old_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;

704: SELECT adjustment_id, code_combination_id
705: FROM ar_adjustments
706: WHERE request_id = p_request_id;
707:
708: old_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
709: --Bug#2750340
710: l_xla_ev_rec arp_xla_events.xla_events_type;
711: l_xla_doc_table VARCHAR2(20);
712:

Line 1017: l_paired_id ar_receivable_applications.receivable_application_id%TYPE;

1013: p_ae_doc_rec IN OUT NOCOPY ae_doc_rec_type,
1014: p_ae_event_rec IN ae_event_rec_type
1015: ) IS
1016: l_ae_deleted BOOLEAN := FALSE;
1017: l_paired_id ar_receivable_applications.receivable_application_id%TYPE;
1018: l_accounting_method ar_system_parameters.accounting_method%TYPE;
1019:
1020: BEGIN
1021: IF PG_DEBUG in ('Y', 'C') THEN