APPS.EAM_ASSIGN_EMP_PUB dependencies on BOM_DEPARTMENT_RESOURCES

Line 275: FROM bom_department_resources bdr2

271: AND seq_num IS NOT NULL ;
272:
273: CURSOR l_check_res_24_hour_csr_type(p_dept_id NUMBER,p_resource_id NUMBER) IS
274: SELECT bdr2.available_24_hours_flag AS available_24
275: FROM bom_department_resources bdr2
276: WHERE bdr2.department_id = p_dept_id
277: AND bdr2.resource_id = p_resource_id ;
278:
279: l_available_hour NUMBER:=0;

Line 671: bom_department_resources bdr,

667: ppf.person_id,
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

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.share_from_dept_id, bdr.department_id, /*bug 10213972/11776366 -pass share_from_dept_id, indicates borrowed resources*/
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 ) ;