APPS.JL_ZZ_GLOBE_VAL_PKG dependencies on HR_LOCATIONS_ALL

Line 139: from hr_locations_all

135:
136: BEGIN
137:
138: select count(1) into dummy
139: from hr_locations_all
140: where global_attribute8 = p_company_name
141: and substrb(nvl(global_attribute_category,'XX.XX'),4,2) = p_country_code
142: and ((p_rowid is null) or (rowid <> p_rowid));
143:

Line 363: l_ship_to_location_code hr_locations_all.location_code%type; --bug 2238543: VARCHAR2(30);

359:
360:
361: FUNCTION get_ship_to_location_code(p_po_distribution_id IN NUMBER) RETURN VARCHAR2 IS
362:
363: l_ship_to_location_code hr_locations_all.location_code%type; --bug 2238543: VARCHAR2(30);
364:
365: BEGIN
366: SELECT hl.location_code
367: INTO l_ship_to_location_code

Line 368: FROM hr_locations_all hl

364:
365: BEGIN
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

Line 553: FROM hr_locations_all

549: l_rowid varchar2(100);
550: BEGIN
551:
552: SELECT rowid into l_rowid
553: FROM hr_locations_all
554: WHERE location_id = p_location_id;
555: p_row_id := l_rowid;
556: EXCEPTION
557: WHEN NO_DATA_FOUND THEN