APPS.ARP_BR_REMIT_FUNCTION SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14

select amount_dr
from ar_distributions
where source_id=p_trh_id
and   source_table='TH'
and   source_type=p2_status;

Line: 21

select amount_applied
from ar_receivable_applications
where applied_customer_trx_id=p_customer_trx_id
and   status='APP'
and   link_to_trx_hist_id=p_trh_id;

Line: 79

select acctd_amount_dr
from ar_distributions
where source_id=p_trh_id
and   source_table='TH'
and   source_type=p2_status;

Line: 86

select amount_applied_from
from ar_receivable_applications
where applied_customer_trx_id=p_customer_trx_id
and   status='APP'
and   link_to_trx_hist_id=p_trh_id;