DBA Data[Home] [Help]

APPS.WIP_WS_UTIL dependencies on HR_ORGANIZATION_UNITS

Line 354: HR_ORGANIZATION_UNITS ORG

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
358: A.ASSIGNMENT_TYPE = 'E' AND