APPS.PO_PA_INTEGRATION_GRP dependencies on PO_LINE_LOCATIONS_ALL

Line 100: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;

96:
97: l_api_name CONSTANT VARCHAR2(30) := 'validate_temp_labor_po';
98: l_api_version CONSTANT NUMBER := 1.0;
99:
100: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
101: l_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE; --BUG#7046429
102: l_person_id PER_ALL_PEOPLE_F.person_id%TYPE;
103: l_assignment_id NUMBER;
104:

Line 193: FROM po_line_locations_all

189: -- Sql What : Gets the po line location id for a given po line id
190: -- Sql Why : To check the shipment status
191: SELECT line_location_id
192: INTO l_line_location_id
193: FROM po_line_locations_all
194: WHERE po_line_id = p_po_line_id;
195:
196: Exception
197: When others then