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.PO_GA_PVT dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 134: l_name HR_ALL_ORGANIZATION_UNITS_TL.name%TYPE;

130: --End of Comments
131: --------------------------------------------------------------------------------
132: FUNCTION get_org_name(p_org_id IN NUMBER) RETURN VARCHAR2
133: IS
134: l_name HR_ALL_ORGANIZATION_UNITS_TL.name%TYPE;
135: BEGIN
136:
137: SELECT name
138: INTO l_name

Line 139: FROM hr_all_organization_units_tl

135: BEGIN
136:
137: SELECT name
138: INTO l_name
139: FROM hr_all_organization_units_tl
140: WHERE organization_id = p_org_id
141: AND language = USERENV('LANG');
142:
143: return (l_name);

Line 361: hr_all_organization_units_tl hrou

357: INTO x_global_agreement_flag,
358: x_owning_org_id,
359: x_owning_org_name
360: FROM po_headers_all poh,
361: hr_all_organization_units_tl hrou
362: WHERE poh.po_header_id = p_po_header_id
363: AND hrou.organization_id = poh.org_id
364: AND hrou.language = USERENV('LANG');
365: