DBA Data[Home] [Help]

APPS.ARP_ETAX_SERVICES_PKG dependencies on RA_CM_REQUESTS

Line 1313: FROM ar_payment_schedules inv_pay, ra_customer_trx cm, ra_cm_requests cm_line

1309: BEGIN
1310: SELECT inv_pay.amount_line_items_remaining, inv_pay.tax_remaining,
1311: cm_line.line_amount, cm_line.tax_amount
1312: INTO l_inv_line_remaining, l_inv_tax_remaining, l_cmline_line_amount, l_cmline_tax_amount
1313: FROM ar_payment_schedules inv_pay, ra_customer_trx cm, ra_cm_requests cm_line
1314: WHERE cm.customer_trx_id = p_customer_trx_id
1315: AND cm_line.customer_trx_id = cm.previous_customer_trx_id
1316: AND cm_line.cm_customer_trx_id is null
1317: AND cm.previous_customer_trx_id = inv_pay.customer_trx_id;