APPS.PA_BILLING_WORKBENCH_BILL_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 322: FROM ar_payment_schedules_all ar,

318: l_proj_inv_due,
319: l_proj_inv_orig,
320: l_proj_tax_orig,
321: l_proj_tax_due
322: FROM ar_payment_schedules_all ar,
323: (SELECT di.project_id,
324: di.system_reference system_reference,
325: SUM(dii.projfunc_bill_amount) pfc_inv_amt,
326: SUM(dii.project_bill_amount) pc_inv_amt

Line 935: FROM ar_payment_schedules_all ar,

931: SUM(( pa_inv.pc_inv_amt /ar.amount_line_items_original) *
932: ar.tax_remaining) tax_due_pc,
933: SUM(( pa_inv.pfc_inv_amt /ar.amount_line_items_original) *
934: ar.tax_remaining) tax_due_pfc
935: FROM ar_payment_schedules_all ar,
936: (SELECT di.project_id,
937: di.customer_id,
938: di.agreement_id,
939: di.system_reference system_reference,

Line 1166: FROM ar_payment_schedules_all ar,

1162: SUM(( pa_inv.pc_inv_amt /ar.amount_line_items_original) *
1163: ar.tax_remaining) tax_due_pc,
1164: SUM(( pa_inv.pfc_inv_amt /ar.amount_line_items_original) *
1165: ar.tax_remaining) tax_due_pfc
1166: FROM ar_payment_schedules_all ar,
1167: (SELECT di.project_id,
1168: di.customer_id,
1169: di.agreement_id,
1170: di.system_reference system_reference,

Line 1372: FROM ar_payment_schedules_all ar

1368: BEGIN
1369: SELECT
1370: SUM(ar.amount_line_items_remaining + ar.tax_remaining)
1371: INTO G_ar_amount
1372: FROM ar_payment_schedules_all ar
1373: WHERE p_system_reference IS NOT NULL
1374: AND p_transfer_status_code = 'A'
1375: AND ar.customer_trx_id = p_system_reference;
1376: EXCEPTION

Line 1428: FROM ar_payment_schedules_all ar

1424: BEGIN
1425: SELECT
1426: SUM(ar.tax_original)
1427: INTO l_tax_amount
1428: FROM ar_payment_schedules_all ar
1429: WHERE p_system_reference IS NOT NULL
1430: AND p_transfer_status_code = 'A'
1431: AND ar.customer_trx_id = p_system_reference;
1432: EXCEPTION