APPS.AP_IMPORT_UTILITIES_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 3416: FROM ap_supplier_sites_all

3412: p_invoice_amount_limit,
3413: p_hold_future_payments_flag,
3414: p_supplier_hold_reason,
3415: p_exclude_freight_from_disc
3416: FROM ap_supplier_sites_all
3417: WHERE vendor_id = p_invoice_rec.vendor_id
3418: AND vendor_site_id = p_invoice_rec.vendor_site_id;
3419: EXCEPTION
3420: WHEN no_data_found THEN

Line 4357: ap_supplier_sites_all aps

4353:
4354: Cursor c_ship_to (c_invoice_id NUMBER) Is
4355: Select aps.ship_to_location_id
4356: From ap_invoices_all ai,
4357: ap_supplier_sites_all aps
4358: Where ai.invoice_id = c_invoice_id
4359: And ai.vendor_site_id = aps.vendor_site_id;
4360:
4361: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;

Line 4361: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;

4357: ap_supplier_sites_all aps
4358: Where ai.invoice_id = c_invoice_id
4359: And ai.vendor_site_id = aps.vendor_site_id;
4360:
4361: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
4362: -- bug# 6989166 starts
4363: p_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
4364: -- bug# 6989166 ends
4365: */

Line 4363: p_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;

4359: And ai.vendor_site_id = aps.vendor_site_id;
4360:
4361: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
4362: -- bug# 6989166 starts
4363: p_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
4364: -- bug# 6989166 ends
4365: */
4366: --bug 15862708
4367: BEGIN