APPS.ARP_PROCESS_APPLICATION dependencies on AR_RECEIVABLES_TRX

Line 110: p_activity_type IN ar_receivables_trx.type%TYPE);

106: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE);
107:
108: PROCEDURE validate_activity(
109: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
110: p_activity_type IN ar_receivables_trx.type%TYPE);
111:
112: PROCEDURE reverse_action_receipt_cb(
113: p_chargeback_customer_trx_id IN ar_receivable_applications.application_ref_id%TYPE,
114: p_reversal_gl_date IN DATE,

Line 2083: , ar_receivables_trx ed

2079: FROM
2080: ar_receipt_method_accounts rma
2081: , ar_payment_schedules ps
2082: , ar_cash_receipts cr
2083: , ar_receivables_trx ed
2084: , ar_receivables_trx uned
2085: WHERE
2086: cr.cash_receipt_id = p_ra_rec.cash_receipt_id
2087: AND cr.cash_receipt_id = ps.cash_receipt_id

Line 2084: , ar_receivables_trx uned

2080: ar_receipt_method_accounts rma
2081: , ar_payment_schedules ps
2082: , ar_cash_receipts cr
2083: , ar_receivables_trx ed
2084: , ar_receivables_trx uned
2085: WHERE
2086: cr.cash_receipt_id = p_ra_rec.cash_receipt_id
2087: AND cr.cash_receipt_id = ps.cash_receipt_id
2088: AND rma.receipt_method_id = cr.receipt_method_id

Line 3646: , ar_receivables_trx ed

3642: , ar_receipt_methods rm
3643: , ce_bank_acct_uses_ou ba
3644: , ar_receipt_method_accounts rma
3645: , ar_payment_schedules ps
3646: , ar_receivables_trx ed
3647: , ar_receivables_trx uned
3648: WHERE ps.payment_schedule_id = p_receipt_ps_id
3649: AND cr.cash_receipt_id = ps.cash_receipt_id
3650: AND cr.cash_receipt_id = crh.cash_receipt_id

Line 3647: , ar_receivables_trx uned

3643: , ce_bank_acct_uses_ou ba
3644: , ar_receipt_method_accounts rma
3645: , ar_payment_schedules ps
3646: , ar_receivables_trx ed
3647: , ar_receivables_trx uned
3648: WHERE ps.payment_schedule_id = p_receipt_ps_id
3649: AND cr.cash_receipt_id = ps.cash_receipt_id
3650: AND cr.cash_receipt_id = crh.cash_receipt_id
3651: AND crh.current_record_flag = 'Y'

Line 5825: ar_receivables_trx rt

5821: ar_cash_receipt_history crh,
5822: ar_receipt_methods rm,
5823: ce_bank_acct_uses ba,
5824: ar_receipt_method_accounts rma,
5825: ar_receivables_trx rt
5826: WHERE ps.payment_schedule_id = p_receipt_ps_id
5827: AND cr.cash_receipt_id = ps.cash_receipt_id
5828: AND crh.cash_receipt_id = cr.cash_receipt_id
5829: AND crh.current_record_flag = 'Y'

Line 6825: p_activity_type IN ar_receivables_trx.type%TYPE) IS

6821: | |
6822: +===========================================================================*/
6823: PROCEDURE validate_activity(
6824: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6825: p_activity_type IN ar_receivables_trx.type%TYPE) IS
6826:
6827: BEGIN
6828: IF PG_DEBUG in ('Y', 'C') THEN
6829: arp_debug.debug( 'arp_process_application.validate_activity()+' );

Line 7168: , ar_receivables_trx rt

7164: , ar_cash_receipt_history crh
7165: , ar_receipt_methods rm
7166: , ce_bank_acct_uses ba
7167: , ar_receipt_method_accounts rma
7168: , ar_receivables_trx rt
7169: WHERE ps.payment_schedule_id = p_receipt_ps_id
7170: AND cr.cash_receipt_id = ps.cash_receipt_id
7171: AND crh.cash_receipt_id = cr.cash_receipt_id
7172: AND crh.current_record_flag = 'Y'

Line 8855: FROM ar_receivables_trx

8851: l_inv_ra_rec.postable := 'N';
8852: End if;
8853:
8854: select code_combination_id INTO l_inv_ra_rec.code_combination_id
8855: FROM ar_receivables_trx
8856: WHERE receivables_trx_id = p_receivables_trx_id;
8857:
8858: /*Bug 9488876 value for use in BS substitute*/
8859: l_activity_ccid := l_inv_ra_rec.code_combination_id;