APPS.HR_GENERAL dependencies on HR_LOCATIONS

Line 142: alogue 01/03/2000 115.26 Support of change to hr_locations.

138: the profile value to cache thus aiding
139: performance.
140: alogue 14/02/2000 115.24 Utf8 support.
141: hsajja 21/02/2000 115.25 Included function DECODE_SHARED_TYPE
142: alogue 01/03/2000 115.26 Support of change to hr_locations.
143: rvydyana 24/05/2000 115.27 Added new function get_xbg_profile
144: mbocutt 06/06/2000 115.29 Fixed error in function descriptions
145: for get_work/home_phone
146: tclewis 29-feb-2000 115.30 added function maintain_tax_Records.

Line 653: from hr_locations

649: p_error_if_invalid boolean default TRUE ) return boolean is
650: --
651: cursor csr_location is
652: select 1
653: from hr_locations
654: where location_id = p_location_id
655: and location_use = 'HR'
656: and nvl (inactive_date, c_end_of_time) >= p_date;
657: --

Line 1065: from hr_locations

1061: p_location_id number) return varchar2 is
1062: --
1063: cursor csr_lookup is
1064: select location_code
1065: from hr_locations
1066: where location_id = p_location_id
1067: and location_use = 'HR';
1068: --
1069: v_meaning hr_locations.location_code%TYPE := null;

Line 1069: v_meaning hr_locations.location_code%TYPE := null;

1065: from hr_locations
1066: where location_id = p_location_id
1067: and location_use = 'HR';
1068: --
1069: v_meaning hr_locations.location_code%TYPE := null;
1070: --
1071: begin
1072: --
1073: -- Only open the cursor if the parameter is going to retrieve anything

Line 1947: from hr_locations LOC1

1943: LOC1.REGION_3||decode(LOC1.REGION_3,null,'',', ')|| LOC1.POSTAL_CODE||
1944: decode(LOC1.POSTAL_CODE,null,'',', ')|| LOC1.COUNTRY||
1945: decode(LOC1.COUNTRY,null,' ',', ')
1946: ,1,600)
1947: from hr_locations LOC1
1948: where location_id = p_location_id
1949: and location_use = 'HR';
1950: --
1951: v_address varchar2(600) := null;