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.PER_HU_EMP_CERT_ARCHIVE dependencies on HR_GENERAL

Line 78: ,nvl(hr_general.decode_lookup('HU_COUNTY', addr.region_2),addr.region_2) c_county

74: CURSOR csr_comp_address(c_business_group_id NUMBER) IS
75: SELECT hoi.organization_id organization_id
76: ,addr.postal_code c_postal_code
77: ,addr.town_or_city c_town
78: ,nvl(hr_general.decode_lookup('HU_COUNTY', addr.region_2),addr.region_2) c_county
79: ,addr.address_line_1 c_location_name
80: ,nvl(hr_general.decode_lookup('HU_LOCATION_TYPES', addr.address_line_2),addr.address_line_2) c_location_type
81: ,addr.address_line_3 c_street_number
82: ,addr.loc_information14 c_building

Line 80: ,nvl(hr_general.decode_lookup('HU_LOCATION_TYPES', addr.address_line_2),addr.address_line_2) c_location_type

76: ,addr.postal_code c_postal_code
77: ,addr.town_or_city c_town
78: ,nvl(hr_general.decode_lookup('HU_COUNTY', addr.region_2),addr.region_2) c_county
79: ,addr.address_line_1 c_location_name
80: ,nvl(hr_general.decode_lookup('HU_LOCATION_TYPES', addr.address_line_2),addr.address_line_2) c_location_type
81: ,addr.address_line_3 c_street_number
82: ,addr.loc_information14 c_building
83: ,addr.loc_information15 c_stairway
84: ,addr.loc_information16 c_floor

Line 285: ,nvl(hr_general.decode_lookup('HU_LOCATION_TYPES', addr.address_line2),addr.address_line2) location_type

281: CURSOR csr_person_addr IS
282: SELECT addr.postal_code
283: ,addr.town_or_city town
284: ,addr.address_line1 location_name
285: ,nvl(hr_general.decode_lookup('HU_LOCATION_TYPES', addr.address_line2),addr.address_line2) location_type
286: ,addr.address_line3 street_number
287: ,addr.add_information14 building
288: ,addr.add_information15 stairway
289: ,addr.add_information16 floor

Line 390: , ' '||nvl(hr_general.decode_lookup('HU_LOCATION_TYPES', addr.address_line_2),addr.address_line_2))

386: ,decode(addr.town_or_city,NULL,NULL,addr.town_or_city||',')
387: ||decode(addr.postal_code,NULL,NULL,' '||addr.postal_code)
388: ||decode(addr.address_line_1, NULL, NULL, ' '||addr.address_line_1)
389: ||decode(addr.address_line_2, NULL, NULL
390: , ' '||nvl(hr_general.decode_lookup('HU_LOCATION_TYPES', addr.address_line_2),addr.address_line_2))
391: ||decode(addr.address_line_3, NULL, NULL, ' '||addr.address_line_3||'. ')
392: ||decode(addr.loc_information14, NULL, NULL, addr.loc_information14||'.')
393: ||decode(addr.loc_information15, NULL, NULL, addr.loc_information15||'.')
394: ||decode(addr.loc_information16, NULL, NULL, addr.loc_information16||'.')