APPS.POR_ITEM_ATTRIBUTES_PKG dependencies on HR_LOCATIONS_ALL_TL

Line 114: from hr_locations_all_tl hrtl1, hr_locations_all_tl hrtl2

110: l_progress := 'add_attribute_attachment: 000';
111: PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);
112:
113: select hrtl2.location_code into l_template_name
114: from hr_locations_all_tl hrtl1, hr_locations_all_tl hrtl2
115: where hrtl1.location_id = hrtl2.location_id
116: and hrtl2.language = userenv('LANG')
117: and hrtl1.location_code = l_profile_value
118: and hrtl1.language in