DBA Data[Home] [Help]

APPS.INVPVDR5 dependencies on HR_ORGANIZATION_UNITS

Line 1650: PO_AGENTS POA , HR_ORGANIZATION_UNITS ORG

1646: AND PPF.PERSON_ID = cr.BUYER_ID;
1647: else
1648: SELECT 'x' into temp
1649: FROM PER_PEOPLE_F PPF,
1650: PO_AGENTS POA , HR_ORGANIZATION_UNITS ORG
1651: WHERE PPF.PERSON_ID = POA.AGENT_ID
1652: AND PPF.BUSINESS_GROUP_ID= ORG.BUSINESS_GROUP_ID
1653: AND ORG.ORGANIZATION_ID = cr.ORGANIZATION_ID
1654: AND SYSDATE BETWEEN NVL(POA.START_DATE_ACTIVE, SYSDATE-1)