APPS.AP_IMPORT_UTILITIES_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 2728: FROM ap_supplier_sites_all

2724: p_invoice_amount_limit,
2725: p_hold_future_payments_flag,
2726: p_supplier_hold_reason,
2727: p_exclude_freight_from_disc
2728: FROM ap_supplier_sites_all
2729: WHERE vendor_id = p_invoice_rec.vendor_id
2730: AND vendor_site_id = p_invoice_rec.vendor_site_id;
2731: EXCEPTION
2732: WHEN no_data_found THEN

Line 3656: ap_supplier_sites_all aps

3652:
3653: Cursor c_ship_to (c_invoice_id NUMBER) Is
3654: Select aps.ship_to_location_id
3655: From ap_invoices_all ai,
3656: ap_supplier_sites_all aps
3657: Where ai.invoice_id = c_invoice_id
3658: And ai.vendor_site_id = aps.vendor_site_id;
3659:
3660: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;

Line 3660: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;

3656: ap_supplier_sites_all aps
3657: Where ai.invoice_id = c_invoice_id
3658: And ai.vendor_site_id = aps.vendor_site_id;
3659:
3660: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
3661: -- bug# 6989166 starts
3662: p_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
3663: -- bug# 6989166 ends
3664:

Line 3662: p_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;

3658: And ai.vendor_site_id = aps.vendor_site_id;
3659:
3660: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
3661: -- bug# 6989166 starts
3662: p_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
3663: -- bug# 6989166 ends
3664:
3665: BEGIN
3666: -- Update the calling sequence