APPS.PA_BILLING_WORKBENCH_BILL_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 328: FROM ar_payment_schedules_all arps

324: Nvl(SUM(arps.amount_line_items_original),1) line_amt_orig,
325: Nvl(SUM(arps.amount_line_items_remaining),1)line_amt_remn,
326: Nvl(SUM(arps.tax_original),0) tax_orig,
327: Nvl(SUM(arps.tax_remaining),0) tax_remn
328: FROM ar_payment_schedules_all arps
329: GROUP BY arps.customer_trx_id, arps.trx_number
330: ) pa_ar,
331: (SELECT di.project_id,
332: di.ra_invoice_number,

Line 381: ar_payment_schedules_all arps

377: Nvl(SUM(arps.tax_original),0) tax_orig,
378: Nvl(SUM(arps.tax_remaining),0) tax_remn
379: FROM pa_draft_invoices_all di,
380: pa_draft_invoice_items dii ,
381: ar_payment_schedules_all arps
382: WHERE di.project_id = dii.project_id
383: AND di.draft_invoice_num = dii.draft_invoice_num
384: AND di.transfer_status_code = 'A'
385: AND di.system_reference IS NOT NULL

Line 998: FROM ar_payment_schedules_all arps

994: ARPS.AMOUNT_LINE_ITEMS_ORIGINAL LINE_AMT_ORIG,
995: ARPS.AMOUNT_LINE_ITEMS_REMAINING LINE_AMT_REMN,
996: ARPS.TAX_ORIGINAL TAX_ORIG,
997: ARPS.TAX_REMAINING TAX_REMN
998: FROM ar_payment_schedules_all arps
999: /* GROUP BY arps.customer_trx_id, arps.trx_number Commented for Bug 10125590 */
1000: ) pa_ar,
1001: (SELECT di.project_id,
1002: di.customer_id,

Line 1234: FROM ar_payment_schedules_all arps

1230: Nvl(SUM(arps.amount_line_items_original),1) line_amt_orig,
1231: Nvl(SUM(arps.amount_line_items_remaining),1)line_amt_remn,
1232: Nvl(SUM(arps.tax_original),0) tax_orig,
1233: Nvl(SUM(arps.tax_remaining),0) tax_remn
1234: FROM ar_payment_schedules_all arps
1235: GROUP BY arps.customer_trx_id, arps.trx_number
1236: ) pa_ar,
1237: (SELECT di.project_id,
1238: di.customer_id,

Line 1444: FROM ar_payment_schedules_all ar

1440: BEGIN
1441: SELECT
1442: SUM(ar.amount_line_items_remaining + ar.tax_remaining)
1443: INTO G_ar_amount
1444: FROM ar_payment_schedules_all ar
1445: WHERE p_system_reference IS NOT NULL
1446: AND p_transfer_status_code = 'A'
1447: AND ar.customer_trx_id = p_system_reference;
1448: EXCEPTION

Line 1500: FROM ar_payment_schedules_all ar

1496: BEGIN
1497: SELECT
1498: SUM(ar.tax_original)
1499: INTO l_tax_amount
1500: FROM ar_payment_schedules_all ar
1501: WHERE p_system_reference IS NOT NULL
1502: AND p_transfer_status_code = 'A'
1503: AND ar.customer_trx_id = p_system_reference;
1504: EXCEPTION