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 1348: per_people_f ppf

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