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
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