APPS.JL_ZZ_AP_WITHHOLDING_PKG dependencies on PO_LINE_LOCATIONS

Line 1891: l_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;

1887: -- l_dist_line_num ap_invoice_distributions.invoice_distribution_id%TYPE;
1888: l_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1889:
1890: l_po_distribution_id ap_invoice_distributions.po_distribution_id%TYPE;
1891: l_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;
1892: l_debug_info Varchar2(300);
1893: l_calling_sequence Varchar2(2000);
1894: v_country_code Varchar2(100);
1895:

Line 2009: FROM po_line_locations poll

2005: -- Obtains the ship to location for the distribution line
2006: ----------------------------------------------------------
2007: SELECT poll.ship_to_location_id
2008: INTO l_ship_to_location_id
2009: FROM po_line_locations poll
2010: WHERE line_location_id = (SELECT line_location_id
2011: FROM po_distributions
2012: WHERE po_distribution_id = l_po_distribution_id);
2013: */