APPS.PA_CMT_UTILS dependencies on AP_INVOICES_ALL

Line 371: ap_invoices_all inv

367: SUM(dist.pa_quantity*(SUM(nvl(paydist.paid_base_amount,paydist.amount))/(nvl(dist.base_amount,dist.amount))))
368: into l_inv_num, l_tot_inv_qty
369: from ap_invoice_distributions_all dist,
370: ap_payment_hist_dists paydist,
371: ap_invoices_all inv
372: where dist.po_distribution_id = p_po_dist
373: and dist.charge_applicable_to_dist_id is null --R12 change
374: and dist.related_id is null -- R12 change
375: and dist. line_type_lookup_code <> 'REC_TAX'

Line 393: ap_invoices_all inv

389: ELSE
390: select count(*), sum(dist.pa_quantity)
391: into l_inv_num, l_tot_inv_qty
392: from ap_invoice_distributions_all dist,
393: ap_invoices_all inv
394: where dist.po_distribution_id = p_po_dist
395: -- and dist.line_type_lookup_code = 'ITEM' --R12 change
396: and dist. line_type_lookup_code <> 'REC_TAX'
397: and nvl(reversal_flag,'N') <> 'Y' /* Bug 5673779 */

Line 830: FROM ap_invoices_all

826: -- these records to 'G' status during "PRC : Interface supplier cost" process.
827:
828: CURSOR C_Valid_Invoice IS
829: SELECT 1
830: FROM ap_invoices_all
831: WHERE invoice_id = p_invoice_id
832: AND invoice_type_lookup_code <> 'EXPENSE REPORT'
833: AND nvl(source, 'xx' ) NOT IN ('PA_COST_ADJUSTMENTS');
834:

Line 841: FROM ap_invoices_all

837: -- R12.PJ:XB9:QA:APL: PREPAYMENT IN FOREIGN CURRENCY - FUNC COST INCORRECT IN PSI
838: --
839: CURSOR C_currency_attributes IS
840: SELECT exchange_rate
841: FROM ap_invoices_all
842: WHERE invoice_id = p_invoice_id ;
843:
844: l_av number;
845: l_base_av number;