APPS.JL_ZZ_GLOBE_VAL_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 372: FROM po_distributions_all pd

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;
375:
376: EXCEPTION