DBA Data[Home] [Help]

APPS.INVPVDR5 dependencies on HR_ORGANIZATION_UNITS

Line 1621: PO_AGENTS POA , HR_ORGANIZATION_UNITS ORG

1617: AND PPF.PERSON_ID = cr.BUYER_ID;
1618: else
1619: SELECT 'x' into temp
1620: FROM PER_PEOPLE_F PPF,
1621: PO_AGENTS POA , HR_ORGANIZATION_UNITS ORG
1622: WHERE PPF.PERSON_ID = POA.AGENT_ID
1623: AND PPF.BUSINESS_GROUP_ID= ORG.BUSINESS_GROUP_ID
1624: AND ORG.ORGANIZATION_ID = cr.ORGANIZATION_ID
1625: AND SYSDATE BETWEEN NVL(POA.START_DATE_ACTIVE, SYSDATE-1)