APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on BOM_DEPARTMENT_RESOURCES

Line 136: FROM BOM_RESOURCES BR, BOM_DEPARTMENT_RESOURCES BDR, AHL_WORKORDER_OPERATIONS_V AWV

132: BEGIN
133: IF (p_resource_code IS NOT NULL) THEN
134: SELECT DISTINCT(BR.RESOURCE_ID)
135: INTO x_resource_id
136: FROM BOM_RESOURCES BR, BOM_DEPARTMENT_RESOURCES BDR, AHL_WORKORDER_OPERATIONS_V AWV
137: WHERE BR.RESOURCE_ID = BDR.RESOURCE_ID AND BDR.DEPARTMENT_ID = AWV.DEPARTMENT_ID
138: AND AWV.WORKORDER_ID = p_workorder_id AND BR.RESOURCE_CODE = p_resource_code;
139: END IF;
140:

Line 1076: BOM_DEPARTMENT_RESOURCES

1072:
1073: -- To find the resource sequence nubmer from ahl_operation_resources
1074: CURSOR c_resources (x_id IN NUMBER) IS
1075: SELECT DEPARTMENT_ID FROM
1076: BOM_DEPARTMENT_RESOURCES
1077: WHERE RESOURCE_ID = x_id;
1078:
1079: -- To find the resource sequence nubmer from ahl_operation_resources
1080: CURSOR c_wo_dept (x_id IN NUMBER) IS

Line 2178: BOM_DEPARTMENT_RESOURCES

2174:
2175: -- To find the resource sequence nubmer from ahl_operation_resources
2176: CURSOR c_resources (x_id IN NUMBER) IS
2177: SELECT DEPARTMENT_ID FROM
2178: BOM_DEPARTMENT_RESOURCES
2179: WHERE RESOURCE_ID = x_id;
2180:
2181: -- To find the UOM_CODE from MTL_UNITS_OF_MEASURE table
2182: CURSOR c_UOM (x_name IN VARCHAR2) IS