DBA Data[Home] [Help]

APPS.WIP_WS_UTIL dependencies on PER_ASSIGNMENTS_F

Line 354: PER_ASSIGNMENTS_F A,

350: CURSOR emp_valid_cursor IS
351: SELECT count(distinct BRE.PERSON_ID) employee_count,
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

Line 379: PER_ASSIGNMENTS_F A,

375: CURSOR npw_valid_cursor IS
376: SELECT count(distinct BRE.PERSON_ID) employee_count,
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