APPS.EAM_ASSIGN_EMP_PUB dependencies on BOM_DEPT_RES_INSTANCES

Line 672: bom_dept_res_instances bdri,

668: ppf.full_name,
669: ppf.employee_number
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

Line 747: FROM bom_dept_res_instances bdri2 , bom_department_resources bdr

743: --get the department id and the resource id for the instance id from bom_department_resorce_instances
744: CURSOR l_dept_res_id_csr_type(p_inst_id IN NUMBER,p_department_id IN NUMBER) IS
745: SELECT bdr.department_id,
746: bdr.resource_id
747: FROM bom_dept_res_instances bdri2 , bom_department_resources bdr
748: WHERE bdri2.instance_id = p_inst_id
749: AND bdri2.resource_id = bdr.resource_id
750: AND ( p_department_id IS NULL OR bdr.department_id = p_department_id )
751: AND ( p_department_id IS NULL OR bdri2.department_id = p_department_id OR bdri2.department_id = bdr.share_from_dept_id ) ;