APPS.PO_R12_CAT_UPG_DEF_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1301: HR_ALL_ORGANIZATION_UNITS HROU

1297: FROM
1298: (
1299: SELECT BUYER.agent_id
1300: FROM PO_AGENTS BUYER, PER_EMPLOYEES_CURRENT_X HRE,
1301: HR_ALL_ORGANIZATION_UNITS HROU
1302: WHERE HRE.EMPLOYEE_ID = BUYER.AGENT_ID
1303: AND SYSDATE BETWEEN NVL(BUYER.START_DATE_ACTIVE, SYSDATE-1)
1304: AND NVL(BUYER.END_DATE_ACTIVE, SYSDATE+1)
1305: AND HROU.organization_id = x_headers_rec.org_id(i)