APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on BOM_DEPARTMENTS

Line 177: from bom_department_resources bdr, bom_departments bd

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

Line 819: from wip_operations wo, bom_departments bd

815: -- Get Department Id and Department Code
816:
817: select bd.department_id,bd.department_code
818: into l_department_id, l_department_code
819: from wip_operations wo, bom_departments bd
820: where wo.wip_entity_id = l_wip_entity_id and wo.organization_id = l_organization_id
821: and wo.operation_seq_num = l_operation_seq_num and wo.department_id = bd.department_id(+);
822:
823: l_stmt_num := 140;