APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

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 122: FROM HR_ALL_ORGANIZATION_UNITS HAOU

118: AND (l_org_ids(i) IS NULL
119: OR l_org_ids(i) = g_OU_REQD -- where g_OU_REQD is -2 (iProc defined this value)
120: OR NOT EXISTS
121: (SELECT 'ORG_ID exists'
122: FROM HR_ALL_ORGANIZATION_UNITS HAOU
123: WHERE HAOU.organization_id = l_org_ids(i)
124: ))
125: RETURNING interface_header_id, org_id
126: BULK COLLECT INTO l_err_interface_header_ids, l_err_org_ids;

Line 181: FROM HR_ALL_ORGANIZATION_UNITS HAOU

177: AND l_org_ids(i) IS NOT NULL
178: AND l_org_ids(i) <> g_OU_REQD -- where g_OU_REQD is -2 (iProc defined this value)
179: AND EXISTS
180: (SELECT 'ORG_ID exists'
181: FROM HR_ALL_ORGANIZATION_UNITS HAOU
182: WHERE HAOU.organization_id = l_org_ids(i)
183: )
184: -- ECO bug 5584556: End
185: AND (

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