APPS.PO_POXRVXRV_XMLP_PKG dependencies on HR_LOCATIONS_ALL

Line 333: x_location_code hr_locations_all.location_code%TYPE := NULL ;

329: return (TRUE);
330: end;
331:
332: function location_code1formula(location in varchar2, Shipment_type in varchar2, location_id1 in number) return char is
333: x_location_code hr_locations_all.location_code%TYPE := NULL ;
334:
335: begin
336:
337: x_location_code := location;

Line 350: from hr_locations_all hrl,

346: BEGIN
347:
348: select hrtl.location_code
349: into x_location_code
350: from hr_locations_all hrl,
351: hr_locations_all_tl hrtl
352: where hrl.location_id = location_id1
353: and hrl.location_id = hrtl.location_id
354: and hrtl.language = userenv('LANG');

Line 351: hr_locations_all_tl hrtl

347:
348: select hrtl.location_code
349: into x_location_code
350: from hr_locations_all hrl,
351: hr_locations_all_tl hrtl
352: where hrl.location_id = location_id1
353: and hrl.location_id = hrtl.location_id
354: and hrtl.language = userenv('LANG');
355:

Line 378: from hr_locations_all

374: if (P_location is not null) then
375:
376: select location_id
377: into p_location_id
378: from hr_locations_all
379: where location_code = P_location;
380:
381: end if;
382: