APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on BOM_DEPARTMENTS

Line 181: from bom_department_resources bdr, bom_departments bd

177: Resources can be charged w/o an employee.Proper employee are fetched in Employees LOV in JSP */
178:
179: CURSOR c_charge_dept_cur(l_temp_res_id4 NUMBER) IS
180: select distinct bd.department_code, bd.department_id
181: from bom_department_resources bdr, bom_departments bd
182: where bdr.department_id = bd.department_id
183: and bdr.resource_id = l_temp_res_id4 ;
184:
185:

Line 752: from wip_operations wo, bom_departments bd

748: -- Get Department Id and Department Code
749:
750: select bd.department_id,bd.department_code
751: into l_department_id, l_department_code
752: from wip_operations wo, bom_departments bd
753: where wo.wip_entity_id = l_wip_entity_id and wo.organization_id = l_organization_id
754: and wo.operation_seq_num = l_operation_seq_num and wo.department_id = bd.department_id(+);
755:
756: l_stmt_num := 140;