APPS.ARP_PROCESS_APPLICATION dependencies on AR_RECEIVABLES_TRX

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

102: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE);
103:
104: PROCEDURE validate_activity(
105: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
106: p_activity_type IN ar_receivables_trx.type%TYPE);
107:
108: PROCEDURE reverse_action_receipt_cb(
109: p_chargeback_customer_trx_id IN ar_receivable_applications.application_ref_id%TYPE,
110: p_reversal_gl_date IN DATE,

Line 2000: , ar_receivables_trx ed

1996: FROM
1997: ar_receipt_method_accounts rma
1998: , ar_payment_schedules ps
1999: , ar_cash_receipts cr
2000: , ar_receivables_trx ed
2001: , ar_receivables_trx uned
2002: WHERE
2003: cr.cash_receipt_id = p_ra_rec.cash_receipt_id
2004: AND cr.cash_receipt_id = ps.cash_receipt_id

Line 2001: , ar_receivables_trx uned

1997: ar_receipt_method_accounts rma
1998: , ar_payment_schedules ps
1999: , ar_cash_receipts cr
2000: , ar_receivables_trx ed
2001: , ar_receivables_trx uned
2002: WHERE
2003: cr.cash_receipt_id = p_ra_rec.cash_receipt_id
2004: AND cr.cash_receipt_id = ps.cash_receipt_id
2005: AND rma.receipt_method_id = cr.receipt_method_id

Line 3473: , ar_receivables_trx ed

3469: , ar_receipt_methods rm
3470: , ce_bank_acct_uses_ou ba
3471: , ar_receipt_method_accounts rma
3472: , ar_payment_schedules ps
3473: , ar_receivables_trx ed
3474: , ar_receivables_trx uned
3475: WHERE ps.payment_schedule_id = p_receipt_ps_id
3476: AND cr.cash_receipt_id = ps.cash_receipt_id
3477: AND cr.cash_receipt_id = crh.cash_receipt_id

Line 3474: , ar_receivables_trx uned

3470: , ce_bank_acct_uses_ou ba
3471: , ar_receipt_method_accounts rma
3472: , ar_payment_schedules ps
3473: , ar_receivables_trx ed
3474: , ar_receivables_trx uned
3475: WHERE ps.payment_schedule_id = p_receipt_ps_id
3476: AND cr.cash_receipt_id = ps.cash_receipt_id
3477: AND cr.cash_receipt_id = crh.cash_receipt_id
3478: AND crh.current_record_flag = 'Y'

Line 5477: ar_receivables_trx rt

5473: ar_cash_receipt_history crh,
5474: ar_receipt_methods rm,
5475: ce_bank_acct_uses ba,
5476: ar_receipt_method_accounts rma,
5477: ar_receivables_trx rt
5478: WHERE ps.payment_schedule_id = p_receipt_ps_id
5479: AND cr.cash_receipt_id = ps.cash_receipt_id
5480: AND crh.cash_receipt_id = cr.cash_receipt_id
5481: AND crh.current_record_flag = 'Y'

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

6469: | |
6470: +===========================================================================*/
6471: PROCEDURE validate_activity(
6472: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6473: p_activity_type IN ar_receivables_trx.type%TYPE) IS
6474:
6475: BEGIN
6476: IF PG_DEBUG in ('Y', 'C') THEN
6477: arp_standard.debug( 'arp_process_application.validate_activity()+' );

Line 6816: , ar_receivables_trx rt

6812: , ar_cash_receipt_history crh
6813: , ar_receipt_methods rm
6814: , ce_bank_acct_uses ba
6815: , ar_receipt_method_accounts rma
6816: , ar_receivables_trx rt
6817: WHERE ps.payment_schedule_id = p_receipt_ps_id
6818: AND cr.cash_receipt_id = ps.cash_receipt_id
6819: AND crh.cash_receipt_id = cr.cash_receipt_id
6820: AND crh.current_record_flag = 'Y'

Line 8344: FROM ar_receivables_trx

8340: l_inv_ra_rec.postable := 'N';
8341: End if;
8342:
8343: select code_combination_id INTO l_inv_ra_rec.code_combination_id
8344: FROM ar_receivables_trx
8345: WHERE receivables_trx_id = p_receivables_trx_id;
8346:
8347: -- This is passed back to the client as the true acctd amount (calculated
8348: -- in the payment schedule utility procedure).