349: -- Bug 14595358, Contingent Worker Project
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
374: -- Bug 14595358, Contingent Worker Project
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