APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 67: l_ou_name HR_ALL_ORGANIZATION_UNITS_TL.name%TYPE;

63: l_err_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
64: l_err_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
65: i NUMBER;
66:
67: l_ou_name HR_ALL_ORGANIZATION_UNITS_TL.name%TYPE;
68:
69: -- iProc defined value for org_id if item is valid for All OU's.
70: g_OU_REQD CONSTANT NUMBER := -2;
71:

Line 228: FROM HR_ALL_ORGANIZATION_UNITS_TL HAOUTL

224: -- Get the Operating Unit name
225: BEGIN
226: SELECT name
227: INTO l_ou_name
228: FROM HR_ALL_ORGANIZATION_UNITS_TL HAOUTL
229: WHERE HAOUTL.organization_id = l_err_org_ids(i)
230: AND language = userenv('LANG');
231: EXCEPTION
232: WHEN OTHERS THEN