APPS.JL_ZZ_GLOBE_VAL_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 370: FROM po_line_locations_all pll

366: SELECT hl.location_code
367: INTO l_ship_to_location_code
368: FROM hr_locations_all hl
369: WHERE hl.location_id = (SELECT pll.ship_to_location_id
370: FROM po_line_locations_all pll
371: WHERE pll.line_location_id = (SELECT pd.line_location_id
372: FROM po_distributions_all pd
373: WHERE pd.po_distribution_id = p_po_distribution_id));
374: RETURN l_ship_to_location_code;