APPS.HR_REPORTS dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 169: hr_all_organization_units_tl to get

165: 115.18 02-NOV-02 eumenyio Added nocopy
166: 115.19 12-DEC-02 joward MLS enabled grade_name
167: 115.20 27-DEC-02 joward MLS enabled job name
168: 115.21 17-FEB-03 rthiagar Fix for bug 3440744. Used
169: hr_all_organization_units_tl to get
170: business group name to support
171: translation.
172: 115.22 22-JUN-04 adhunter MLS enabled per_absence_attendance_types.name
173: 115.23 07-FEB-05 smparame 4081149 New fucntion get_party_number added.

Line 267: from hr_all_organization_units_tl orgtl,

263: select orgtl.name,
264: hrl.meaning
265: into p_org_name,
266: p_org_type
267: from hr_all_organization_units_tl orgtl,
268: hr_all_organization_units org,
269: hr_lookups hrl
270: where org.organization_id = p_organization_id
271: and org.organization_id = orgtl.organization_id

Line 596: from hr_all_organization_units_tl org

592: begin
593: hr_utility.set_location('hr_reports.get_business_group',10);
594: select org.name
595: into v_business_group_name
596: from hr_all_organization_units_tl org
597: -- where org.organization_id + 0 = p_business_group_id
598: -- Changed for Performance Fix: Bug 4328224
599: where org.organization_id = p_business_group_id
600: and org.language(+) = userenv('LANG');