APPS.ARP_ETAX_SERVICES_PKG dependencies on AR_PAYMENT_SCHEDULES

Line 1281: ar_payment_schedules invp

1277: l_inv_tax_remaining,
1278: l_cm_line_total
1279: FROM ra_customer_trx cm,
1280: ra_customer_trx_lines cml,
1281: ar_payment_schedules invp
1282: WHERE cm.customer_trx_id = p_customer_trx_id
1283: AND cm.customer_trx_id = cml.customer_trx_id
1284: AND cml.line_type = 'LINE'
1285: AND cm.previous_customer_trx_id = invp.customer_trx_id;

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;

Line 1354: ar_payment_schedules invp

1350: l_inv_tax_remaining,
1351: l_cm_line_total
1352: FROM ra_customer_trx cm,
1353: ra_customer_trx_lines cml,
1354: ar_payment_schedules invp
1355: WHERE cm.customer_trx_id = p_customer_trx_id
1356: AND cm.customer_trx_id = cml.customer_trx_id
1357: AND cml.line_type = 'LINE'
1358: AND cm.previous_customer_trx_id = invp.customer_trx_id;