DBA Data[Home] [Help]

APPS.INVPVDR5 dependencies on PER_BUSINESS_GROUPS_PERF

Line 1640: PO_AGENTS POA, PER_BUSINESS_GROUPS_PERF PB

1636:
1637: if (nvl(hr_general.get_xbg_profile, 'N') = 'Y') then
1638: SELECT 'x' into temp
1639: FROM PER_PEOPLE_F PPF,
1640: PO_AGENTS POA, PER_BUSINESS_GROUPS_PERF PB
1641: WHERE PPF.PERSON_ID = POA.AGENT_ID
1642: AND PPF.BUSINESS_GROUP_ID= PB.BUSINESS_GROUP_ID
1643: AND SYSDATE BETWEEN NVL(POA.START_DATE_ACTIVE, SYSDATE-1)
1644: AND NVL(POA.END_DATE_ACTIVE,SYSDATE+1)