DBA Data[Home] [Help]

APPS.WIP_WS_UTIL dependencies on HR_ORGANIZATION_UNITS

Line 356: HR_ORGANIZATION_UNITS ORG,

352: min(BRE.PERSON_ID) employee_id
353: FROM PER_PEOPLE_F P,
354: PER_ASSIGNMENTS_F A,
355: PER_PERSON_TYPES T,
356: HR_ORGANIZATION_UNITS ORG,
357: BOM_RESOURCE_EMPLOYEES BRE
358: WHERE A.PERSON_ID = P.PERSON_ID AND
359: ORG.BUSINESS_GROUP_ID = P.BUSINESS_GROUP_ID AND
360: A.PRIMARY_FLAG = 'Y' AND

Line 381: HR_ORGANIZATION_UNITS ORG,

377: min(BRE.PERSON_ID) employee_id
378: FROM PER_PEOPLE_F P,
379: PER_ASSIGNMENTS_F A,
380: PER_PERSON_TYPES T,
381: HR_ORGANIZATION_UNITS ORG,
382: BOM_RESOURCE_EMPLOYEES BRE
383: WHERE A.PERSON_ID = P.PERSON_ID AND
384: ORG.BUSINESS_GROUP_ID = P.BUSINESS_GROUP_ID AND
385: A.PRIMARY_FLAG = 'Y' AND