DBA Data[Home] [Help]

APPS.EAM_ASSIGN_EMP_PUB dependencies on PER_PEOPLE_F

Line 674: per_people_f ppf

670: FROM bom_departments bd,
671: bom_department_resources bdr,
672: bom_dept_res_instances bdri,
673: bom_resource_employees bre,
674: per_people_f ppf
675: WHERE bd.organization_id = p_organization_id
676: AND ( bd.disable_date IS NULL
677: OR (bd.disable_date > sysdate))
678: AND (p_department_id IS NULL

Line 1345: per_people_f ppf

1341: FROM wip_operation_resource_usage woru ,
1342: wip_discrete_jobs wdj,
1343: eam_work_order_details ewod,
1344: bom_resource_employees bre,
1345: per_people_f ppf
1346: WHERE ppf.person_id = p_person_id
1347: AND ppf.business_group_id = HR_GENERAL.GET_BUSINESS_GROUP_ID
1348: AND ppf.EFFECTIVE_START_DATE <= sysdate
1349: AND ppf.EFFECTIVE_END_DATE > sysdate