DBA Data[Home] [Help]

APPS.WIP_WS_TIME_ENTRY dependencies on PER_ASSIGNMENTS_F

Line 3523: PER_ASSIGNMENTS_F A,

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
3527: WHERE A.PERSON_ID = P.PERSON_ID AND

Line 3557: PER_ASSIGNMENTS_F A,

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
3561: ORG.BUSINESS_GROUP_ID = P.BUSINESS_GROUP_ID AND