DBA Data[Home] [Help]

APPS.WIP_WS_TIME_ENTRY dependencies on PER_PERSON_TYPES

Line 3524: PER_PERSON_TYPES T,

3520: SELECT wrat.employee_id, NVL(P.EMPLOYEE_NUMBER, P.NPW_NUMBER)
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

Line 3558: PER_PERSON_TYPES T,

3554: SELECT NVL(P.EMPLOYEE_NUMBER, P.NPW_NUMBER)
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