APPS.JL_ZZ_AP_WITHHOLDING_PKG dependencies on PO_LINE_LOCATIONS

Line 1941: l_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;

1937: -- l_dist_line_num ap_invoice_distributions.invoice_distribution_id%TYPE;
1938: l_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1939:
1940: l_po_distribution_id ap_invoice_distributions.po_distribution_id%TYPE;
1941: l_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;
1942: l_debug_info Varchar2(300);
1943: l_calling_sequence Varchar2(2000);
1944: v_country_code Varchar2(100);
1945:

Line 2057: FROM po_line_locations poll

2053: -- Obtains the ship to location for the distribution line
2054: ----------------------------------------------------------
2055: SELECT poll.ship_to_location_id
2056: INTO l_ship_to_location_id
2057: FROM po_line_locations poll
2058: WHERE line_location_id = (SELECT line_location_id
2059: FROM po_distributions
2060: WHERE po_distribution_id = l_po_distribution_id);
2061: */