DBA Data[Home] [Help]

APPS.WIP_WS_TIME_ENTRY dependencies on HR_ORGANIZATION_UNITS

Line 3525: HR_ORGANIZATION_UNITS ORG,

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

Line 3559: HR_ORGANIZATION_UNITS ORG

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