DBA Data[Home] [Help]

APPS.AHL_LTP_RESRC_LEVL_PUB dependencies on HR_ALL_ORGANIZATION_UNITS

Line 89: FROM BOM_DEPARTMENTS A, HR_ALL_ORGANIZATION_UNITS B

85: IF (p_x_req_resources.dept_name IS NOT NULL AND
86: p_x_req_resources.dept_name <> FND_API.G_MISS_CHAR) THEN
87: --
88: SELECT department_id INTO l_department_id
89: FROM BOM_DEPARTMENTS A, HR_ALL_ORGANIZATION_UNITS B
90: WHERE A.ORGANIZATION_ID = B.ORGANIZATION_ID
91: AND B.NAME = p_x_req_resources.org_name
92: AND A.description = p_x_req_resources.dept_name;
93: --

Line 298: FROM BOM_DEPARTMENTS A, HR_ALL_ORGANIZATION_UNITS B

294: IF (p_req_resources.dept_name IS NOT NULL AND
295: p_req_resources.dept_name <> FND_API.G_MISS_CHAR) THEN
296: --
297: SELECT department_id INTO l_department_id
298: FROM BOM_DEPARTMENTS A, HR_ALL_ORGANIZATION_UNITS B
299: WHERE A.ORGANIZATION_ID = B.ORGANIZATION_ID
300: AND B.NAME = p_req_resources.org_name
301: AND A.description = p_req_resources.dept_name;
302: --