APPS.PO_POXRVXRV_XMLP_PKG dependencies on HR_LOCATIONS_ALL

Line 17: from hr_locations_all

13: if (P_location is not null) then
14:
15: select location_id
16: into p_location_id
17: from hr_locations_all
18: where location_code = P_location;
19:
20: end if;
21: /*End Bug 12998409*/

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

347: return (TRUE);
348: end;
349:
350: function location_code1formula(location in varchar2, Shipment_type in varchar2, location_id1 in number) return char is
351: x_location_code hr_locations_all.location_code%TYPE := NULL ;
352:
353: begin
354:
355: x_location_code := location;

Line 368: from hr_locations_all hrl,

364: BEGIN
365:
366: select hrtl.location_code
367: into x_location_code
368: from hr_locations_all hrl,
369: hr_locations_all_tl hrtl
370: where hrl.location_id = location_id1
371: and hrl.location_id = hrtl.location_id
372: and hrtl.language = userenv('LANG');

Line 369: hr_locations_all_tl hrtl

365:
366: select hrtl.location_code
367: into x_location_code
368: from hr_locations_all hrl,
369: hr_locations_all_tl hrtl
370: where hrl.location_id = location_id1
371: and hrl.location_id = hrtl.location_id
372: and hrtl.language = userenv('LANG');
373:

Line 396: from hr_locations_all

392: if (P_location is not null) then
393:
394: select location_id
395: into p_location_id
396: from hr_locations_all
397: where location_code = P_location;
398:
399: end if;
400: