APPS.BOM_MIXED_MODEL_MAP_PVT dependencies on BOM_DEPARTMENT_RESOURCES

Line 26: TYPE dept_id_type is TABLE of bom_department_resources.department_id%TYPE

22: G_PERIODS CONSTANT NUMBER := 3;
23: --below is new code
24: TYPE resource_id_type is TABLE of bom_resources.resource_id%TYPE
25: INDEX BY BINARY_INTEGER;
26: TYPE dept_id_type is TABLE of bom_department_resources.department_id%TYPE
27: INDEX BY BINARY_INTEGER;
28: --above is new code
29:
30: -- ========================== ConvertTime ===================================

Line 297: FROM bom_department_resources bdr

293: FOR i IN 1..p_resource_index - 1 LOOP
294: DECLARE
295: CURSOR GetCapacityUnits IS
296: SELECT bdr.capacity_units CU
297: FROM bom_department_resources bdr
298: WHERE bdr.department_id = p_dept_table(i)
299: AND bdr.resource_id = p_resource_table(i);
300: BEGIN
301: FOR c1rec IN GetCapacityUnits LOOP