DBA Data[Home] [Help]

APPS.WIP_WS_TIME_ENTRY dependencies on PER_PEOPLE_F

Line 3522: FROM PER_PEOPLE_F P,

3518: --Bug 14595358, Contingent Worker Project, can no longer use mtl_employees_current_view
3519: --as mtl_employees_current_view only have employees and doesn't have contingent worker records
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

Line 3556: FROM PER_PEOPLE_F P,

3552: --Bug 14595358, Contingent Worker Project, can no longer use mtl_employees_current_view
3553: --as mtl_employees_current_view only have employees and doesn't have contingent worker records
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