DBA Data[Home] [Help]

APPS.WIP_WS_UTIL dependencies on PER_PERSON_TYPES

Line 353: PER_PERSON_TYPES T,

349: SELECT count(distinct p.person_id), min(p.PERSON_ID)
350: into l_count, l_emp_id
351: FROM PER_PEOPLE_F P,
352: PER_ASSIGNMENTS_F A,
353: PER_PERSON_TYPES T,
354: HR_ORGANIZATION_UNITS ORG
355: WHERE A.PERSON_ID = P.PERSON_ID AND
356: ORG.BUSINESS_GROUP_ID = P.BUSINESS_GROUP_ID AND
357: A.PRIMARY_FLAG = 'Y' AND