3521: into l_employee_id, l_employee_num
3522: FROM PER_PEOPLE_F P,
3523: PER_ASSIGNMENTS_F A,
3524: PER_PERSON_TYPES T,
3525: HR_ORGANIZATION_UNITS ORG,
3526: wip_resource_actual_times wrat
3527: WHERE A.PERSON_ID = P.PERSON_ID AND
3528: ORG.BUSINESS_GROUP_ID = P.BUSINESS_GROUP_ID AND
3529: A.PRIMARY_FLAG = 'Y' AND
3555: into l_employee_num
3556: FROM PER_PEOPLE_F P,
3557: PER_ASSIGNMENTS_F A,
3558: PER_PERSON_TYPES T,
3559: HR_ORGANIZATION_UNITS ORG
3560: WHERE A.PERSON_ID = P.PERSON_ID AND
3561: ORG.BUSINESS_GROUP_ID = P.BUSINESS_GROUP_ID AND
3562: A.PRIMARY_FLAG = 'Y' AND
3563: A.ASSIGNMENT_TYPE in ('C','E') AND