DBA Data[Home] [Help]

APPS.PO_R12_CAT_UPG_DEF_PVT dependencies on PO_AGENTS

Line 1300: FROM PO_AGENTS BUYER, PER_EMPLOYEES_CURRENT_X HRE,

1296: SELECT agent_id
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)