APPS.INVPVDR5 dependencies on PER_PEOPLE_F

Line 1606: -- Bug 4695915 - Replacing references to per_all_workforce_v with per_people_f

1602: begin
1603:
1604: -- Lines changed by Ppeddama on 2/2/2000 for bug#1171778
1605: -- For the bug fix 3845910 from base bug 3810566-- anmurali
1606: -- Bug 4695915 - Replacing references to per_all_workforce_v with per_people_f
1607:
1608: if (nvl(hr_general.get_xbg_profile, 'N') = 'Y') then
1609: SELECT 'x' into temp
1610: FROM PER_PEOPLE_F PPF,

Line 1610: FROM PER_PEOPLE_F PPF,

1606: -- Bug 4695915 - Replacing references to per_all_workforce_v with per_people_f
1607:
1608: if (nvl(hr_general.get_xbg_profile, 'N') = 'Y') then
1609: SELECT 'x' into temp
1610: FROM PER_PEOPLE_F PPF,
1611: PO_AGENTS POA, PER_BUSINESS_GROUPS_PERF PB
1612: WHERE PPF.PERSON_ID = POA.AGENT_ID
1613: AND PPF.BUSINESS_GROUP_ID= PB.BUSINESS_GROUP_ID
1614: AND SYSDATE BETWEEN NVL(POA.START_DATE_ACTIVE, SYSDATE-1)

Line 1620: FROM PER_PEOPLE_F PPF,

1616: AND TRUNC(SYSDATE) BETWEEN PPF.EFFECTIVE_START_DATE AND PPF.EFFECTIVE_END_DATE
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