APPS.AP_APXT7UTT_XMLP_PKG dependencies on PO_VENDOR_SITES

Line 363: from po_vendor_sites pvs

359: P_end_date );
360: ELSE
361: UPDATE ap_invoice_distributions id
362: SET income_tax_region = (select pvs.state
363: from po_vendor_sites pvs
364: where pvs.tax_reporting_site_flag= 'Y'
365: and pvs.vendor_id=vendor_id_R)
366: WHERE id.invoice_id in (SELECT i.invoice_id
367: FROM AP_Invoices i, AP_Invoice_Payments ip

Line 374: (select pvs2.state from po_vendor_sites pvs2

370: AND i.invoice_id = ip.invoice_id
371: AND nvl(ip.accounting_date,sysdate) between
372: P_start_date and P_end_date )
373: AND nvl(id.income_tax_region,'DuMmY') <>
374: (select pvs2.state from po_vendor_sites pvs2
375: where pvs2.tax_reporting_site_flag= 'Y'
376: and pvs2.vendor_id=vendor_id_R);
377:
378: