eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_US_REPORTS dependencies on HR_LOCATIONS

Line 103: Change the selection of all rows from hr_locations and

99: the problem of fetching more than one row.
100:
101: 40.23 26-FEB-1997 hekim In get_address_3lines, take substring of city name
102: 40.24 28-Jul-1997 nlee Change pay_state_rules to pay_us_states in get_state_name.
103: Change the selection of all rows from hr_locations and
104: per_addresses in get_address and get_employee_address
105: functions to selection of the specific rows that are
106: needed to increase performance and avoid overflow problem.
107: Change the sql statement to cursor statement in get_new_hire_contact

Line 175: FROM hr_locations loc,

171: AND NVL(addr.date_to, IN_payment_date);
172:
173: CURSOR c_get_o_payee IS
174: SELECT SUBSTR(hou.name,1,240)
175: FROM hr_locations loc,
176: hr_organization_units hou
177: WHERE hou.organization_id = IN_payee_id
178: AND hou.business_group_id = IN_business_group_id
179: AND IN_payment_date BETWEEN hou.date_from

Line 372: v_address_line_1 hr_locations.address_line_1%TYPE;

368: procedure get_address(p_location_id in number, p_address out nocopy varchar2) IS
369: --
370: f_address varchar2(300) := NULL;
371: --
372: v_address_line_1 hr_locations.address_line_1%TYPE;
373: v_address_line_2 hr_locations.address_line_2%TYPE;
374: v_address_line_3 hr_locations.address_line_3%TYPE;
375: v_town_or_city hr_locations.town_or_city%TYPE;
376: v_region_2 hr_locations.region_2%TYPE;

Line 373: v_address_line_2 hr_locations.address_line_2%TYPE;

369: --
370: f_address varchar2(300) := NULL;
371: --
372: v_address_line_1 hr_locations.address_line_1%TYPE;
373: v_address_line_2 hr_locations.address_line_2%TYPE;
374: v_address_line_3 hr_locations.address_line_3%TYPE;
375: v_town_or_city hr_locations.town_or_city%TYPE;
376: v_region_2 hr_locations.region_2%TYPE;
377: v_postal_code hr_locations.postal_code%TYPE;

Line 374: v_address_line_3 hr_locations.address_line_3%TYPE;

370: f_address varchar2(300) := NULL;
371: --
372: v_address_line_1 hr_locations.address_line_1%TYPE;
373: v_address_line_2 hr_locations.address_line_2%TYPE;
374: v_address_line_3 hr_locations.address_line_3%TYPE;
375: v_town_or_city hr_locations.town_or_city%TYPE;
376: v_region_2 hr_locations.region_2%TYPE;
377: v_postal_code hr_locations.postal_code%TYPE;
378: --

Line 375: v_town_or_city hr_locations.town_or_city%TYPE;

371: --
372: v_address_line_1 hr_locations.address_line_1%TYPE;
373: v_address_line_2 hr_locations.address_line_2%TYPE;
374: v_address_line_3 hr_locations.address_line_3%TYPE;
375: v_town_or_city hr_locations.town_or_city%TYPE;
376: v_region_2 hr_locations.region_2%TYPE;
377: v_postal_code hr_locations.postal_code%TYPE;
378: --
379: cursor get_location_record is

Line 376: v_region_2 hr_locations.region_2%TYPE;

372: v_address_line_1 hr_locations.address_line_1%TYPE;
373: v_address_line_2 hr_locations.address_line_2%TYPE;
374: v_address_line_3 hr_locations.address_line_3%TYPE;
375: v_town_or_city hr_locations.town_or_city%TYPE;
376: v_region_2 hr_locations.region_2%TYPE;
377: v_postal_code hr_locations.postal_code%TYPE;
378: --
379: cursor get_location_record is
380: select address_line_1, address_line_2, address_line_3,

Line 377: v_postal_code hr_locations.postal_code%TYPE;

373: v_address_line_2 hr_locations.address_line_2%TYPE;
374: v_address_line_3 hr_locations.address_line_3%TYPE;
375: v_town_or_city hr_locations.town_or_city%TYPE;
376: v_region_2 hr_locations.region_2%TYPE;
377: v_postal_code hr_locations.postal_code%TYPE;
378: --
379: cursor get_location_record is
380: select address_line_1, address_line_2, address_line_3,
381: town_or_city, region_2, postal_code

Line 382: from hr_locations

378: --
379: cursor get_location_record is
380: select address_line_1, address_line_2, address_line_3,
381: town_or_city, region_2, postal_code
382: from hr_locations
383: where location_id = p_location_id;
384: --
385: begin
386: --

Line 447: address_record hr_locations%rowtype;

443: --
444: procedure get_address_31(p_location_id in number, p_address out nocopy varchar2) IS
445: f_address varchar2(155) := NULL;
446: f_city_state varchar2(50) := NULL;
447: address_record hr_locations%rowtype;
448: cursor get_location_record is
449: select *
450: from hr_locations
451: where location_id = p_location_id;

Line 450: from hr_locations

446: f_city_state varchar2(50) := NULL;
447: address_record hr_locations%rowtype;
448: cursor get_location_record is
449: select *
450: from hr_locations
451: where location_id = p_location_id;
452: begin
453: open get_location_record;
454: fetch get_location_record into address_record;

Line 644: address_record hr_locations%rowtype;

640: --
641: --
642: procedure get_county_address(p_location_id in number, p_address out nocopy varchar2) IS
643: f_address varchar2(300) := NULL;
644: address_record hr_locations%rowtype;
645: cursor get_location_record is
646: select * from hr_locations
647: where location_id = p_location_id;
648: begin

Line 646: select * from hr_locations

642: procedure get_county_address(p_location_id in number, p_address out nocopy varchar2) IS
643: f_address varchar2(300) := NULL;
644: address_record hr_locations%rowtype;
645: cursor get_location_record is
646: select * from hr_locations
647: where location_id = p_location_id;
648: begin
649: open get_location_record;
650: fetch get_location_record into address_record;

Line 1505: FROM hr_locations

1501: --
1502: begin
1503: SELECT location_code
1504: INTO l_location_code
1505: FROM hr_locations
1506: WHERE location_id = p_location_id;
1507: --
1508: return l_location_code;
1509: --

Line 1665: ,hr_locations_all eloc

1661: from
1662: per_gen_hierarchy_nodes pghn1
1663: ,hr_location_extra_info hlei1
1664: ,hr_location_extra_info hlei2
1665: ,hr_locations_all eloc
1666: where
1667: (pghn1.hierarchy_version_id = P_HIERARCHY_VERSION_ID
1668: and pghn1.node_type = 'EST'
1669: and eloc.location_id = pghn1.entity_id